ADVANCE_IDDefault Value: NEXT
EX_AUTO_ADV_VW(SQL View) |
Index Back |
|---|---|
Auto Advance ViewUsed to select Cash Advances that are to be created automatically |
| SELECT A.ADVANCE_ID , A.EMPLID FROM PS_EX_ADV_HDR A , PS_PERSONAL_DATA B WHERE B.EMPLID=A.EMPLID AND A.RECREATE_DATE <= %CurrentDateIn AND A.REOCCURRING_ADV='Y' AND A.RECREATE_STATUS='A' AND A.ADV_STATUS='PD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Advance ID
Default Value: NEXT |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |