SCC_ENTREG_VW

(SQL View)
 Index Back

Entity Registry View

Entity Registry View

SELECT A.SCC_ENTITY_ID , A.SCC_STATUS , A.SCC_ENTITY_NAME , A.SCC_ENTITY_TYPE_ID , A.SCC_ENTITY_DESCR , A.SCC_APPCLASSNAME , B.SCC_ENT_TYPE_DEFAC , A.SCC_RECNAME , A.SCC_STG_RECNAME , A.SCC_ELEMENT_NAME , A.SCC_APPLY_UPD_RULE , A.SCC_ENT_PT_AUDIT , %subrec(SCC_AUDIT_SBR, A) FROM %Table(SCC_ENTITY_REG) A , %Table(SCC_ENTITY_TYPE) B WHERE A.SCC_ENTITY_TYPE_ID=B.SCC_ENTITY_TYPE_ID

  • Related Language Record: SCC_ENTREG_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    2 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Active
    I=Inactive
    3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    4 SCC_ENTITY_TYPE_ID Character(40) VARCHAR2(40) NOT NULL Entity Type ID

    Prompt Table: SCC_ENTITY_TYPE

    5 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
    6 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

    Prompt Table: SCC_APPCLASS_PT

    7 SCC_ENT_TYPE_DEFAC Character(190) VARCHAR2(190) NOT NULL Entity Type Default Class

    Prompt Table: SCC_APPCLASS_PT

    8 SCC_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: SCC_REC_PT

    9 SCC_STG_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: SCC_REC_PT

    10 SCC_ELEMENT_NAME Character(30) VARCHAR2(30) NOT NULL Element Name
    11 SCC_APPLY_UPD_RULE Character(1) VARCHAR2(1) NOT NULL Apply Data Update Rule

    Y/N Table Edit

    Default Value: N

    12 SCC_ENT_PT_AUDIT Character(1) VARCHAR2(1) NOT NULL Denotes if Peopletools auditing should be done for an entity.

    Y/N Table Edit

    Default Value: N

    13 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    14 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    15 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    16 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time