COMBO_DATA_TBL(SQL Table) |
Index Back |
---|---|
ChartField Combo Data Tbl |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
|
2 | Character(10) | VARCHAR2(10) NOT NULL |
Process Group
Prompt Table: COMBO_GROUP_TBL |
|
3 | Character(10) | VARCHAR2(10) NOT NULL | Combination Rule | |
4 | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCOUNT_TBL |
|
5 | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table: ALTACCT_TBL |
|
6 | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
|
7 | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField | |
8 | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField | |
9 | Character(5) | VARCHAR2(5) NOT NULL | Fund Code | |
10 | Character(5) | VARCHAR2(5) NOT NULL | Class Field | |
11 | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField | |
12 | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference | |
13 | Character(5) | VARCHAR2(5) NOT NULL | Affiliate | |
14 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 | |
15 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate | |
16 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 | |
17 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 | |
18 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 | |
19 | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField | |
20 | Character(4) | VARCHAR2(4) NOT NULL | Book Code | |
21 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code | |
22 | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code | |
23 | VALID_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Indicator
N=Not Valid V=Valid Default Value: V |
24 | EFFDT_FROM | Date(10) | DATE NOT NULL | Effective Date From |
25 | EFFDT_OPEN | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
26 | EFFDT_TO | Date(10) | DATE NOT NULL | Effective Date To |