EX_APPR_CFG_TBL(SQL Table) |
Index Back |
|---|---|
Summary Approvals Setup table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  APPR_SUM_TRAN_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Transactions Type for Summary Approval configuration record
AT=Overview CA=Cash Advance EP=Errors ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
| 2 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 3 | PNLFIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Panel Field Name
Prompt Table: EX_PNLFLD_VW |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | SORT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sort Field
Y/N Table Edit Default Value: Y |
| 6 | SORT_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending D=Descending Default Value: A |
| 7 | SEARCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Source
Y/N Table Edit Default Value: Y |
| 8 | XLATVALUES | Character(1) | VARCHAR2(1) NOT NULL |
Translate Table Descriptions
Y/N Table Edit Default Value: N |