BUSINESS_UNITEMPLIDCONTRACT_NUMTP_SEQ_NBR1=Payment Plan Fee
2=Percentage of Payment Plan
3=Monthly Interest Rate
SSF_PAY_PLAN_VW(SQL View) |
Index Back |
|---|---|
Payment Plan viewView used in Self Service to display Contract Information. |
| SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.CONTRACT_NUM , B.TP_SEQ_NBR , B.PRE_PLAN_AMT , B.TP_CON_BILL_DT , C.TP_ASSESS_TYPE , SUM(A.ITEM_AMT) , SUM(A.APPLIED_AMT) FROM PS_ITEM_SF A , PS_TP_STUDENT B , PS_TP_CONTRACT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SA_ID_TYPE = 'P' AND B.EMPLID = A.COMMON_ID AND B.CONTRACT_NUM = C.CONTRACT_NUM AND A.ITEM_TYPE = C.ITEM_TYPE AND A.CONTRACT_NUM = B.CONTRACT_NUM AND C.TP_CON_TYPE = 'P' AND C.TP_CON_LAST_COR_DT >= %CurrentDateIn AND b.TP_STATUS = 'A' GROUP BY A.BUSINESS_UNIT, A.COMMON_ID, A.SA_ID_TYPE, A.CONTRACT_NUM, B.TP_SEQ_NBR, B.PRE_PLAN_AMT, B.TP_CON_BILL_DT, C.TP_ASSESS_TYPE HAVING SUM(A.ITEM_AMT) > SUM(A.APPLIED_AMT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 4 | TP_SEQ_NBR |
Number(7,0) | INTEGER NOT NULL | TP Sequence Number |
| 5 | PRE_PLAN_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Pre-Payment Plan Amount |
| 6 | TP_CON_BILL_DT | Date(10) | DATE | First Billing Date |
| 7 | TP_ASSESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field will be used by the institution to determine the type of charge for payment plans.
1=Payment Plan Fee 2=Percentage of Payment Plan 3=Monthly Interest Rate |
| 8 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 9 | APPLIED_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Applied Amount |