SAD_APL_TND_STG

(SQL Table)
Index Back

Application Fee Tender

Stage and Load staging record for ADM_APPL_TENDER

  • Parent record: ADM_APPL_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    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
    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application 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

    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

    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 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr
    14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time