SCC_STG_ETH_DTL

(SQL Table)
 Index Back

Ethnicity Detail

ETHNICITY_DTL stores the detail Ethnicity of the person.

  • Parent record: SCC_STG_DIV_ETH

    • # 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

    Default Value: HCR_OPRDEF_HR_I.REG_REGION

    Prompt Table: HCR_REG_REGN_I

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

    Prompt Table: HCR_ETHNC_GRP_I

    4 ETHNIC_PCT_NUMRATR Number(3,0) SMALLINT NOT NULL Percentage - Numerator
    5 ETHNIC_PCT_DENMRTR Number(4,0) SMALLINT NOT NULL Percentage - Denominator
    6 ETH_VALIDATED Character(1) VARCHAR2(1) NOT NULL Is Ethnicity verified?

    Y/N Table Edit

    7 HISP_LATINO Character(1) VARCHAR2(1) NOT NULL Hispanic or Latino

    Y/N Table Edit

    8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    11 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    12 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    13 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time