EMPLIDPrompt Table: PERSONAL_DATA
SHEET_IDDefault Value: NEXT
EX_JRNL_ADD_VW(SQL View) |
Index Back |
|---|---|
Expense Sheet Add View |
| SELECT DISTINCT A.EMPLID , A.SHEET_ID FROM PS_EX_SHEET_HDR A , PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID AND A.POST_STATUS_EX='P' AND A.SHEET_STATUS='PD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT |