EODP_RF_RFLD_VW

(SQL View)
 Index Back

Field sqlview for dynamic view


SELECT DISTINCT RF.RECNAME ,RF.FIELDNAME , RF.EODP_CTGRY_CD , RF.EODP_CLFNCD , RF.EODP_PERS_IDFR ,RF.EODP_SNSTV , RF.EODP_SYS_FLG ,FL.LONGNAME FROM ps_EODP_RECFIELD RF LEFT OUTER JOIN PSDBFLDLABL_VW FL ON FL.FIELDNAME = RF.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code
4 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code
5 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
A=All
N=No
Y=Yes
6 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
A=All
N=No
Y=Yes
7 EODP_SYS_FLG Character(1) VARCHAR2(1) NOT NULL System Data Flag
A=All
N=No
Y=Yes
8 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name