SETIDPrompt Table: SP_SETID_NONVW
EX_ROLEPrompt Table:
EX_ROLE_TBL
Set Control Field: SETID
EX_ROLE_VT_VW(SQL View) |
Index Back |
|---|---|
Expense Role Options-VAT ViewThe view of Expense Role Options-VAT. |
| SELECT A.SETID , A.EX_ROLE FROM PS_EX_ROLE_TBL A , PS_EX_ROLE_EXCP_VT B WHERE B.SETID = A.SETID AND B.EX_ROLE = A.EX_ROLE AND %EffdtCheck(EX_ROLE_TBL D,A,%CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | EX_ROLE |
Character(5) | VARCHAR2(5) NOT NULL |
Expense Processing Role
Prompt Table:
EX_ROLE_TBL
|