SAE_TARG_AUTVLN

(SQL View)
Index Back

View of authorized Targets

View of authorized Targets

SELECT A.OPRID ,A.SAE_TARGET_ID ,B.LANGUAGE_CD ,B.DESCR FROM %Table(SAE_TARG_AUTHVW) A , %Table(SAE_TARGET_LANG) B WHERE B.SAE_TARGET_ID = A.SAE_TARGET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID

Prompt Table: SAE_TARGET_ROLE

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description