EOEP_APP_ADJ_VW

(SQL View)
Index Back

Application Code Adjust Method

Application code adjustment methods

SELECT eoep_app_cd , eoep_app_cd_field , %Substring(eoep_trans_value, 1, 1) FROM PS_EOEP_APP_CD_DTL WHERE eoep_app_cd_field = 'ADJ_METHOD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCD_VW

2 EOEP_APP_CD_FIELD Character(30) VARCHAR2(30) NOT NULL Transaction Code Field
3 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed