INSTITUTIONBUSINESS_UNITEMPLIDSSF_SL_LOAN_NBRSSF_SL_FILE_NBRSEQNOSSF_SL_PBUL_VW(SQL View) |
Index Back |
|---|---|
Loan Payment per Business Unit |
| SELECT D.INSTITUTION , B.BUSINESS_UNIT , B.EMPLID , B.SSF_SL_LOAN_NBR , D.SSF_STUDY_START , B.SSF_SL_FILE_NBR , B.SEQNO , B.SSF_RECEIVED_AMT , B.SSF_REFUND_AMT , B.REFUND_NBR , B.PAYMENT_ID_NBR FROM PS_SSF_SL_PAY_BU B , PS_BUS_UNIT_TBL_SF C , PS_SSF_SL_LOAN D WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.INSTITUTION = D.INSTITUTION AND B.SSF_SL_LOAN_NBR = D.SSF_SL_LOAN_NBR AND B.EMPLID = D.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SSF_SL_LOAN_NBR |
Number(3,0) | SMALLINT NOT NULL | StudyLink loan number unique for each student. |
| 5 | SSF_STUDY_START | Date(10) | DATE | Start date of the earliest class for the study period. |
| 6 | SSF_SL_FILE_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. |
| 7 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | SSF_RECEIVED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Received Amount |
| 9 | SSF_REFUND_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Refund Amount |
| 10 | REFUND_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
| 11 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |