TP_STDNT_DATE(SQL Table) |
Index Back |
---|---|
Contract Date |
# | 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 |