SFA_PKG_DSB_TMP(SQL Table) |
Index Back |
|---|---|
Staging table for PackagingTable used to stage Student Award Scheduled Disbursement data for packaging. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 5 | PKG_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL | Sequence Nbr |
| 6 | DISBURSEMENT_ID |
Character(2) | VARCHAR2(2) NOT NULL | Disbursement ID |
| 7 | OFFER_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Offer Balance |
| 8 | OFFER_BALANCE_ORIG | Number(12,2) | DECIMAL(11,2) NOT NULL | Original Offer Balance |
| 9 | ACCEPT_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Accept Balance |
| 10 | ACCEPT_BALNCE_ORIG | Number(12,2) | DECIMAL(11,2) NOT NULL | Original Accept Balance |
| 11 | AUTHORIZED_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Authorized Balance |
| 12 | DISBURSED_BALANCE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Disbursed Balance |
| 13 | NET_DISB_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | Net Disb Balance |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 15 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 16 | AGGREGATE_AREA | Character(10) | VARCHAR2(10) NOT NULL | Aggregate Area |
| 17 | AGGREGATE_LEVEL | Character(2) | VARCHAR2(2) NOT NULL | Aggregate Level |
| 18 | CPS_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 19 | LN_FEE_AMT | Number(7,2) | DECIMAL(6,2) NOT NULL | Loan Fee Amount |
| 20 | OFFER_BAL_LN_FEE | Number(7,2) | DECIMAL(6,2) NOT NULL | Offer Balance Loan Fee |
| 21 | ACCEPT_BAL_LN_FEE | Number(7,2) | DECIMAL(6,2) NOT NULL | Accept Balance Loan Fee |
| 22 | OFFER_BAL_REBATE | Number(7,2) | DECIMAL(6,2) NOT NULL | Offer Balance Rebate |
| 23 | ACCEPT_BAL_REBATE | Number(7,2) | DECIMAL(6,2) NOT NULL | Accept Balance Rebate |
| 24 | SFA_AGGR_BALANCE | Number(12,2) | DECIMAL(11,2) NOT NULL | FA-Aggregates: Aggregate Balance |
| 25 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |