EOEP_APP_CDEOEP_ADJ_METHOD1=Cascading
2=Summed
EFFDTLANGUAGE_CDEOEP_ADJMTH_LVW(SQL View) |
Index Back |
|---|---|
Adjust method by transAdjust method by trans |
| SELECT D.EOEP_APP_CD , %Substring(FIELDVALUE , 1 , 1) , X.EFFDT , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEMLANG X WHERE D.EOEP_APP_CD_FIELD = 'ADJ_METHOD' AND X.FIELDNAME = 'EOEP_ADJ_METHOD' AND ( (D.EOEP_TRANS_VALUE = '1' AND X.FIELDVALUE = '1') OR (D.EOEP_TRANS_VALUE = '2' AND X.FIELDVALUE = '2') ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEP_APP_CD |
Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 2 | EOEP_ADJ_METHOD |
Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading 2=Summed |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |