DATA_FIELD_IDA=Activity
B=Balance
G=General
M=Metrics
U=User
AC=App Class
DI=Data Item
ST=String
Default Value: DI
N=No
Y=Yes
N=No
Y=Yes
SUPP_DFIELD_VW(SQL View) |
Index Back |
|---|
| SELECT DATA_FIELD_ID , AR_DESCR , DATA_CATEGORY , DATA_FIELD_TYPE , SYS_DEFINED_FLAG , VALUE_ROLLUP_FLG , STRING_TEXT FROM PS_SUPP_DATA_FIELD WHERE ACTIVE_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATA_FIELD_ID |
Character(8) | VARCHAR2(8) NOT NULL | Data Field ID |
| 2 | AR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DATA_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Data Item Category
A=Activity B=Balance G=General M=Metrics U=User |
| 4 | DATA_FIELD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Data Field Type
AC=App Class DI=Data Item ST=String Default Value: DI |
| 5 | SYS_DEFINED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
System defined flag
N=No Y=Yes |
| 6 | VALUE_ROLLUP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Rollup Value
N=No Y=Yes |
| 7 | STRING_TEXT | Character(100) | VARCHAR2(100) NOT NULL | String Text |