DISB_RULE_ZCOPY

#	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: AID_YEAR_TBL
3	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: AID_YEAR_CAREER
4	ITEM_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Item Type Prompt Table: ITEM_TP_FA_AWRD
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Default Value: ITEM_TYPE_FA_SH.DESCR
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: DISB_RULE_ITM.DESCR
9	SAT_PROG_IND	Character(1)	VARCHAR2(1) NOT NULL	Must Meet Satisfactory Prog Y/N Table Edit Default Value: N
10	VERF_IND	Character(1)	VARCHAR2(1) NOT NULL	Verification Complete Y/N Table Edit Default Value: N
11	PKG_IND	Character(1)	VARCHAR2(1) NOT NULL	Package Complete Y/N Table Edit Default Value: N
12	REVIEW_IND	Character(1)	VARCHAR2(1) NOT NULL	Review Complete Y/N Table Edit Default Value: N
13	HONOR_DISB_IND	Character(1)	VARCHAR2(1) NOT NULL	Honor Disbursement Hold Y/N Table Edit Default Value: N
14	WITHDRAW_IND	Character(1)	VARCHAR2(1) NOT NULL	Hold If Withdrawn Y/N Table Edit Default Value: N
15	FEE_MATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	Match Fees Y/N Table Edit Default Value: N
16	FEE_MATCH_TOL_VAL	Number(5,0)	INTEGER NOT NULL	Tolerance Amt
17	EFC_IND	Character(1)	VARCHAR2(1) NOT NULL	Official Fed EFC Y/N Table Edit Default Value: N
18	LD_MATCH_AWD_IND	Character(1)	VARCHAR2(1) NOT NULL	Awd/Term Load Match Y/N Table Edit Default Value: N
19	LD_MATCH_BDG_IND	Character(1)	VARCHAR2(1) NOT NULL	Bdgt/Term Load Match Y/N Table Edit Default Value: N
20	LVL_MATCH_BDG_IND	Character(1)	VARCHAR2(1) NOT NULL	Bdgt/Term Level Match Y/N Table Edit Default Value: N
21	MIN_GPA_ON_FA_TERM	Number(9,3)	DECIMAL(8,3) NOT NULL	Min GPA on FA Term
22	MIN_GPA_PRIOR_TERM	Number(9,3)	DECIMAL(8,3) NOT NULL	Min GPA Prior FA Term
23	UNITS_MINIMUM	Number(6,2)	DECIMAL(5,2) NOT NULL	Minimum Units
24	HLD_DSB_FEDOVR_IND	Character(1)	VARCHAR2(1) NOT NULL	Hold Disb Fed Overaward Y/N Table Edit Default Value: N
25	HLD_DSB_INSOVR_IND	Character(1)	VARCHAR2(1) NOT NULL	Hold Disb Inst Overaward Y/N Table Edit Default Value: N
26	STATE_RESIDENCE	Character(6)	VARCHAR2(6) NOT NULL	State of Residence Prompt Table: STATE_NAMES_VW
27	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Specified 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico
28	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBL
29	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan Prompt Table: ACAD_SUBPLN_TBL
30	FORM_OF_STUDY	Character(4)	VARCHAR2(4) NOT NULL	Form of Study ABRD=Study Abroad CAND=Advanced to Candidacy DTCH=Detached Study ENRL=Class Enrollment
31	ATHL_PARTIC_CD	Character(5)	VARCHAR2(5) NOT NULL	Athletic Participation Code Prompt Table: ATHL_PART_TBL
32	STDNT_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Student Group Prompt Table: STDNT_GROUP_TBL
33	CAREER_MATCH_IND	Character(1)	VARCHAR2(1) NOT NULL	Awd Career Match Term Career Y/N Table Edit Default Value: N
34	ACAD_STANDING	Character(4)	VARCHAR2(4) NOT NULL	Academic Standing Prompt Table: ACAD_STACTN_TBL
35	SPORT	Character(3)	VARCHAR2(3) NOT NULL	Sport BA=Baseball BB=Basketball CC=Cross Country CR=Crew FB=Football GO=Golf GY=Gymnastics IT=Indoor Track NO=None OT=Outdoor Track SB=Softball SO=Soccer SW=Swimming TN=Tennis TR=Track UN=Unknown VB=Volleyball WP=Water Polo WR=Wrestling
36	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
37	NSLDS_LOAN_YR_IND	Character(1)	VARCHAR2(1) NOT NULL	NSLDS Loan Year Match Y/N Table Edit Default Value: N
38	FFELP_TOL_VAL	Number(5,0)	INTEGER NOT NULL	FFELP Tolerance Value
39	DISB_PRORATN_RULE	Character(10)	VARCHAR2(10) NOT NULL	Disbursement Proration Rule Prompt Table: DISB_PRORATION
40	AUTH_TO_FEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Authorize To Fee Assessment Y/N Table Edit Default Value: N
41	AUTH_IF_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Hold If No Enrollment Data Y/N Table Edit
42	POST_DISB_RED	Character(1)	VARCHAR2(1) NOT NULL	Post Disb Reduction Control
43	POST_DISB_RED_CDT	Character(1)	VARCHAR2(1) NOT NULL	Post Disb Red Ctrl - Census Dt
44	LOAN_INTERVIEW_SW	Character(1)	VARCHAR2(1) NOT NULL	Loan Entrance Intervw Req
45	PRORA_CENSUS_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	Stop After Census
46	FA_USE_CURRENT_LD	Character(3)	VARCHAR2(3) NOT NULL	Use Current Load ALL=All Students Only OEE=OEE Students Onlye
47	FA_USE_CURR_UNITS	Character(3)	VARCHAR2(3) NOT NULL	Use Current Units ALL=All Students Only OEE=OEE Student Only
48	SFA_RES_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Resident Country Prompt Table: COUNTRY_TBL
49	SFA_ASG_ACAD_IND	Character(1)	VARCHAR2(1) NOT NULL	ASG HERA Level Match Y/N Table Edit Default Value: N
50	SFA_ASG_CIP_IND	Character(1)	VARCHAR2(1) NOT NULL	ASG CIP Code Match Y/N Table Edit Default Value: N
51	SFA_ASG_GPA_IND	Character(1)	VARCHAR2(1) NOT NULL	ASG Minimum GPA Y/N Table Edit Default Value: N
52	SFA_ASG_IGRADE_IND	Character(1)	VARCHAR2(1) NOT NULL	ASG Incomplete Grades Y/N Table Edit Default Value: N
53	SFA_ASG_PELL_IND	Character(1)	VARCHAR2(1) NOT NULL	ASG Pell Grant Awarded Y/N Table Edit Default Value: N
54	SFA_ASG_MIN_GPA	Number(9,3)	DECIMAL(8,3) NOT NULL	ASG Minimum GPA
55	SFA_ASG_SMART_CIP	Character(1)	VARCHAR2(1) NOT NULL	SMART Enrollment Verification 1=Course Catalog 2=Subject Table