ADM_T189_RQS_EC

(SQL Table)
 Index Back

Adm Applicant RQS EC

Admissions Applicant Electronic Commerce EDI Staging Table. Student Request for Information record for TS189 Applicant transactions. Use ADM_T189_RQS_EC to store frequently asked questions on the admissions application.

  • 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 EDI_COD_LST_QUAL Character(3) VARCHAR2(3) NOT NULL Code List Qualifier
    AQ=Application Question Qual
    ZZ=Free Form Question

    Default Value: AQ

    7 EDI_APPL_Q_ID_CD Character(2) VARCHAR2(2) NOT NULL Appl Question ID Code
    8 EDI_DESCR1 Character(80) VARCHAR2(80) NOT NULL Description 1
    9 EDI_YES_NO Character(1) VARCHAR2(1) NOT NULL Yes/No Condition
    N=No
    U=Unknown
    Y=Yes
    10 EDI_DESCR2 Character(80) VARCHAR2(80) NOT NULL Description 2
    11 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID