ADM_T189_PER_EC

(SQL Table)
 Index Back

Adm Applicant Per EC

Admissions Application Electronic Commerce EDI Staging Table. Personal data record for TS189 Applicant transactions. Use ADM_T189_PER_EC to store personal and demographic data about an employee or applicant including name, birthdate, and ethnic group.

  • Parent record: ADM_T189_HDR_EC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
    2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound
    4 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number
    5 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr
    6 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    7 EDI_ENTY_TP_QUAL Character(1) VARCHAR2(1) NOT NULL Entity Type Qualifier
    1=Person
    2=Non-Person Entity
    8 EDI_REF_NBR Character(30) VARCHAR2(30) NOT NULL EDI Reference Number
    9 EDI_REF_NBR_QUAL Character(2) VARCHAR2(2) NOT NULL EDI Reference Number Qualifier
    30=United States Govern Visa Nbr
    48=Agency's Student Number
    49=Family Unit Number
    4A=Personal Identification Number
    50=State Student ID Number
    56=Corrected SSN
    57=Prior Incorrect SSN
    A6=Employee Identification Number
    C0=Canadian Social Insurance Nbr
    E4=Charge Card
    LR=Local Student Id Nbr
    MV=Migrant Number
    SY=Social Security Number
    V2=Visa Type
    V4=State Department I-20 Form Nbr
    V5=State Depart IAP-66 Form Nbr
    ZZ=Mutually Defined
    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    11 LAST_NAME_EDI Character(30) VARCHAR2(30) NOT NULL Last Name
    12 FIRST_NAME_EDI Character(30) VARCHAR2(30) NOT NULL First Name
    13 MIDDLE_INIT_EDI Character(30) VARCHAR2(30) NOT NULL Middle Initial
    14 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    15 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    16 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    17 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    18 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec

    Default Value: U

    19 AGE_STATUS Character(1) VARCHAR2(1) NOT NULL Age 18 or Older

    Y/N Table Edit

    Default Value: Y

    20 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Y/N Table Edit

    Default Value: N

    21 OFFICIAL_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Official Language
    22 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed

    Default Value: S

    23 BIRTHDATE Date(10) DATE Date of Birth
    24 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    25 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country

    Prompt Table: COUNTRY_TBL

    26 BIRTHCNTRY_APP Character(3) VARCHAR2(3) NOT NULL TS189 Birth Country
    27 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

    Prompt Table: BIRTHSTATE_VW

    28 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

    Default Value: A

    29 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student

    Y/N Table Edit

    Default Value: N

    30 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    31 ETHNIC_GROUP Character(1) VARCHAR2(1) NOT NULL Ethnic Group
    1=White
    2=Black/African American
    3=Hispanic/Latino
    4=Asian
    5=American Indian/Alaska Native
    6=Not Specified
    7=Native Hawaiian/Oth Pac Island
    A=American Indian/Alaskan Native
    B=Asian or Pacific Islander
    C=Black, not of Hispanic origin
    D=Hispanic
    E=White, not of Hispanic origin
    F=Asian Indian
    G=Chinese
    H=Filipino
    J=Guamanian
    K=Hawaiian
    L=Japanese
    M=Korean
    N=Samoan
    P=Vietnamese
    Q=All Other Asian o Pacific Is
    Y=Not Hispanic in Puerto Rico

    Default Value: 6

    32 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Default Value: 1

    Prompt Table: ADM_USA_CIT_VW

    33 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)
    34 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA

    Y/N Table Edit

    Default Value: N

    35 AGE Number(3,0) SMALLINT NOT NULL Age
    36 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID
    37 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    38 EDI_DESCR1 Character(80) VARCHAR2(80) NOT NULL Description 1
    39 EDI_DATE1_FMT_TYPE Character(3) VARCHAR2(3) NOT NULL Date/Time Period Qualifier
    CC=CCYY
    CM=CCYYMM
    CY=CCYY
    D8=CCYYMMDD
    DB=MMDDCCYY
    MD=MMDD
    YY=YY
    40 BIRTH_COUNTY Character(5) VARCHAR2(5) NOT NULL Birth County
    41 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

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

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    43 SAD_IPEDS_ETHNIC Character(1) VARCHAR2(1) NOT NULL IPEDS Ethnicity
    44 SAD_IPEDS_RACE1 Character(1) VARCHAR2(1) NOT NULL IPEDS Race Response 1
    45 SAD_IPEDS_RACE2 Character(1) VARCHAR2(1) NOT NULL IPEDS Race Response 2
    46 SAD_IPEDS_RACE3 Character(1) VARCHAR2(1) NOT NULL IPEDS Race Response 3
    47 SAD_IPEDS_RACE4 Character(1) VARCHAR2(1) NOT NULL IPEDS Race Response 4
    48 SAD_IPEDS_RACE5 Character(1) VARCHAR2(1) NOT NULL IPEDS Race Response 5
    49 SAD_IPEDS_ETH_MAP0 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    50 SAD_IPEDS_ETH_MAP1 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    51 SAD_IPEDS_ETH_MAP2 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    52 SAD_IPEDS_ETH_MAP3 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    53 SAD_IPEDS_ETH_MAP4 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION

    54 SAD_IPEDS_ETH_MAP5 Character(8) VARCHAR2(8) NOT NULL Ethnic group code

    Prompt Table: ETHNIC_GRP_TBL
    Set Control Field: REG_REGION