VALD_COMB_CD_VW

(SQL View)
Index Back

Combo Code Prompt

Combo Code Prompt Table for NA Payroll

SELECT DISTINCT A.SETID , A.FDM_COMBO_CD , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.ACCOUNT , A.DEPTID_CF , A.PROJECT_ID , A.PRODUCT , A.FUND_CODE , A.PROGRAM_CODE , A.CLASS_FLD , A.AFFILIATE , A.OPERATING_UNIT , A.ALTACCT , A.BUDGET_REF , A.CHARTFIELD1 , A.CHARTFIELD2 , A.CHARTFIELD3 , A.AFFILIATE_INTRA1 , A.AFFILIATE_INTRA2 FROM %Table(VALID_COMBO_VW) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department
9 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
10 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
11 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
12 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
13 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
14 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field
15 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
16 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
17 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
18 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
19 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
20 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate