BUSINESS_UNITCONTRACT_NUMEMPLIDA=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted
SSF_TP_STUNT_VW(SQL View) |
Index Back |
|---|---|
Payment Plan Inquiry viewPayment Plan Inquiry view |
| SELECT A.BUSINESS_UNIT , A.CONTRACT_NUM , A.EMPLID , A.TP_MAX_AMOUNT , A.PRE_PLAN_AMT , A.TOT_DEFER_AMT , C.NAME , A.TP_CON_NUM_PAYMENT , A.REF1_DESCR , A.TP_STATUS , A.COURSE_LIST , A.SSF_AGREEMENT_NBR FROM PS_TP_STUDENT A , PS_HCR_PERSON_NM_I C WHERE A.EMPLID = C.EMPLID |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | TP_MAX_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Maximum Amount |
| 5 | PRE_PLAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Pre-Payment Plan Amount |
| 6 | TOT_DEFER_AMT | Number(15,2) | DECIMAL(14,2) NOT NULL | Total Amount to Defer |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | TP_CON_NUM_PAYMENT | Number(3,0) | SMALLINT NOT NULL | Number Of Payments |
| 9 | REF1_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Reference Nbr |
| 10 | TP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Contract Status
A=Active C=Cancelled H=Hold I=Inactive U=Not Posted |
| 11 | COURSE_LIST | Character(9) | VARCHAR2(9) NOT NULL | Course List |
| 12 | SSF_AGREEMENT_NBR | Character(12) | VARCHAR2(12) NOT NULL | Agreement Number |