EDR_DEFN_CF_VW

(SQL View)
Index Back

EDR Defn CF

Effective Date Range definition for chartfields validation tables

SELECT RECNAME , EDR_RECNAME , FIELDNAME FROM PS_EDR_DEFN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: EDR_CF_REC_VW

2 EDR_RECNAME Character(15) VARCHAR2(15) NOT NULL Effective Date Range Table

Prompt Table: EDR_REC_VW

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EDR_CF_VW