GTAS_ELEMENT_CF(SQL Table) |
Index Back |
|---|---|
GTAS Data Element Fldnme |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | Attribute | |
| 2 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: CF_ACTIVE_VW |
| 4 | ALLOW_FLD_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Allow GTAS Field Change
Default Value: N |
| 5 | ATTR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Attribute Type
C=Chartfield Attribute L=Ledger Attribute Default Value: C |