APPR_TRANS_TYPECA=Cash Advance
ER=Expense Report
TA=Travel Authorization
TJ=Time Adjustment
TR=Time Report
PNLFIELDNAMEA=Ascending
D=Descending
EX_SORT_VW(SQL View) |
Index Back |
|---|
| SELECT B.APPR_SUM_TRAN_TYPE , A.PNLFIELDNAME , CASE WHEN (B.XLATVALUES = 'Y') THEN 10 ELSE C.FIELDTYPE END , A.LBLTEXT , B.SORT_ORDER FROM PSPNLFIELD A , PS_EX_APPR_CFG_TBL B , PSDBFIELD C WHERE A.PNLNAME = B.PNLNAME AND A.PNLFIELDNAME = B.PNLFIELDNAME AND B.PNLFIELDNAME = C.FIELDNAME AND SORT_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPR_TRANS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
| 2 | PNLFIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Panel Field Name |
| 3 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 4 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 5 | SORT_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending D=Descending |