GPFR_DACDVW_LNG(SQL View) |
Index Back |
---|---|
Releated langauge view DADSReleated langauge view for DADS Codes. This is used as the prompt in the DADS update pages. |
SELECT A.GPFR_DA_DATTYP , A.GPFR_DA_CODE , A.LANGUAGE_CD , A.GPFR_DA_DESCR FROM PS_GPFR_DA_COD_LNG A , PS_GPFR_DA_CODE B WHERE A.GPFR_DA_DATTYP = B.GPFR_DA_DATTYP AND A.GPFR_DA_CODE = B.GPFR_DA_CODE AND B.GPFR_DA_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(10) | VARCHAR2(10) NOT NULL | DADS related field | |
2 | Character(10) | VARCHAR2(10) NOT NULL | DADS related field | |
3 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
4 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |