PERSON_IDSHEET_IDDefault Value: NEXT
SPA_HDR_ADD_VW(SQL View) |
Index Back |
|---|---|
Expense Sheet Add ViewExpense Sheet Add View |
| SELECT DISTINCT b.person_id , a.sheet_id FROM ps_spa_sheet_hdr a , PS_SPB_SERVICE_PRV b WHERE a.person_id = b.person_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT |