EMPLIDADVANCE_IDDefault Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
EX_ADV_SEL_VW(SQL View) |
Index Back |
|---|---|
Advances Available To ApplyThis view lists Cash Advances ready to apply to an Expense Sheet. |
| SELECT A.EMPLID , A.ADVANCE_ID , A.ADVANCE_NAME , A.BALANCE , A.CURRENCY_CD FROM PS_EX_ADV_HDR A WHERE ADV_STATUS='PD' AND A.BALANCE >0 AND (EXISTS ( SELECT 'X' FROM PS_EX_SHEET_HDR B WHERE B.CREDIT_ADV = A.ADVANCE_ID AND B.SHEET_STATUS = 'PD') OR NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_HDR C WHERE C.CREDIT_ADV = A.ADVANCE_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 3 | ADVANCE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Advance Description |
| 4 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY |