DATA_MODEL_VW

(SQL View)
 Index Back

Approved data model changes


SELECT a.build_num , a.objectownerid , a.projectname , a.recname , a.descr_ln1 , a.descr_ln2 , a.descr_ln3 , a.name1_ac , a.date_added , b.objectownerid proj_owner , b.name1 , b.date_approved FROM ps_data_model a , PS_DATA_MODEL_CHGS b WHERE a.build_num = b.build_num AND a.projectname = b.projectname

  • Parent record: DATA_MODEL_CHGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUILD_NUM Character(5) VARCHAR2(5) NOT NULL Build Number
    2 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    3 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

    Prompt Table: PSPROJECTDEFN

    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    5 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1
    6 DESCR_LN2 Character(50) VARCHAR2(50) NOT NULL Description Line 2
    7 DESCR_LN3 Character(50) VARCHAR2(50) NOT NULL Description Line 3
    8 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    9 DATE_ADDED Date(10) DATE Date Added

    Default Value: %Date

    10 PROJ_OWNER Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    12 DATE_APPROVED Date(10) DATE Date Approved