PIN_TAKE_NUMLANGUAGE_CDHGA_EA_ABTYP_LV(SQL View) |
Index Back |
|---|---|
Language Absence Type ViewLanguage Absence Type View used for Fluid Extended Absence |
| SELECT DISTINCT A.PIN_NUM ,LANG.LANGUAGE_CD ,LANG.DESCR ,T.ABS_TYPE_OPTN ,T.DESCR ,'' FROM PS_GP_PIN A ,PS_GP_ABS_TAKE B ,PS_GP_ABS_TYPE T ,PS_GP_PIN_LANG LANG WHERE A.PIN_NUM=B.PIN_NUM AND A.USED_BY=T.USED_BY AND A.COUNTRY=T.COUNTRY AND B.ABS_TYPE_OPTN=T.ABS_TYPE_OPTN AND T.REQUEST_IND = 'Y' AND %EffdtCheck(GP_ABS_TAKE, B, %CurrentDateIn) AND T.EFF_STATUS = 'A' AND A.PIN_NUM = LANG.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | ABS_NAME | Character(40) | VARCHAR2(40) NOT NULL | Absence Name |
| 4 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |