TP_STDNT_DATE

(SQL Table)
Index Back

Contract Date

  • Parent record: TP_STUDENT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    3 TP_SEQ_NBR Number(7,0) INTEGER NOT NULL TP Sequence Number

    Default Value: TP_STUDENT.TP_SEQ_NBR

    4 FROM_DATE Date(10) DATE NOT NULL From Date
    5 TO_DATE Date(10) DATE Latest Date to be sent to PYR
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: TP_STUDENT.EMPLID

    7 USE_DUE_DATE Character(1) VARCHAR2(1) NOT NULL Use Date
    D=Due Days
    T=Due Date
    8 DEFER_DT_CHRG Date(10) DATE Defer Date Charges

    Default Value: TP_CONTRACT.DEFER_DT_CHRG

    9 DEFER_DAYS_CHRG Number(3,0) SMALLINT NOT NULL Defer Days Charges

    Default Value: TP_CONTRACT.DEFER_DAYS_CHRG

    10 TRANSFER_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Transfer Amt
    11 TRANSFER_DT Date(10) DATE Transfer Date
    12 ACTUAL_TRANS_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Actual Transfer Amt
    13 TRANSFER_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Status
    C=Complete Transfer
    N=No Transfer
    P=Partial Transfer

    Default Value: N

    14 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    15 MAX_TERM_AMT Number(15,2) DECIMAL(14,2) NOT NULL Max Term Amount
    16 SENT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Sent Amount
    17 SENT_DT Date(10) DATE Date Supplier Data Sent
    18 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    19 ADJUST_UNTIL_DATE Date(10) DATE Adjust Until Date
    20 ADJUST_AMOUNT Signed Number(13,2) DECIMAL(11,2) NOT NULL Adjust Amount
    21 TERM_DEFICIT_AMT Number(15,2) DECIMAL(14,2) NOT NULL Deficit Amount