TP_STDNT_DATE(SQL Table) |
Index Back |
|---|---|
Contract Date |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | Character(25) | VARCHAR2(25) NOT NULL | Contract Number | |
| 3 | Number(7,0) | INTEGER NOT NULL |
TP Sequence Number
Default Value: TP_STUDENT.TP_SEQ_NBR |
|
| 4 | 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 |