APPR_TRANS_TYPECA=Cash Advance
ER=Expense Report
TA=Travel Authorization
TJ=Time Adjustment
TR=Time Report
PNLFIELDNAMELANGUAGE_CDEX_SORT_L_VW(SQL View) |
Index Back |
|---|
| SELECT B.APPR_SUM_TRAN_TYPE , A.PNLFIELDNAME , C.LANGUAGE_CD , C.LONGNAME FROM PSPNLFIELD A , PS_EX_APPR_CFG_TBL B , PSDBFLDLABLLANG C WHERE A.PNLNAME = B.PNLNAME AND A.PNLFIELDNAME = B.PNLFIELDNAME AND A.PNLFIELDNAME = C.FIELDNAME AND A.LABEL_ID = C.LABEL_ID AND B.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |