AV_IACRSLTVWLNG

(SQL View)
Index Back

Constituen Action Result codes

Constituent Action Result Codes

SELECT A.ACTN_RSLT_CD , A.EFFDT , B.LANGUAGE_CD , B.DESCRSHORT , B.DESCR FROM PS_AV_ACTN_RLT_TBL A , PS_AV_ACTN_RLT_LNG B WHERE A.ACTN_RSLT_CD = B.ACTN_RSLT_CD AND A.EFFDT = B.EFFDT AND A.INTV_ACTN_FLG='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACTN_RSLT_CD Character(6) VARCHAR2(6) NOT NULL Result Code
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: AV_ACTN_RLT_TBL.DESCR

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description