ADM_T189_ORG_EC

(SQL Table)
 Index Back

Adm Applicant Org EC

Admissions Application Electronic Commerce EDI Staging Table. Organization (Institution) record for TS189 Applicant transactions. Use ADM_T189_ORG_EC to store external Institutions a student has attended.

  • 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    7 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    8 MATCH_NBR Number(6,0) INTEGER NOT NULL Number of Matches
    9 EDIT_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Processsing Options
    C=Complete
    E=Error
    P=Perform

    Default Value: P

    10 SRCH_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Search Match processing option
    C=Complete
    E=Error
    P=Perform

    Default Value: P

    11 POST_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Post Processing Option
    A=Awaiting Search/Match
    D=Delete Existing ID
    E=Error
    N=New ID Add
    P=Purge
    T=Take No Action
    U=Update Existing ID

    Default Value: A

    Prompt Table: XL_POST_PROC_VW

    12 FICE_CD Character(6) VARCHAR2(6) NOT NULL FICE Code

    Prompt Table: FICE_CD_VW

    13 ATP_CD Character(6) VARCHAR2(6) NOT NULL ATP Code

    Prompt Table: ATP_CODE_VW

    14 ACT_CD Character(6) VARCHAR2(6) NOT NULL ACT Code
    15 IPEDS_CD Character(6) VARCHAR2(6) NOT NULL IPEDS Code
    16 SCC_NCES_CD Character(12) VARCHAR2(12) NOT NULL National Center for Educatoin Statistics Code
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Default Value: SCHL

    Prompt Table: SCC_ORG_TYP_TBL

    19 EDI_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL Inbound School Type
    AS=Post-Secondary Record Sender
    AT=Post-Secondary Record Recipent
    HS=High School
    KR=Secondary Record Recipient
    KS=Secondary Record Sender
    KT=Secondary Record Recipient
    OS=Overriding Institution
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    25 CITY Character(30) VARCHAR2(30) NOT NULL City
    26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    33 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    37 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown
    38 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate
    39 EDI_INST_CD_QUAL Character(2) VARCHAR2(2) NOT NULL Institution Code Qualifier
    40 EDI_DT_ATT Character(35) VARCHAR2(35) NOT NULL Dates Attended
    41 CONTACT_CD Character(2) VARCHAR2(2) NOT NULL Contact Code
    42 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    43 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID