ADM_T189_RES_EC

(SQL Table)
 Index Back

Adm Applicant Res EC

Admissions Application Electronic Commerce EDI Staging Table. Residence record for TS189 Applicant transactions. Use ADM_T189_RES_EC to store residencies of a student.

  • 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

    Default Value: I

    4 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number
    5 EDI_INDUSTRY_CD Character(2) VARCHAR2(2) NOT NULL Industry Code
    01=Length of Continuous Residency
    02=Previous Residency
    03=Registered to Vote
    04=Voted
    05=Vehicle Registered
    06=Drivers License
    07=Purchase of Res Property
    08=Property Tax Paid
    09=State Income Tax Return Filed
    10=Employed in State
    11=Earned in State
    12=Military Service Home of Recrd
    13=Military Duty Station
    14=Financial Assist from State
    6 EDI_RELATION_CD Character(2) VARCHAR2(2) NOT NULL Relationship Code
    01=Spouse
    03=Father or Mother
    26=Guardian
    32=Mother
    33=Father
    34=Other Adult
    48=Stepfather
    49=Stepmother
    50=Foster Parent
    7 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    8 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    10 EDI_LOC_QUAL Character(2) VARCHAR2(2) NOT NULL Location Qualifier
    AC=City and State
    CA=Country of Origin
    CC=Country
    CI=City
    CY=County
    DR=District of Residence
    DT=Domicile Type Code
    F=Current Address
    H=Home Address
    L=Local Address
    M=Mailing Address
    O=Office Address
    P=Permanent Address
    PT=3 Digit Canadian Postal Code
    PU=6 Digit Canadial Postal Code
    RE=Regional Education Service
    SB=Suburban
    SD=School District
    SP=State or Province
    SS=School
    TN=Township
    UR=Urban
    ZZ=Mutually Defined
    11 EDI_LOC_ID Character(35) VARCHAR2(35) NOT NULL TS189 Location Identification
    12 EDI_DATE1_QUAL Character(3) VARCHAR2(3) NOT NULL EDI Date 1 Qualifier
    007=Effective Date
    036=Expiration Date
    043=Publication Date
    050=Received Date
    055=Confirmed Date
    102=Issue Date
    103=Award Date
    196=Start Date
    197=End Date
    198=Completion Date
    222=Birth Date
    237=Student Signed
    270=Date Filed
    275=Approved Date
    330=Referral Date
    331=Evaluation Date
    332=Placement Date
    333=Individual Education Plan
    334=Re-evaluation Date
    335=Dismissal Date
    336=Employment Begin Date
    337=Employment End Date
    442=Date of Death
    467=Signature Date
    574=Action Begin Date
    576=Action End Date
    13 EDI_DATE1 Date(10) DATE Date 1
    14 EDI_QUANTY_QUAL Character(2) VARCHAR2(2) NOT NULL Quantitly Qualifier
    DY=Days
    HS=Hours
    MN=Months
    YY=Years
    15 EDI_QUANTITY Number(3,0) SMALLINT NOT NULL Quantity
    16 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID