PSRECDEFNVW_LNG

(SQL View)
Index Back

Record Definition View

Record Definition Related Language record

select A.recname ,A.language_cd ,B.auditrecname ,B.setcntrlfld ,B.rellangrecname ,A.recdescr ,B.parentrecname ,A.descrlong from PSRECDEFNLANG A , psrecdefn B where A.recname = B.recname

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 AUDITRECNAME Character(15) VARCHAR2(15) NOT NULL Audit Record Name
4 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
5 RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name
6 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
7 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
8 DESCRLONG Long Character CLOB Long Description