HGA_EA_ABTYP_VW(SQL View) |
Index Back |
---|---|
Absence Type ViewAbsence Type View used for Fluid Extended Absence |
SELECT DISTINCT A.PIN_NUM ,A.DESCR ,T.ABS_TYPE_OPTN ,T.DESCR ,'' FROM PS_GP_PIN A ,PS_GP_ABS_TAKE B ,PS_GP_ABS_TYPE T 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' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
2 | ABS_NAME | Character(40) | VARCHAR2(40) NOT NULL | Absence Name |
3 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |