GPFR_DA_CODE_VW(SQL View) |
Index Back |
---|---|
Active Cd Related to Data TypeDADS related view: active codes related to a data type definition. |
SELECT GPFR_DA_DATTYP , GPFR_DA_CODE , GPFR_DA_DESCR FROM PS_GPFR_DA_CODE WHERE GPFR_DA_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPFR_DA_DATTYP | Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
2 | GPFR_DA_CODE | Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
3 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |