EMPLIDPrompt Table: EX_EE_VALID_VW
SHEET_IDDefault Value: NEXT
EX_HDR2_ADD_VW(SQL View) |
Index Back |
|---|---|
Expense Sheet Add ViewExpense Sheet Add View for Central Entry |
| SELECT DISTINCT a.emplid , a.sheet_id FROM PS_EX_SHEET_HDR a , ps_personal_data b WHERE a.emplid = b.emplid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EX_EE_VALID_VW |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT |