SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
TEMPLATEPrompt Table: EX_TA_TMPLT_VW
EX_SHT_TMPLT_VW(SQL View) |
Index Back |
|---|---|
Expense Report TemplateStores expense report templates. |
| SELECT SETID , TEMPLATE , DESCR FROM PS_EX_TEMPLATE_TBL WHERE TEMPLATE_TYPE = 'E' AND EFFDT <= ( SELECT MAX(A.EFFDT) FROM PS_EX_TEMPLATE_TBL A WHERE A.SETID = SETID AND A.TEMPLATE = TEMPLATE AND A.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TEMPLATE |
Character(8) | VARCHAR2(8) NOT NULL | Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash advances, expense sheets and travel authorizations. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Prompt Table: EX_TA_TMPLT_VW |