BUSINESS_UNITEMPLIDSSF_SL_LOAN_NBRSSF_SL_FILE_NBRSEQNOSSF_SL_PAY_BU(SQL Table) |
Index Back |
|---|---|
Payments by Business UnitThis table breaks down payments for each student to Business units. |
| # | 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 | SSF_SL_LOAN_NBR |
Number(3,0) | SMALLINT NOT NULL | StudyLink loan number unique for each student. |
| 4 | SSF_SL_FILE_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. |
| 5 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | SSF_RECEIVED_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Received Amount |
| 7 | SSF_REFUND_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Refund Amount |
| 8 | REFUND_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
| 9 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |