SCC_STG_DIV_ETH

(SQL Table)
Index Back

Ethnic Diversity

This table holds details of an employee's ethnic background. Created as a child of DIVERSIT record to allow recording of multiple Ethnic Group codes for each employee.

  • Parent record: SCC_STG_DIVRSTY
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    3 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL

    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    5 APS_EC_NDS_AUS Character(1) VARCHAR2(1) NOT NULL Employees have the option of not wanting to provide their ethnicity information. This field is required for the purpose of APS reporting only.

    Y/N Table Edit

    Default Value: N

    6 PRIMARY_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Indicator for Multiple

    Y/N Table Edit

    Default Value: N

    7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time