EOEP_APP_CDEOEP_ADJ_METHOD1=Cascading
2=Summed
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
EOEP_ADJMTH_VW(SQL View) |
Index Back |
|---|---|
Adjust method by transAdjust method by trans |
| SELECT D.EOEP_APP_CD , %Substring(FIELDVALUE , 1 , 1) , X.EFFDT , X.EFF_STATUS , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_EOEP_APP_CD_DTL D , PSXLATITEM 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
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |