ADM_APPL_TENDER

(SQL Table)
 Index Back

Appl Fee Tender

  • Parent record: ADM_APPL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: ADM_APPL_DATA.EMPLID

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: ADM_APPL_DATA.ACAD_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Default Value: ADM_APPL_DATA.STDNT_CAR_NBR

    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Default Value: ADM_APPL_DATA.ADM_APPL_NBR

    5 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
    CC=Credit Card
    CCI=Credit Card In
    CCO=Credit Card Out
    CK=Check
    CKI=Check In
    CKO=Check Out
    CS=Cash
    CSI=Cash In
    CSO=Cash Out
    DB=Debit Card
    DBI=Debit Card In
    DBO=Debit Card Out
    DD=Direct Deposit
    DDI=Direct Debit
    DDO=Direct Deposit
    EC=Electronic Check
    TP=Third Party Check
    TPI=Third Party Check In
    WIR=Wire Transfer
    6 TENDER_AMT Number(17,2) DECIMAL(16,2) NOT NULL Tender Amount
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    8 ORIGNL_TENDER_AMT Number(17,2) DECIMAL(16,2) NOT NULL Original Tender Amount
    9 ORIGNL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    10 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    11 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

    Default Value: 1

    12 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1

    13 CHECK_NUM_SF Character(30) VARCHAR2(30) NOT NULL Check Nbr
    14 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
    15 BANK_ACCT_TYP Character(1) VARCHAR2(1) NOT NULL Bank Account Type
    C=Checking
    S=Savings
    16 BANK_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL Bank Account Holder Name
    17 SSF_BNK_ACCT_NUM Character(44) VARCHAR2(44) NOT NULL Bank Account Number
    18 THIRD_PARTY Character(30) VARCHAR2(30) NOT NULL Third Party Check Name
    19 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
    20 TRACER_NBR Character(30) VARCHAR2(30) NOT NULL Tracer Number
    21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

    38 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    39 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    40 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL Credit Card Number
    41 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type

    Prompt Table: CREDIT_CARD_TYP

    42 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
    43 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
    44 CR_CARD_EXP_DT Date(10) DATE Expiration Date
    45 CR_CARD_STATUS Character(2) VARCHAR2(2) NOT NULL Credit Card Processing Status
    AC=Authorized Credit
    AS=Authorized
    AV=Authorized Void
    CR=Credit/Return
    ST=Settled
    SV=Settled Void/Credit
    UN=Pending Authorization
    VD=Void Sale
    VU=Void Unprocessed
    46 CR_CARD_ERRMSG Character(30) VARCHAR2(30) NOT NULL Credit Card Error Message
    47 CR_CARD_VDAUTH Character(10) VARCHAR2(10) NOT NULL Credit Card Void Auth Code
    48 CR_CARD_DECLND Character(1) VARCHAR2(1) NOT NULL Credit Card Declined
    49 CR_CARD_ISSUER Character(20) VARCHAR2(20) NOT NULL Credit Card Issuer
    50 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Authorization Code
    51 CR_CARD_AUTH_DT Date(10) DATE Auth Date
    52 CR_CARD_AUTH_REPLY Character(15) VARCHAR2(15) NOT NULL Authorization Reply
    53 CR_CARD_AVS_CD Character(1) VARCHAR2(1) NOT NULL Credit Card AVS Return Code
    54 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
    55 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Credit Card Authorization DTTM
    56 SF_MERCHANT_ID Character(12) VARCHAR2(12) NOT NULL SF Merchant ID
    57 CR_CARD_SRVC_PROV Character(2) VARCHAR2(2) NOT NULL Credit Card Service Provider
    01=Cybersource
    02=TouchNet
    99=Unsupported
    58 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
    59 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
    60 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID