| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
FED_AID_YR_TBL
|
| 3 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
Prompt Table:
TIV_SCHL_CD2000
|
| 4 |
FA_PROGRAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Program
D=Direct Lending
F=Federal Family Ed Loan
H=Health Professions
L=Pell Grant
P=Perkins Loan
S=SEOG
W=Federal Workstudy
|
| 5 |
FA_RECON_SUM_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
FA Reconciliation Sequence
|
| 6 |
RECON_BATCH_ID |
Character(23) |
VARCHAR2(23) NOT NULL |
Recon Batch ID
|
| 7 |
FA_TRADING_PARTNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid Trading Partner
G=GAPS
I=Internal
L=Loan Destination
N=NSLDS
S=State
|
| 8 |
FA_RECON_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reconciliation Period
Prompt Table:
FA_RECONPER_TBL
|
| 9 |
FA_RECON_START_DT |
Date(10) |
DATE |
Reconciliation Start
Default Value: FA_RECONPER_TBL.RECON_START_DT
|
| 10 |
FA_RECON_END_DT |
Date(10) |
DATE |
Reconciliation End
Default Value: FA_RECONPER_TBL.RECON_END_DT
|
| 11 |
FA_RECON_END_RPTD |
Date(10) |
DATE |
FA Reported Reconciliation End
|
| 12 |
FA_TP_PROC_DT |
Date(10) |
DATE |
Trading Partner Process Date
|
| 13 |
FA_BEG_CASH_BAL |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Beginning Cash Balance
|
| 14 |
FA_BEG_CASH_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Beginning Cash Bal Reported
|
| 15 |
FA_BEG_CASH_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Beginning Cash Bal Compared
|
| 16 |
FA_CASH_RECPT |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Cash Receipts
|
| 17 |
FA_CASH_RECPT_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Cash Receipts Reported
|
| 18 |
FA_CASH_RECPT_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Cash Receipts Compared
|
| 19 |
FA_EXCSS_CASH |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Excess Cash Returned
|
| 20 |
FA_EXCSS_CASH_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Excess Cash Reported
|
| 21 |
FA_EXCSS_CASH_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Excess Cash Compared
|
| 22 |
FA_NET_CASH_RCPT |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Net Cash Receipts
|
| 23 |
FA_NET_CASH_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Net Cash Reported
|
| 24 |
FA_NET_CASH_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Net Cash Compared
|
| 25 |
FA_BKD_DISB |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Disbursements
|
| 26 |
FA_BKD_DISB_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Disb Reported
|
| 27 |
FA_BKD_DISB_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Disb Compared
|
| 28 |
FA_BKD_ADJ |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Adjustments
|
| 29 |
FA_BKD_ADJ_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Adj Reported
|
| 30 |
FA_BKD_ADJ_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Booked Adj Compared
|
| 31 |
FA_TOT_BKD_DISB |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Booked Disbursements
|
| 32 |
FA_TOT_BKD_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Tot Booked Disb Rptd
|
| 33 |
FA_TOT_BKD_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Tot Booked Disb Compared
|
| 34 |
FA_END_CASH_BAL |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Ending Cash Balance
|
| 35 |
FA_END_BAL_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Ending Cash Balance Reported
|
| 36 |
FA_END_BAL_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Ending Cash Balance Compared
|
| 37 |
FA_NET_UBKD_DISB |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Disbursements
|
| 38 |
FA_NET_UBKD_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Disb Reported
|
| 39 |
FA_NET_UBKD_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Disb Compared
|
| 40 |
FA_NET_UBKD_ADJ |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Adjustments
|
| 41 |
FA_UBKD_ADJ_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Adj Reported
|
| 42 |
FA_UBKD_ADJ_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Net Unbooked Adj Compared
|
| 43 |
FA_TOT_UNBKD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Unbooked Disbursements
|
| 44 |
FA_TOT_UBKD_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Unbooked Disb Reported
|
| 45 |
FA_TOT_UBKD_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Total Unbooked Disb Compared
|
| 46 |
FA_ADJ_END_BAL |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Adjusted End Cash Balance
|
| 47 |
FA_ADJ_BAL_RPTD |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Adjusted End Cash Bal Reported
|
| 48 |
FA_ADJ_BAL_CMP |
Signed Number(12,0) |
DECIMAL(11) NOT NULL |
Adjusted End Cash Bal Compared
|
| 49 |
TOT_NBR_CASH |
Number(6,0) |
INTEGER NOT NULL |
Total Number Cash Txns
|
| 50 |
TOT_NBR_DISB |
Number(6,0) |
INTEGER NOT NULL |
Total Number of Disbursements
|
| 51 |
FA_TOT_NBR_DTL |
Number(6,0) |
INTEGER NOT NULL |
Total Number of Detail Recs
|
| 52 |
TOT_TXN_AMT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Total of all Transactions
|
| 53 |
TOT_DTL_BATCHES |
Number(3,0) |
SMALLINT NOT NULL |
Total Number Detail Batches
|
| 54 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 55 |
FA_CASH_ACTN_DTTM |
DateTime(26) |
TIMESTAMP |
Cash Action Date/Time
|