SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
EXPENSE_TYPEPrompt Table: EX_TYPES_TBL
EFFDTDefault Value: %date
EXPENSE_TYPE1Prompt Table: EX_TYPES_TBL
Prompt Table:
EX_PD_CALC_TBL
Set Control Field: SETID
EX_TYPE_PERDIEM(SQL Table) |
Index Back |
|---|---|
Per Diem Table |
| # | 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 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EXPENSE_TYPE1 |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 5 | DEDUCT_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | Deduction Percentage |
| 6 | DEDUCT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deduction Amount |
| 7 | EX_CALC_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Calculation Code
Prompt Table:
EX_PD_CALC_TBL
|