GPAU_ADVTYP_VW(SQL View) |
Index Back |
---|---|
Absence Advance Allowed TakesThis defines the Absence Take elements that the Advance Type is allowed to be used with. |
SELECT A.PIN_TAKE_NUM , A.GPAU_ADVANCE_TYPE , B.GPAU_ADV_DESCR FROM PS_GPAU_ADV_TAKE A , PS_GPAU_ADV_TYPE B WHERE A.GPAU_ADVANCE_TYPE = B.GPAU_ADVANCE_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
2 | GPAU_ADVANCE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | This code identifies options used in calculating advance payments for absence events. |
3 | GPAU_ADV_DESCR | Character(50) | VARCHAR2(50) NOT NULL | This is a description of the Advance Type. |