SFA_COD_AWARD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFA_CR_DOCUMENT_ID	Character(34)	VARCHAR2(34) NOT NULL	Document ID
2	SFA_CR_RPT_SCHL_ID	Character(8)	VARCHAR2(8) NOT NULL	Reporting School ID
3	SFA_CR_ATT_SCHL_ID	Character(8)	VARCHAR2(8) NOT NULL	Attended School ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	SFA_CR_AWARD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Award Name
6	SFA_CR_AWARD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Award Year
7	SFA_CR_AWARD_NBR	Number(2,0)	SMALLINT NOT NULL	Award Number
8	SFA_CR_LOAN_KEY	Number(2,0)	SMALLINT NOT NULL	Loan Key
9	SFA_CR_CPS_TRN_NBR	Character(2)	VARCHAR2(2) NOT NULL	CPS Transaction Number
10	SFA_CR_AWARD_AMT	Character(12)	VARCHAR2(12) NOT NULL	Award Amount
11	SFA_CR_NOTE_MSG	Character(20)	VARCHAR2(20) NOT NULL	Note Message
12	SFA_CR_DEPEND_STAT	Character(1)	VARCHAR2(1) NOT NULL	Dependency Status
13	SFA_CR_DFLT_OVRPAY	Character(3)	VARCHAR2(3) NOT NULL	Default/Overpay
14	SFA_CR_AWARD_ID	Character(21)	VARCHAR2(21) NOT NULL	Award ID
15	SFA_CR_AWD_CRE_DT	Character(10)	VARCHAR2(10) NOT NULL	Award Create Date
16	SFA_CR_HPPA_IND	Character(5)	VARCHAR2(5) NOT NULL	HPPA Indicator
17	SFA_CR_AWD_AMT_RQD	Character(12)	VARCHAR2(12) NOT NULL	Award Amount Requested
18	SFA_CR_COA	Character(12)	VARCHAR2(12) NOT NULL	Attendance Cost
19	SFA_CR_ACAD_CAL_CD	Character(1)	VARCHAR2(1) NOT NULL	Academic Calendar Code
20	SFA_CR_PMT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Payment Methodology
21	SFA_CR_WEEKS_USED	Character(2)	VARCHAR2(2) NOT NULL	Weeks Used to Calc
22	SFA_CR_WEEKS_PROG	Character(2)	VARCHAR2(2) NOT NULL	Weeks Program Acad Yr
23	SFA_CR_HOURS_AWARD	Character(4)	VARCHAR2(4) NOT NULL	Hours Award Year
24	SFA_CR_HOURS_PROG	Character(4)	VARCHAR2(4) NOT NULL	Hours Program Acad Year
25	SFA_CR_LOW_TUIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Low Tuition Fees
26	SFA_CR_INCARCERATE	Character(5)	VARCHAR2(5) NOT NULL	Incarcerated Indicator
27	SFA_CR_VERIF_STAT	Character(1)	VARCHAR2(1) NOT NULL	Verification Status Code
28	SFA_CR_ENROLL_DT	Character(10)	VARCHAR2(10) NOT NULL	Enrollment Date
29	SFA_CR_SEC_EFC_CD	Character(1)	VARCHAR2(1) NOT NULL	Secondary EFC Code
30	SFA_CR_LESSTHAN_FT	Character(5)	VARCHAR2(5) NOT NULL	Less Than FullTime
31	SFA_CR_FED_SHR_AMT	Character(12)	VARCHAR2(12) NOT NULL	Federal Share Amount
32	SFA_CR_GRADE_LEVEL	Character(18)	VARCHAR2(18) NOT NULL	Student Level Code
33	SFA_CR_FISAP_INC	Character(12)	VARCHAR2(12) NOT NULL	FISAP Income Amount
34	SFA_CR_RESPONSE_CD	Character(15)	VARCHAR2(15) NOT NULL	Response Code
35	SFA_CR_EMPN_IND	Character(5)	VARCHAR2(5) NOT NULL	eMPN Indicator
36	SFA_CR_MPN_ID	Character(21)	VARCHAR2(21) NOT NULL	MPN ID
37	SFA_CR_MPN_STAT	Character(1)	VARCHAR2(1) NOT NULL	MPN Status
38	SFA_CR_MPN_LINK	Character(5)	VARCHAR2(5) NOT NULL	MPN Link Indicator
39	SFA_CR_PMT_SRV_AMT	Character(11)	VARCHAR2(11) NOT NULL	Payment to Servicer Amt
40	SFA_CR_PMT_SRV_DT	Character(10)	VARCHAR2(10) NOT NULL	Payment to Servicer Date
41	SFA_CR_BKD_LN_AMT	Character(12)	VARCHAR2(12) NOT NULL	Booked Loan Amount
42	SFA_CR_BKD_LN_DT	Character(10)	VARCHAR2(10) NOT NULL	Booked Loan Date
43	SFA_CR_ENDORSE_AMT	Character(12)	VARCHAR2(12) NOT NULL	Endorser Amount
44	SFA_CR_CRD_DEC_ST	Character(1)	VARCHAR2(1) NOT NULL	Credit Decision Status
45	SFA_CR_CRD_DEC_DT	Character(10)	VARCHAR2(10) NOT NULL	Credit Decision Date
46	SFA_CR_CRD_OVR_CD	Character(1)	VARCHAR2(1) NOT NULL	Credit Override Code
47	SFA_CR_YTD_DSB_AMT	Character(12)	VARCHAR2(12) NOT NULL	Year-To-Date Disb Amt
48	SFA_CR_TOT_ELG_USD	Character(7)	VARCHAR2(7) NOT NULL	Total Eligibility Used
49	SFA_CR_SCHED_PELL	Character(12)	VARCHAR2(12) NOT NULL	Scheduled Pell Grant
50	SFA_CR_NEG_PND_AMT	Character(12)	VARCHAR2(12) NOT NULL	Negative Pending Amount
51	SFA_CR_FSA_CD	Character(2)	VARCHAR2(2) NOT NULL	FSA Code
52	SFA_CR_CPS_VERIF	Character(5)	VARCHAR2(5) NOT NULL	CPS Verification Indicator
53	SFA_CR_HIGHEST_CPS	Character(2)	VARCHAR2(2) NOT NULL	Highest CPS Transaction
54	SFA_CR_AWARD_AMT_N	Number(12,2)	DECIMAL(11,2) NOT NULL	Award Amount
55	SFA_CR_AWARD_STAT	Character(4)	VARCHAR2(4) NOT NULL	Award Status Code E=Error P=Processing Complete S=Skipped Record U=Unprocessed
56	SFA_CR_ELIG_RSN_CD	Character(2)	VARCHAR2(2) NOT NULL	Eligibility Payment Reason Cd
57	SFA_CR_HS_PROG_CD	Character(6)	VARCHAR2(6) NOT NULL	Rigorous High School Program
58	SFA_CR_PROG_CIP_CD	Character(20)	VARCHAR2(20) NOT NULL	Program CIP Code
59	SFA_CR_MPN_EXPIRE	Character(10)	VARCHAR2(10) NOT NULL	MPN Expire Date
60	SFA_CR_PPCRWRK_IND	Character(5)	VARCHAR2(5) NOT NULL	PreProfessional Coursewrk
61	SFA_CR_ADDUSUB_IND	Character(5)	VARCHAR2(5) NOT NULL	Additional Unsubsidized
62	SFA_CR_ADDL_ELIG	Character(5)	VARCHAR2(5) NOT NULL	Additional Eligibility
63	SFA_CR_APP_ID	Character(10)	VARCHAR2(10) NOT NULL	Application Id
64	SFA_CR_APP_COMP_DT	Character(10)	VARCHAR2(10) NOT NULL	Application Complete Date
65	SFA_CR_APP_LN_AMT	Character(12)	VARCHAR2(12) NOT NULL	Application Loan Amount
66	SFA_CR_CRD_BAL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Credit Balance Option
67	SFA_CR_CRD_ACTN_CH	Character(1)	VARCHAR2(1) NOT NULL	Credit Action Choice
68	SFA_CR_CRD_APL_STS	Character(1)	VARCHAR2(1) NOT NULL	Credit Appeal Status
69	SFA_CR_MAX_LN_IND	Character(5)	VARCHAR2(5) NOT NULL	Maximum Loan Indicator
70	SFA_CR_CRD_EXP_DT	Character(10)	VARCHAR2(10) NOT NULL	Credit Decision Expiration Dt
71	SFA_CR_CRD_DEC_ORG	Character(1)	VARCHAR2(1) NOT NULL	Original Credit Decision Stat
72	SFA_CR_DEFER_OPT	Character(5)	VARCHAR2(5) NOT NULL	Deferment Option
73	SFA_CR_LIFETM_USED	Character(8)	VARCHAR2(8) NOT NULL	Lifetime Eligibility Used
74	SFA_CR_LN_SERVICER	Character(50)	VARCHAR2(50) NOT NULL	Loan Servicer
75	SFA_CR_ENTCNSL_IND	Character(5)	VARCHAR2(5) NOT NULL	Entrance Counseling
76	SFA_CR_LN_START_DT	Character(10)	VARCHAR2(10) NOT NULL	Loan Period Start Date
77	SFA_CR_LN_END_DT	Character(10)	VARCHAR2(10) NOT NULL	Loan Period End Date
78	SFA_CR_6M_DFER_OPT	Character(5)	VARCHAR2(5) NOT NULL	Six Month Deferment Option
79	SFA_CR_SCRD_BALOPT	Character(5)	VARCHAR2(5) NOT NULL	School Credit Balance Option
80	SFA_CR_ENTCNSL_RSP	Character(5)	VARCHAR2(5) NOT NULL	Entrance Counseling Response
81	SFA_CR_CNSL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Counseling Processing Status 1=Student Not Found 2=Multiple Student Matches 3=SearchMatch option set to Skip 4=No Setup 5=No Grad PLUS record found 6=No Stafford record found 7=No Aid Year 8=Cannot Insert/Update data
82	SFA_CR_CNSL_CMP_DT	Character(10)	VARCHAR2(10) NOT NULL	Counseling Complete Date
83	SFA_CR_CNSL_SEQNBR	Number(3,0)	SMALLINT NOT NULL	Counseling Sequence Number
84	SFA_CR_APPSUB_RSN	Character(30)	VARCHAR2(30) NOT NULL	Application Submission Reason
85	SFA_CR_UKNW_LN_AMT	Character(5)	VARCHAR2(5) NOT NULL	Unknown Loan Amount
86	SFA_CR_BEN_CD	Character(2)	VARCHAR2(2) NOT NULL	Ability To Benefit Code
87	SFA_CR_BEN_ADM_CD	Character(2)	VARCHAR2(2) NOT NULL	Ability To Administrator Code
88	SFA_CR_BEN_COMP_DT	Character(10)	VARCHAR2(10) NOT NULL	Benefit Completion Date
89	SFA_CR_BENSTATE_CD	Character(3)	VARCHAR2(3) NOT NULL	Ability to Benefit State Code
90	SFA_CR_BEN_TEST_CD	Character(2)	VARCHAR2(2) NOT NULL	Ability To Benefit Test Code
91	SFA_CR_PROG_STUDY	Character(3)	VARCHAR2(3) NOT NULL	Program Of Study
92	SFA_CR_PREV_APPLID	Character(10)	VARCHAR2(10) NOT NULL	Previous Application ID
93	SFA_CR_GRADELG_OVR	Character(5)	VARCHAR2(5) NOT NULL	Graduate Eligibility Override
94	SFA_CR_ACAD_YR_LEN	Character(4)	VARCHAR2(4) NOT NULL	Academic Year Length
95	SFA_CR_ACT_CUSGPER	Character(5)	VARCHAR2(5) NOT NULL	Sub Usage Period
96	SFA_CR_ACT_USGPER	Character(5)	VARCHAR2(5) NOT NULL	Actual Sub Usage Period
97	SFA_CR_ANT_CUSGPER	Character(5)	VARCHAR2(5) NOT NULL	ANTIC NonCredTCertSub USG PD
98	SFA_CR_ANT_USGPER	Character(5)	VARCHAR2(5) NOT NULL	Anticipated Sub Usage Period
99	SFA_CR_AWD_LINKEFC	Character(13)	VARCHAR2(13) NOT NULL	Awd Linked Exp Family Contrib
100	SFA_CR_CALPRGLENYR	Character(7)	VARCHAR2(7) NOT NULL	Calc Published Pgm Length Year
101	SFA_CR_ISSUEDSBAMT	Character(12)	VARCHAR2(12) NOT NULL	Issued Disbursement Amount
102	SFA_CR_LNKCPSPROCD	Character(10)	VARCHAR2(10) NOT NULL	Linked CPS Process Date
103	SFA_CR_LNKDODMATCH	Character(1)	VARCHAR2(1) NOT NULL	Linked DoD Match Flag
104	SFA_CR_LNKPELLELIG	Character(5)	VARCHAR2(5) NOT NULL	Linked Pell Eligibility
105	SFA_CR_LN_PER_LEN	Character(8)	VARCHAR2(8) NOT NULL	Loan Period Length
106	SFA_CR_MAXELIGPER	Character(5)	VARCHAR2(5) NOT NULL	Maximum Eligibility Period
107	SFA_CR_NWCPSPROCDT	Character(10)	VARCHAR2(10) NOT NULL	New CPS Process Date
108	SFA_CR_NWCPSTRNNUM	Character(2)	VARCHAR2(2) NOT NULL	New CPS Transaction Number
109	SFA_CR_NWDODMATCH	Character(1)	VARCHAR2(1) NOT NULL	New DoD Match Flag
110	SFA_CR_NW_EFC	Character(13)	VARCHAR2(13) NOT NULL	New Expected Family Contrib
111	SFA_CR_NW_PELLELIG	Character(5)	VARCHAR2(5) NOT NULL	New Pell Eligibility
112	SFA_CR_NW_SCHGRANT	Character(12)	VARCHAR2(12) NOT NULL	New Scheduled Grant
113	SFA_CR_PROFJUDGMNT	Character(1)	VARCHAR2(1) NOT NULL	Professional Judgment Flag
114	SFA_CR_ACT_REMCPER	Character(6)	VARCHAR2(6) NOT NULL	Remaining Sub Elig Period
115	SFA_CR_ACT_REMPER	Character(6)	VARCHAR2(6) NOT NULL	Remaining Actual Sub ELIG PD
116	SFA_CR_ANT_REMCPER	Character(6)	VARCHAR2(6) NOT NULL	REM ANTIC NonCred TUSG PD
117	SFA_CR_ANT_REMELGP	Character(6)	VARCHAR2(6) NOT NULL	Remaining ANTIC Sub ELIG PD
118	SFA_CR_ANT_SUMCUSG	Character(5)	VARCHAR2(5) NOT NULL	Sum Sub Usage Period
119	SFA_CR_ANT_SUMUSG	Character(5)	VARCHAR2(5) NOT NULL	Sum Ant Sub Usage Periods
120	SFA_CR_CRD_ACTN_ST	Character(1)	VARCHAR2(1) NOT NULL	Credit Action Status
121	SFA_CR_RECON_ELIG	Character(5)	VARCHAR2(5) NOT NULL	Reconsideration Eligible
122	SFA_CR_PL_CNSL_CMP	Character(5)	VARCHAR2(5) NOT NULL	PLUS Counseling Completed
123	SFA_CR_PL_CNSLCMDT	Character(10)	VARCHAR2(10) NOT NULL	PLUS Counseling Complete Date
124	SFA_CR_PLCNSLEXCPT	Character(5)	VARCHAR2(5) NOT NULL	PLUS Counseling Exception
125	SFA_CR_CRD_REQ_MET	Character(5)	VARCHAR2(5) NOT NULL	Credit Requirements Met
126	SFA_CR_ENDORS_APRV	Character(5)	VARCHAR2(5) NOT NULL	Endorser Approved
127	SFA_CR_PLCNSL_EXDT	Character(10)	VARCHAR2(10) NOT NULL	PLUS CNSL Expiration Date
128	SFA_CR_STUELIG_CD	Character(2)	VARCHAR2(2) NOT NULL	Student Eligibility Code
129	SFA_CR_IBT_ID	Character(18)	VARCHAR2(18) NOT NULL	Informed Borrowing ID
130	SFA_CR_IBT_FLAG	Character(5)	VARCHAR2(5) NOT NULL	Informed Borrowing Complete
131	SFA_CR_IBT_DATE	Character(10)	VARCHAR2(10) NOT NULL	Informed Borrowing Cmplt Dt
132	SFA_CR_PLUS_RELSTU	Character(1)	VARCHAR2(1) NOT NULL	RelationshipToStudent
133	SFA_CR_FED_YR_COA	Character(12)	VARCHAR2(12) NOT NULL	Direct Loan Attendance Cost
134	SFA_CR_IASG_ELIG	Character(1)	VARCHAR2(1) NOT NULL	IASGEligible
135	SFA_CR_CFH_ELIG	Character(1)	VARCHAR2(1) NOT NULL	CFHEligible