GTAS_ELEMENT_CF(SQL Table) |
Index Back |
---|---|
GTAS Data Element Fldnme |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GTAS_ELEMENT | 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 |