SAD_AMC_CD_ETN

(SQL Table)
Index Back

AMCAS Ethnicity

AMCAS Ethnicity

  • Parent record: SAD_AMC_SUS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 TEST_DT Date(10) DATE Test Date
    3 RACE_ETHNIC_NBR Number(2,0) SMALLINT NOT NULL Race and Ethnicity Number
    4 AMCAS_SR_ETHNICITY Character(1) VARCHAR2(1) NOT NULL Self Reported Ethnicity
    5 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION