Project: PRJ701889

	Platform	Default	
	Database	SA801DVA	
	Version	82	
	Description	UPD701889	

Records
AID_YEAR_SRCH	
AV_AVPGCLUB_TMP	
AV_EXT_ORG_2_VW	
AV_GCLUB_MBR	
AV_GC_ML_SUM_VW	
AV_RUNCTL_GCLUB	
DERIVED_GRANTS	
DISB_RULE_ITM	
DISB_RULE_ZCOPY	
INSTITUTION_VW3	
SFA_ASG_AL_COPY	
SFA_ASG_AL_TBL	
SFA_ASG_ELG_DER	
SFA_ASG_FATALVW	
SFA_ASG_WI_CAR	
SFA_ASG_WI_TBL	
STDNT_FA_TERM	
UPG_SFAAL_TAO	
UPG_SFATM_TAO	
UPG_SFA_AL_AET	
UPG_SFA_TM2_AET	
UPG_SFA_TM3_AET	

Fields
AV_INC_MAN_MGD_MEM	
GCLUB_ADDED_BY	
SFA_ASG_AC_LVL_BOT	
SFA_ASG_CALDR_TYPE	
SFA_ASG_FAT_AL_PB	
SFA_ASG_HRS_CRDTS	
SFA_ASG_SMART_CIP	
SFA_ASG_UNITS_BOT	
SFA_ASG_UNITS_EOT	
SFA_ASG_WI_CUM_BOT	
SFA_ASG_WI_CUM_EOT	
SFA_ASG_WI_MTH	
SFA_ASG_WI_MTH_CL	
SFA_ASG_WI_MTH_OVR	
SFA_ASG_WI_STRM	
SFA_ASG_WI_TCR	
SFA_ASG_WI_TCR_CL	
SFA_ASG_WI_TCR_OVR	
SFA_ASG_WI_TRM	
SFA_ASG_WI_TRM_CL	
SFA_ASG_WI_TRM_OVR	
SFA_ASG_WI_USED	
SFA_ASG_WKS_ACADYR	

Translate Values
GCLUB_ADDED_BY (C)	ENG	1900-01-01
GCLUB_ADDED_BY (X)	ENG	1900-01-01
GCLUB_MBR_STATUS (D)	ENG	1900-01-01
GCLUB_MBR_STATUS (R)	ENG	1900-01-01
GCLUB_MBR_STATUS (X)	ENG	1900-01-01
SFA_ASG_CALDR_TYPE (1)	ENG	1900-01-01
SFA_ASG_CALDR_TYPE (2)	ENG	1900-01-01
SFA_ASG_CALDR_TYPE (3)	ENG	1900-01-01
SFA_ASG_CALDR_TYPE (4)	ENG	1900-01-01
SFA_ASG_SMART_CIP (1)	ENG	1900-01-01
SFA_ASG_SMART_CIP (2)	ENG	1900-01-01
SFA_ASG_WI_MTH (C)	ENG	1900-01-01
SFA_ASG_WI_MTH (E)	ENG	1900-01-01
SFA_ASG_WI_MTH (L)	ENG	1900-01-01
SFA_ASG_WI_MTH (T)	ENG	1900-01-01
SFA_ASG_WI_MTH_CL (C)	ENG	1900-01-01
SFA_ASG_WI_MTH_CL (E)	ENG	1900-01-01
SFA_ASG_WI_MTH_CL (L)	ENG	1900-01-01
SFA_ASG_WI_MTH_CL (T)	ENG	1900-01-01

Pages
AV_GCLUB_MBR_SBP (ENG)
AV_RELATE_E_SP (ENG)
AV_RELATIONSHIPS_E (ENG)
AV_RELATION_EP (ENG)
AV_RELATION_EP_SP (ENG)
AV_RELATION_PE (ENG)
AV_RELATION_PE_SP (ENG)
AV_RUNCTL_GCLUBS (ENG)
DISB_RULE_ITM1 (ENG)
SFA_ASG_AL_COPY (ENG)
SFA_ASG_AL_SUBP (ENG)
SFA_ASG_AL_TBL (ENG)
SFA_ASG_ELIG (ENG)
SFA_ASG_ELIGAL_SEC (ENG)
SFA_ASG_WI_TBL (ENG)
SFA_RUNCTL_FISAP10 (ENG)
STDNT_FA_ASGAL_SEC (ENG)

Menus
DESIGN_FINANCIAL_AID1
PACKAGE_AID

Components
AV_CNST_RELATION_W (GBL)
AV_ORG_RELATION_W (GBL)
SFA_ASG_AL_TBL (GBL)
SFA_ASG_WI_TBL (GBL)
SFA_RUNCTL_FISAP10 (GBL)

PeopleCode (Record)
AID_YEAR_SRCH.INSTITUTION.SearchInit
AV_GCLUB_MBR.GCLUB_CD.FieldChange
AV_GCLUB_MBR.GCLUB_MBR_STATUS.FieldChange
AV_RELATE_E.EXT_ORG_ID_RELATED.FieldChange
AV_RELATE_EP_VW.ORG_RELATE_NBR.RowInit
AV_RELATE_PE.EMPLID.FieldChange
AV_RELATE_PE.PE_RELATE_NBR.SavePostChange
AV_RUNCTL_GCLUB.AV_GCLUB_PRCS.FieldChange
AV_RUNCTL_GCLUB.AV_GCLUB_PRCS.RowInit
CLASS_SRCH_WRK2.CLASS_SRCH_PB.FieldChange
DERIVED_AV.AV_RELATION_NAME.FieldDefault
DERIVED_AV_GP.GCLUB_MBR_FETCH.RowInit
DERIVED_AV_PO.ADDRESS_BTN.FieldChange
DERIVED_AV_PO.AV_RLTN_RTRV.RowInit
DERIVED_GRANTS.SFA_ASG_FAT_AL_PB.FieldChange
FUNCLIB_SR.GRADE_ROSTER_STAT.FieldFormula
SFA_ASG_FATALVW.SFA_ASG_WI_USED.RowInit
STDNT_FA_TERM.SFA_ASG_WI_MTH.FieldChange
STDNT_FA_TERM.SFA_ASG_WI_MTH.RowInit
STDNT_FA_TERM.SFA_ASG_WI_MTH_CL.SaveEdit
STDNT_FA_TERM.SFA_ASG_WI_TCR.FieldChange
STDNT_FA_TERM.SFA_ASG_WI_TRM.FieldChange
STDNT_FA_TERM.SFA_ASG_WI_USED.RowInit

Process Definitions
Application Engine 	UPD701889_A1
Application Engine 	UPD701889_A2
Application Engine 	UPD701889_A3
SQR Report 	FAPFSP10

Message Catalog Entries
Stdnt Admin - Financial Aid 	14400, 453 (ENG)
Stdnt Admin - Financial Aid 	14400, 454 (ENG)
Stdnt Admin - Financial Aid 	14400, 455 (ENG)
Stdnt Admin - Financial Aid 	14400, 456 (ENG)
Stdnt Admin - Financial Aid 	14400, 457 (ENG)
Stdnt Admin - Financial Aid 	14400, 458 (ENG)
ISIR/Profile Panel MSGS 	14404, 434 (ENG)
Stdnt Admin - ACG/SMART 	14426, 5160 (ENG)
Stdnt Admin - ACG/SMART 	14426, 5161 (ENG)
Stdnt Admin - ACG/SMART 	14426, 5162 (ENG)
Stdnt Admin - ACG/SMART 	14426, 555 (ENG)
Stdnt Admin - Authorization 	14441, 91 (ENG)

SQL
AID_YEAR_SRCH 	View
AV_EXT_ORG_2_VW 	View
AV_GCLUB    DELMBR  Step10  S 	ApplEng
AV_GCLUB    DELMBR  Step20  S 	ApplEng
AV_GC_ML_SUM_VW 	View
DISB_RULE_ZCOPY 	View
INSTITUTION_VW3 	View
SFA_ASG_AL_COPY 	View
SFA_ASG_FATALVW 	View
UPD701889_A1DRIVER  Step010 S 	ApplEng
UPD701889_A1DRIVER  Step020 S 	ApplEng
UPD701889_A1HERALVL Step010 S 	ApplEng
UPD701889_A1HERALVL Step030 S 	ApplEng
UPD701889_A2WICALC  Step010 S 	ApplEng
UPD701889_A2WICALC  Step020 S 	ApplEng
UPD701889_A2WICALC  Step030 S 	ApplEng
UPD701889_A2WICALC  Step035 S 	ApplEng
UPD701889_A2WICALC  Step040 S 	ApplEng
UPD701889_A2WICALC  Step050 S 	ApplEng
UPD701889_A2WICALC  Step055 S 	ApplEng
UPD701889_A2WICALC  Step060 S 	ApplEng
UPD701889_A2WICALC  Step070 S 	ApplEng
UPD701889_A3STCARTRMStep010 S 	ApplEng
UPD701889_A3STCARTRMStep030 S 	ApplEng
UPD701889_A3STCARTRMStep050 S 	ApplEng

Appl Engine (Prog)
UPD701889_A1
UPD701889_A2
UPD701889_A3

Appl Engine (Section)
AV_GCLUB 	DELMBR
UPD701889_A1 	DRIVER
UPD701889_A1 	HERALVL
UPD701889_A1 	MAIN
UPD701889_A2 	MAIN
UPD701889_A2 	WICALC
UPD701889_A3 	MAIN
UPD701889_A3 	STCARTRM

PeopleCode (ApplEng)
UPD701889_A1.DRIVER  GBLdefault  1900-01-01.Step040.OnExecute

PeopleCode (Page)
AV_EP_REL_ADDR_SP.Activate
AV_PE_REL_ADDR_SEC.Activate
AV_PE_REL_ADDR_SP.Activate
AV_RELATE_E_SP.Activate
AV_RELATION_EP_SP.Activate
AV_RELATION_PE_SP.Activate
SFA_ASG_ELIGAL_SEC.Activate

PeopleCode (CompRecord)
SFA_ASG_WI_TBL(GBL).SFA_ASG_WI_CAR.RowInit
SFA_ASG_WI_TBL(GBL).SFA_ASG_WI_CAR.SaveEdit

PeopleCode (CompRecFld)
SFA_ASG_AL_TBL(GBL).DERIVED_FA_COPY.COPY_DATA_PUSHBTN FieldChange
SFA_ASG_WI_TBL(GBL).SFA_ASG_WI_CAR.ACAD_CAREER       FieldChange
SFA_ASG_WI_TBL(GBL).SFA_ASG_WI_CAR.ACAD_PLAN         FieldChange
SFA_ASG_WI_TBL(GBL).SFA_ASG_WI_CAR.ACAD_PROG         FieldChange

Record Detail

Record: AID_YEAR_SRCH	
	Description	Aid Year Table Search	
	Record Type	SQL View	
	Parent Record	 	
	Related Language	AID_YR_TBL_LANG	
	DDL Space Name	FAAPP	
	Build Seq	1	
	Owner ID	SFAG	
	Comments	
		This search record pulls up all Aid Years for an Institution from AI
		D_YEAR_TBL, which contains a list of the different Aid Years and the
		ir descriptions for each institution.  It is primarily used in the F
		inancial Aid Module.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
AID_YEAR           Char 4      KDLS          Prmt AID_YEAR_TBL      OPR_DEF_TBL_CS.AID_YEAR
DESCR              Char 30       L
DESCRSHORT         Char 10
ACAD_YEAR_START    Date 10
ACAD_YEAR_END      Date 10

Record: AV_AVPGCLUB_TMP	
	Description	Giving Club Member	
	Record Type	SQL Table	
	Parent Record	 	
	Related Language	 	
	DDL Space Name	SAAPP	
	Owner ID	SAV	
	Comments	
		Giving Club Member -Temp

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
INSTITUTION        Char 5      KA
GCLUB_CD           Char 9      KA
EMPLID             Char 11     KA
EXT_ORG_ID         Char 11     KA
FISCAL_YEAR        Num  4      KA
GCLUB_LVL          Char 9      KA
GCLUB_AMT          Num  13.2   KA
GCLUB_MBR_STATUS   Char 1
LAST_UPDATE_DTTM   DT   26

Record: AV_EXT_ORG_2_VW	
	Description	Ext Org Table View 2
	Record Type	SQL View
	Parent Record	 
	Related Language	 
	DDL Space Name	SFAPP
	Build Seq	1
	Owner ID	SAV
	Comments	Used just to bring back the Description for a relate display.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
EXT_ORG_ID         Char 11     KA
EFFDT              Date 10     KD                                   %date
EFF_STATUS         Char 1                Req Xlat                   'A'
NAME               Char 50
ORG_LOCATION       Num  3                    Prmt ORG_LOCATION
ADDRESS1           Char 55
ADDRESS2           Char 55
ADDRESS3           Char 55
ADDRESS4           Char 55
CITY               Char 30     AAL
STATE              Char 6      AAL           Prmt STATE_NAMES_TBL
COUNTY             Char 30
POSTAL             Char 12     AAL
COUNTRY            Char 3      AAL           Prmt COUNTRY_TBL

Record: AV_GCLUB_MBR	
	Description	Giving Club Member
	Record Type	SQL Table
	Parent Record	 
	Related Language	 
	DDL Space Name	SAAPP
	Owner ID	SAV
	Comments	Giving Club Member

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS
GCLUB_CD           Char 9      KALS          Prmt AV_GCLUB_OWN_VW
EMPLID             Char 11     KALS
EXT_ORG_ID         Char 11     KALS
FISCAL_YEAR        Num  4      KALS               CAL_FISYR_VW
GCLUB_LVL          Char 9                    Prmt AV_GCLUB_LVL
GCLUB_AMT          Num  13.2
CURRENCY_CD        Char 3                    Prmt CURRENCY_CD_TBL   AV_INSTALL_INST.BASE_CURRENCY
GCLUB_MBR_STATUS   Char 1                    Xlat                   'M'
GCLUB_ADDED_BY     Char 1                    Xlat                   'U'
GCLUB_ADDED_BY     Char 1                    Xlat                   'X'
GCLUB_MBR_DT       Date 10                                          %Date
LAST_UPDATE_DTTM   DT   26
DESCRLONG          Long

Record: AV_GC_ML_SUM_VW	
	Description	Giving Club Level Member Count
	Record Type	SQL View
	Parent Record	 
	Related Language	 
	DDL Space Name	SFAPP
	Build Seq	1
	Owner ID	SAV
	Comments	Returns the number of valid members in a giving clublevel  for a par
		ticular fiscal year.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KA
GCLUB_CD           Char 9      KA
GCLUB_LVL          Char 9      KA
FISCAL_YEAR        Num  4      KA
CURRENCY_CD        Char 3
GCLUB_MBR_AMT      Num  13.2

Record: AV_RUNCTL_GCLUB	
	Description	Giving Clubs Run Control
	Record Type	SQL Table
	Parent Record	 
	Related Language	 
	DDL Space Name	SAAPP
	Owner ID	SAV
	Comments	Record is used to setup parameters for Giving Club processing.
		
		04/16/01 (JPM) - I removed the av_install_inst.base_currency default
		that was on the currency_cd field.  This field needs to be populate
		d based on the Institution that is selected on the runctl page.  Cod
		e was added under Institution fieldchange and rowinit to populate th
		e currency_cd field.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
OPRID              Char 30     KA        Req
RUN_CNTL_ID        Char 30     KALS      Req
INSTITUTION        Char 5      KALS      Req Prmt AV_INST_SCRTY     AV_OPR_DEF_TBL.INSTITUTION
PROCESS_DATE       Date 10                                          %Date
FISCAL_YEAR        Num  4
CURRENCY_CD        Char 3                    Prmt CURRENCY_CD_TBL
COMMIT_LEVEL       Num  5                                           '100'
AV_GCLUB_PRCS      Char 1                    Xlat                   'U'
AV_INC_MAN_MGD_MEM Char 1                    Y/N                    'N'

Record: DERIVED_GRANTS	
	Description	Derived Work for ACG/SMART
	Record Type	Derived/Work
	Parent Record	 
	Related Language	 
	DDL Space Name	SAAPP
	Owner ID	SFA

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
SFA_COD_AWARD_AMT  Num  9.2
SFA_CR_DOC_ID_PB   Char 1
SFA_CR_DTL_PB      Char 1
SFA_CR_LABEL       Char 1
SFA_CR_MSG_PB      Char 1
RESET_PB           Char 1
SFA_CR_INST        Char 1
SFA_CR_YTD_ORIG_ID Char 1
SFA_CR_STDNT       Char 1
EMPLID             Char 11
SFA_ASG_MR_GROUP   Char 1
SFA_ASG_ED_USE_PB  Char 1
SFA_ASG_YTDSTDD_PB Char 1
SFA_ASG_YTDSTDO_PB Char 1
SFA_ASG_YTD_DTL_PB Char 1
SFA_ASG_YTDSUM_PB  Char 1
SFA_ASG_REC_PB     Char 1
SFA_CR_CMNT_PB     Char 1
SFA_ASG_MRRSTD_PB  Char 1
SFA_ASG_PRG_SEL_PB Char 1
SFA_ASG_PLN_SEL_PB Char 1
SFA_ASG_SPL_SEL_PB Char 1
ACAD_PROG          Char 5                    Prmt %EDITTABLE
ACAD_PLAN          Char 10                   Prmt %EDITTABLE2
ACAD_SUB_PLAN      Char 10                   Prmt %EDITTABLE3
RETURN_PB          Char 1
SFA_EQ_GROUP_TYPE  Char 4                    Xlat
SFA_ASG_CIP_SEL_SR Char 1                    Y/N                    'N'
SFA_ASG_FAT_AL_PB  Char 1

Record: DISB_RULE_ITM	
	Description	Disburse Rule Item Type
	Record Type	SQL Table
	Parent Record	AID_YEAR_TBL
	Related Language	 
	DDL Space Name	FAAPP
	Owner ID	SFAD
	Comments	This table contains all the 'Item Type' disbursement rules.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
AID_YEAR           Char 4      KDLS      Req Prmt AID_YEAR_TBL      OPR_DEF_TBL_CS.AID_YEAR
ACAD_CAREER        Char 4      KALS      Req Prmt AID_YEAR_CAREER
ITEM_TYPE          Char 12     KDLS      Req Prmt ITEM_TP_FA_AWRD
EFFDT              Date 10     KD                                   %date
EFF_STATUS         Char 1                    Xlat                   'A'
DESCR              Char 30                                          ITEM_TYPE_FA_SH.DESCR
DESCRSHORT         Char 10                                          DISB_RULE_ITM.DESCR
SAT_PROG_IND       Char 1                    Y/N                    'N'
VERF_IND           Char 1                    Y/N                    'N'
PKG_IND            Char 1                    Y/N                    'N'
REVIEW_IND         Char 1                    Y/N                    'N'
HONOR_DISB_IND     Char 1                    Y/N                    'N'
WITHDRAW_IND       Char 1                    Y/N                    'N'
FEE_MATCH_IND      Char 1                    Y/N                    'N'
FEE_MATCH_TOL_VAL  Num  5
EFC_IND            Char 1                    Y/N                    'N'
LD_MATCH_AWD_IND   Char 1                    Y/N                    'N'
LD_MATCH_BDG_IND   Char 1                    Y/N                    'N'
LVL_MATCH_BDG_IND  Char 1                    Y/N                    'N'
MIN_GPA_ON_FA_TERM Num  5.3
MIN_GPA_PRIOR_TERM Num  5.3
UNITS_MINIMUM      Num  3.2
HLD_DSB_FEDOVR_IND Char 1                    Y/N                    'N'
HLD_DSB_INSOVR_IND Char 1                    Y/N                    'N'
STATE_RESIDENCE    Char 6                    Prmt STATE_NAMES_VW
ETHNIC_GROUP       Char 1                    Xlat
ACAD_PLAN          Char 10                   Prmt ACAD_PLAN_TBL
ACAD_SUB_PLAN      Char 10                   Prmt ACAD_SUBPLN_TBL
FORM_OF_STUDY      Char 4                    Xlat
ATHL_PARTIC_CD     Char 5                    Prmt ATHL_PART_TBL
STDNT_GROUP        Char 4                    Prmt STDNT_GROUP_TBL
CAREER_MATCH_IND   Char 1                    Y/N                    'N'
ACAD_STANDING      Char 4                    Prmt ACAD_STACTN_TBL
SPORT              Char 3                    Xlat
COUNTRY            Char 3                    Prmt COUNTRY_TBL
NSLDS_LOAN_YR_IND  Char 1                    Y/N                    'N'
FFELP_TOL_VAL      Num  5
DISB_PRORATN_RULE  Char 10                   Prmt DISB_PRORATION
AUTH_TO_FEE_IND    Char 1                    Y/N                    'N'
AUTH_IF_ENROLL     Char 1                    Y/N                    'N'
POST_DISB_RED      Char 1                    Y/N                    'N'
POST_DISB_RED_CDT  Char 1                    Y/N                    'N'
LOAN_INTERVIEW_SW  Char 1                    Y/N                    'N'
PRORA_CENSUS_DT_SW Char 1                    Y/N                    'N'
FA_USE_CURRENT_LD  Char 3                    Xlat
FA_USE_CURR_UNITS  Char 3                    Xlat
SFA_ASG_ACAD_IND   Char 1                    Y/N                    'N'
SFA_ASG_CIP_IND    Char 1                    Y/N                    'N'
SFA_ASG_GPA_IND    Char 1                    Y/N                    'N'
SFA_ASG_IGRADE_IND Char 1                    Y/N                    'N'
SFA_ASG_PELL_IND   Char 1                    Y/N                    'N'
SFA_ASG_MIN_GPA    Num  5.3
SFA_ASG_SMART_CIP  Char 1                    Xlat

Record: DISB_RULE_ZCOPY	
	Description	Disburse Rule Item Type
	Record Type	SQL View
	Parent Record	AID_YEAR_TBL
	Related Language	 
	DDL Space Name	SFAPP
	Build Seq	1
	Owner ID	SFAD
	Comments	This table contains all the 'Item Type' disbursement rules.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
AID_YEAR           Char 4      KDLS      Req Prmt AID_YEAR_TBL      OPR_DEF_TBL_CS.AID_YEAR
ACAD_CAREER        Char 4      KALS      Req Prmt AID_YEAR_CAREER
ITEM_TYPE          Char 12     KDLS      Req Prmt ITEM_TP_FA_AWRD
EFFDT              Date 10     KD                                   %date
EFF_STATUS         Char 1                    Xlat                   'A'
DESCR              Char 30                                          ITEM_TYPE_FA_SH.DESCR
DESCRSHORT         Char 10                                          DISB_RULE_ITM.DESCR
SAT_PROG_IND       Char 1                    Y/N                    'N'
VERF_IND           Char 1                    Y/N                    'N'
PKG_IND            Char 1                    Y/N                    'N'
REVIEW_IND         Char 1                    Y/N                    'N'
HONOR_DISB_IND     Char 1                    Y/N                    'N'
WITHDRAW_IND       Char 1                    Y/N                    'N'
FEE_MATCH_IND      Char 1                    Y/N                    'N'
FEE_MATCH_TOL_VAL  Num  5
EFC_IND            Char 1                    Y/N                    'N'
LD_MATCH_AWD_IND   Char 1                    Y/N                    'N'
LD_MATCH_BDG_IND   Char 1                    Y/N                    'N'
LVL_MATCH_BDG_IND  Char 1                    Y/N                    'N'
MIN_GPA_ON_FA_TERM Num  5.3
MIN_GPA_PRIOR_TERM Num  5.3
UNITS_MINIMUM      Num  3.2
HLD_DSB_FEDOVR_IND Char 1                    Y/N                    'N'
HLD_DSB_INSOVR_IND Char 1                    Y/N                    'N'
STATE_RESIDENCE    Char 6                    Prmt STATE_NAMES_VW
ETHNIC_GROUP       Char 1                    Xlat
ACAD_PLAN          Char 10                   Prmt ACAD_PLAN_TBL
ACAD_SUB_PLAN      Char 10                   Prmt ACAD_SUBPLN_TBL
FORM_OF_STUDY      Char 4                    Xlat
ATHL_PARTIC_CD     Char 5                    Prmt ATHL_PART_TBL
STDNT_GROUP        Char 4                    Prmt STDNT_GROUP_TBL
CAREER_MATCH_IND   Char 1                    Y/N                    'N'
ACAD_STANDING      Char 4                    Prmt ACAD_STACTN_TBL
SPORT              Char 3                    Xlat
COUNTRY            Char 3                    Prmt COUNTRY_TBL
NSLDS_LOAN_YR_IND  Char 1                    Y/N                    'N'
FFELP_TOL_VAL      Num  5
DISB_PRORATN_RULE  Char 10                   Prmt DISB_PRORATION
AUTH_TO_FEE_IND    Char 1                    Y/N                    'N'
AUTH_IF_ENROLL     Char 1                    Y/N
POST_DISB_RED      Char 1
POST_DISB_RED_CDT  Char 1
LOAN_INTERVIEW_SW  Char 1
PRORA_CENSUS_DT_SW Char 1
FA_USE_CURRENT_LD  Char 3                    Xlat
FA_USE_CURR_UNITS  Char 3                    Xlat
SFA_ASG_ACAD_IND   Char 1
SFA_ASG_CIP_IND    Char 1
SFA_ASG_GPA_IND    Char 1
SFA_ASG_IGRADE_IND Char 1
SFA_ASG_PELL_IND   Char 1
SFA_ASG_MIN_GPA    Num  5.3
SFA_ASG_SMART_CIP  Char 1                    Xlat

Record: INSTITUTION_VW3	
	Description	Institution View 3	
	Record Type	SQL View	
	Parent Record	 	
	Related Language	INST_VW1_LANG	
	DDL Space Name	SRAPP	
	Build Seq	1	
	Owner ID	SFAT	
	Comments	
		Used as a search record by the Weeks of Instruction Set Up.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
EFFDT              Date 10     KD        Req                        %date
EFF_STATUS         Char 1                Req Xlat                   'A'
DESCR              Char 30       L       Req
DESCRSHORT         Char 10       L                                  INSTITUTION_TBL.DESCR

Record: SFA_ASG_AL_COPY	
	Description	ACG/SMART Acad Level Set Up	
	Record Type	SQL View	
	Parent Record	INSTITUTION_TBL	
	Related Language	 	
	DDL Space Name	FAAPP	
	Build Seq	1	
	Owner ID	SFAT	
	Comments	
		FA Term uses this set up table to caluclate Academic Level for ACG/S
		MART Grant functionality.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL
AID_YEAR           Char 4      KALS      Req Prmt AID_YEAR_TBL
ACAD_CAREER        Char 4      KALS          Prmt ACAD_CAR_TBL
ACAD_PROG          Char 5      KA            Prmt ACAD_PROG_TBL
ACAD_PLAN          Char 10     KA            Prmt ACAD_PLAN_TBL
LEVEL_LOAD_RULE    Char 5                Req Prmt LVL_LD_RULE_TBL

Record: SFA_ASG_AL_TBL	
	Description	ACG/SMART Acad Level Set Up
	Record Type	SQL Table
	Parent Record	INSTITUTION_TBL
	Related Language	 
	DDL Space Name	FAAPP
	Owner ID	SFAT
	Comments	FA Term uses this set up table to caluclate Academic Level for ACG/S
		MART Grant functionality.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL
AID_YEAR           Char 4      KALS      Req Prmt AID_YEAR_TBL
ACAD_CAREER        Char 4      KALS          Prmt ACAD_CAR_TBL
ACAD_PROG          Char 5      KA            Prmt ACAD_PROG_TBL
ACAD_PLAN          Char 10     KA            Prmt ACAD_PLAN_TBL
LEVEL_LOAD_RULE    Char 5                Req Prmt LVL_LD_RULE_TBL

Record: SFA_ASG_ELG_DER	
	Description	Student Fin Aid Term Table	
	Record Type	Derived/Work	
	Parent Record	FA_FATERM_PARNT	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFAT	
	Comments	
		This table contains student information by Institution and Term. The
		primary use of this table is to provide a consolidated view of stud
		ent term data for Financial Aid processing purposes. This record is
		created from Stdnt_Car_Term, if student is continuing; otherwise it
		is created from Adm_Appl_Prog.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
SFA_ASG_AC_LVL_BOT Char 1                    Xlat
SFA_ASG_AC_LVL_EOT Char 1                    Xlat
OVRD_ASG_BOT       Char 1                    Y/N                    'N'
OVRD_ASG_EOT       Char 1                    Y/N                    'N'
SFA_ASG_AC_LVL_BCL Char 1                    Xlat
SFA_ASG_AC_LVL_ECL Char 1                    Xlat
SFA_ASG_UNITS_BOT  Num  5.3
SFA_ASG_UNITS_EOT  Num  5.3
SFA_ASG_WI_MTH     Char 1                    Xlat
SFA_ASG_WI_MTH_OVR Char 1                    Y/N
SFA_ASG_WI_MTH_CL  Char 1                    Xlat
SFA_ASG_WI_TRM     Num  3.2
SFA_ASG_WI_TRM_OVR Char 1                    Y/N
SFA_ASG_WI_TRM_CL  Num  3.2
SFA_ASG_WI_TCR     Num  3.2
SFA_ASG_WI_TCR_OVR Char 1                    Y/N
SFA_ASG_WI_TCR_CL  Num  3.2
SFA_ASG_WI_CUM_BOT Num  4.2
SFA_ASG_WI_CUM_EOT Num  4.2
SFA_ASG_WI_USED    Char 1

Record: SFA_ASG_FATALVW	
	Description	Student Fin Aid Term Table	
	Record Type	SQL View	
	Parent Record	FA_FATERM_PARNT	
	Related Language	 	
	DDL Space Name	FAAPP	
	Build Seq	1	
	Owner ID	SFAT	
	Comments	
		This table contains student information by Institution and Term. The
		primary use of this table is to provide a consolidated view of stud
		ent term data for Financial Aid processing purposes. This record is
		created from Stdnt_Car_Term, if student is continuing; otherwise it
		is created from Adm_Appl_Prog.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
EMPLID             Char 11     KALS      Req Prmt PERSONAL_DATA
INSTITUTION        Char 5      KA        Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
AID_YEAR           Char 4      KALS      Req Prmt AID_YEAR_FAT_VW   STDNT_AID_SRCH.AID_YEAR
SFA_ASG_GRANT_TYPE Char 4      KA            Xlat
STRM               Char 4      KD        Req Prmt TERM_VAL_TBL
SFA_ASG_AC_LVL_BOT Char 1                    Xlat
SFA_ASG_AC_LVL_EOT Char 1                    Xlat
OVRD_ASG_BOT       Char 1                    Y/N                    'N'
OVRD_ASG_EOT       Char 1                    Y/N                    'N'
SFA_ASG_AC_LVL_BCL Char 1                    Xlat
SFA_ASG_AC_LVL_ECL Char 1                    Xlat
SFA_ASG_UNITS_BOT  Num  5.3
SFA_ASG_UNITS_EOT  Num  5.3
SFA_ASG_WI_MTH     Char 1                    Xlat
SFA_ASG_WI_MTH_OVR Char 1                    Y/N
SFA_ASG_WI_MTH_CL  Char 1                    Xlat
SFA_ASG_WI_TRM     Num  3.2
SFA_ASG_WI_TRM_OVR Char 1                    Y/N
SFA_ASG_WI_TRM_CL  Num  3.2
SFA_ASG_WI_TCR     Num  3.2
SFA_ASG_WI_TCR_OVR Char 1                    Y/N
SFA_ASG_WI_TCR_CL  Num  3.2
SFA_ASG_WI_CUM_BOT Num  4.2
SFA_ASG_WI_CUM_EOT Num  4.2
SFA_ASG_WI_USED    Char 1

Record: SFA_ASG_WI_CAR	
	Description	ACG/SMART Acad Level Set Up	
	Record Type	SQL Table	
	Parent Record	INSTITUTION_TBL	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFAT	
	Comments	
		FA Term uses this set up table to caluclate Academic Level for ACG/S
		MART Grant functionality.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL
ACAD_CAREER        Char 4      KALS          Prmt ACAD_CAR_TBL
ACAD_PROG          Char 5      KA            Prmt ACAD_PROG_TBL
ACAD_PLAN          Char 10     KA            Prmt ACAD_PLAN_TBL
SFA_ASG_CALDR_TYPE Char 1                    Xlat
SFA_ASG_HRS_CRDTS  Num  4
SFA_ASG_WKS_ACADYR Char 2
SFA_ASG_WI_MTH     Char 1                    Xlat

Record: SFA_ASG_WI_TBL	
	Description	ACG/SMART Acad Level Set Up	
	Record Type	SQL Table	
	Parent Record	INSTITUTION_TBL	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFAT	
	Comments	
		FA Term uses this set up table to caluclate Academic Level for ACG/S
		MART Grant functionality.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
INSTITUTION        Char 5      KALS      Req Prmt INSTITUTION_TBL
SFA_ASG_CALDR_TYPE Char 1                    Xlat
SFA_ASG_HRS_CRDTS  Num  4
SFA_ASG_WKS_ACADYR Char 2
SFA_ASG_WI_MTH     Char 1                    Xlat
SFA_ASG_WI_STRM    Char 4                    Prmt TERM_VAL_TBL

Record: STDNT_FA_TERM	
	Description	Student Fin Aid Term Table
	Record Type	SQL Table
	Parent Record	FA_FATERM_PARNT
	Related Language	 
	DDL Space Name	FAAPP
	Owner ID	SFAT
	Comments	This table contains student information by Institution and Term. The
		primary use of this table is to provide a consolidated view of stud
		ent term data for Financial Aid processing purposes. This record is
		created from Stdnt_Car_Term, if student is continuing; otherwise it
		is created from Adm_Appl_Prog.

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
EMPLID             Char 11     KALS      Req Prmt PERSONAL_DATA
INSTITUTION        Char 5      KA        Req Prmt INSTITUTION_TBL   OPR_DEF_TBL_CS.INSTITUTION
STRM               Char 4      KD        Req Prmt TERM_VAL_TBL
EFFDT              Date 10     KD        Req                        %date
EFFSEQ             Num  3      KD        Req
EFF_STATUS         Char 1                    Xlat                   'A'
AID_YEAR           Char 4      ADL       Req Prmt AID_YEAR_FAT_VW   STDNT_AID_SRCH.AID_YEAR
BUDGET_REQUIRED    Char 1                    Xlat                   'Y'
WITHDRAW_CODE      Char 3                    Xlat                   'NWD'
WITHDRAW_REASON    Char 4                    Xlat
WITHDRAW_DATE      Date 10
LAST_DATE_ATTENDED Date 10
ACAD_CAREER        Char 4                    Prmt ACAD_CAR_TBL
ACAD_CAREER_CL     Char 4                         ACAD_CAR_TBL
OVRD_CAREER        Char 1                    Y/N                    'N'
ACAD_PLAN          Char 10                   Prmt ACAD_PLAN_TBLVW
ACAD_PLAN_CL       Char 10                        ACAD_PLAN_TBL
OVRD_ACAD_PLAN     Char 1                    Y/N                    'N'
ACAD_SUB_PLAN      Char 10                   Prmt ACAD_SUBPLN_TBL
ACAD_SUB_PLAN_CL   Char 10                        ACAD_SUBPLN_TBL
OVRD_SUB_PLAN      Char 1                    Y/N                    'N'
STDNT_CAR_NBR      Num  3                    Prmt %EDITTABLE
ACAD_PROG_PRIMARY  Char 5                    Prmt ACAD_PRGFA_CRVW
ACAD_PROG_PRIM_CL  Char 5                    Prmt ACAD_PROG_CARVW
OVRD_ACAD_PROG_PRM Char 1                    Y/N                    'N'
ACAD_LOAD_APPR     Char 1                    Xlat                   'F'
ACAD_LOAD_APPR_CL  Char 1
OVRD_ACAD_LOAD_AP  Char 1                    Y/N                    'N'
ACADEMIC_LOAD      Char 1                    Prmt FA_LOAD_VW
ACADEMIC_LOAD_CL   Char 1                    Xlat ACAD_LOAD_TBL
OVRD_ACADEMIC_LOAD Char 1                    Y/N                    'N'
ACAD_LEVEL_PROJ    Char 3                    Prmt ACAD_LEVEL_TBL
ACAD_LEVEL_PROJ_CL Char 3                    Xlat ACAD_LEVEL_TBL
ACAD_LEVEL_BOT     Char 3                    Prmt ACAD_LEVEL_TBL
ACAD_LEVEL_BOT_CL  Char 3                    Xlat ACAD_LEVEL_TBL
ACAD_LEVEL_EOT     Char 3                    Prmt ACAD_LEVEL_TBL
ACAD_LEVEL_EOT_CL  Char 3                    Xlat ACAD_LEVEL_TBL
OVRD_ACAD_LVL_PROJ Char 1                    Y/N                    'N'
OVRD_ACAD_LVL_ALL  Char 1                    Y/N                    'N'
ELIG_TO_ENROLL     Char 1                    Y/N                    'N'
RESET_CUM_STATS    Char 1                    Y/N                    'N'
FORM_OF_STUDY      Char 4                    Xlat                   'ENRL'
FORM_OF_STUDY_CL   Char 4                    Xlat
OVRD_FORM_OF_STUDY Char 1                    Y/N                    'N'
TERM_TYPE          Char 1                    Prmt TERM_TYPE_TBL     ACAD_CAR_TBL.TERM_TYPE
SEL_GROUP          Char 10                   Prmt SEL_GROUP_VW
TUIT_CALC_REQ      Char 1                    Y/N                    'N'
TUIT_CALC_DTTM     DT   26
BILLING_CAREER     Char 4                    Prmt ACAD_CAR_TBL      STDNT_FA_TERM.ACAD_CAREER
ACAD_YEAR          Char 4                                           TERM_TBL.ACAD_YEAR
ACAD_YEAR_CL       Char 4
OVRD_ACAD_YEAR     Char 1                    Y/N                    'N'
CUR_RESIDENT_TERMS Num  3.3
TRF_RESIDENT_TERMS Num  3.3
CUM_RESIDENT_TERMS Num  3.3
UNT_TAKEN_FA       Num  5.3
UNT_TAKEN_FA_CL    Num  5.3
OVRD_UNT_TAKEN_FA  Char 1                    Y/N                    'N'
UNT_PASSD_FA       Num  5.3
UNT_PASSD_FA_CL    Num  5.3
OVRD_UNT_PASSD_FA  Char 1                    Y/N                    'N'
TOT_TAKEN_FA       Num  5.3
TOT_TAKEN_FA_CL    Num  5.3
OVRD_TOT_TAKEN_FA  Char 1                    Y/N                    'N'
TOT_PASSD_FA       Num  5.3
TOT_PASSD_FA_CL    Num  5.3
OVRD_TOT_PASSD_FA  Char 1                    Y/N                    'N'
REMOTE_UNT_FA      Num  5.3
TOT_TERM_UNT_FA    Num  5.3
TOT_TERM_UNT_FA_CL Num  5.3
OVRD_FA_UNITS      Char 1                    Y/N                    'N'
FA_UNIT_WARNING    Char 1                    Y/N                    'N'
FA_LOAD            Char 1                    Prmt FA_LOAD_VW
FA_LOAD_CL         Char 1
OVRD_FA_LOAD       Char 1                    Y/N                    'N'
LS_GPA             Num  5.3
GPA_CL             Num  5.3
CUM_GPA            Num  5.3
CUM_GPA_CL         Num  5.3
OVRD_CUM_GPA       Char 1                    Y/N                    'N'
OVRD_GPA           Char 1                    Y/N                    'N'
GPA_CALC_IND       Char 1                    Y/N                    'N'
NSLDS_LOAN_YEAR    Char 1                    Xlat
NSLDS_LOAN_YEAR_CL Char 1                    Xlat
OVRD_NSLDS_LOAN_YR Char 1                    Y/N                    'N'
DIR_LND_YR         Char 2                    Xlat
DEGR_CONFER_DT     Date 10
EXP_GRAD_TERM      Char 4                    Prmt TERM_TBL
EXP_GRAD_TERM_CL   Char 4
OVRD_GRAD_TERM     Char 1                    Y/N                    'N'
EXP_GRAD_DATE      Date 10
EXP_GRAD_DATE_CL   Date 10
OVRD_GRAD_DATE     Char 1                    Y/N                    'N'
UNT_TAKEN_GPA      Num  5.3
TOT_TAKEN_GPA      Num  5.3
GRADE_POINTS       Num  6.3
TOT_GRADE_POINTS   Num  6.3
ACAD_STANDING      Char 4                    Prmt ACAD_STACTN_TBL
ACAD_STANDING_CL   Char 4                    Prmt ACAD_STACTN_TBL
OVRD_ACAD_STANDING Char 1                    Y/N                    'N'
FA_STANDING        Char 4                    Prmt ACAD_STACTN_TBL
FA_STANDING_CL     Char 4                    Prmt ACAD_STACTN_TBL
OVRD_FA_STANDING   Char 1                    Y/N                    'N'
CAMPUS             Char 5                Req Prmt HOME_CAMPUS_VW
EXT_ORG_ID         Char 11                   Prmt EXT_ORG_TBL
COUNTRY            Char 3                    Prmt COUNTRY_TBL
STUDY_AGREEMENT    Char 10                   Prmt STUDY_AGRM_TBL
START_DATE         Date 10
END_DATE           Date 10
ACAD_GROUP_ADVIS   Char 5                    Prmt ACAD_GROUP_TBL
ADMIT_TERM         Char 4                    Prmt TERM_VAL_TBL
PROJ_BILL_UNT      Num  3
OVRD_BILL_UNITS    Char 1                    Y/N
SRVC_IND_CD        Char 3
SRVC_IND_DTTM      DT   26
REFUND_PCT         Num  3.2
REFUND_SCHEME      Char 8
REFUND_SETID       Char 5
REFUND_CLASS       Char 1
CAMPUS_FA          Char 5                    Prmt HOME_CAMPUS_VW
CAMPUS_REGISTRAR   Char 5                    Prmt HOME_CAMPUS_VW
CAMPUS_ADVISEMENT  Char 5                    Prmt HOME_CAMPUS_VW
BUSINESS_UNIT      Char 5
ADVISOR_ROLE       Char 4                    Xlat
ADVISOR_ID         Char 11                   Prmt %EDITTABLE
COMMITTEE_ID       Char 6                    Prmt COMMITTEE
WEEKS_OF_INSTRUCT  Num  2
FA_STATS_CALC_REQ  Char 1                    Y/N                    'N'
FA_NUMBER_OF_WEEKS Num  3
COURSE_LD_PCT      Num  3.2
COST_CODE          Char 12
OVRD_EXP_DT        Date 10
DRIVER_OPTION      Char 1                    Xlat
ONLINE_BATCH_IND   Char 1
TERM_SRC           Char 1                                           'M'
CREATION_DT        Date 10
OPRID              Char 30
PROCESS_INSTANCE   Num  10
UNT_TAKEN_FA_INEL  Num  5.3
UNT_PASSD_FA_INEL  Num  5.3
UNT_TAKEN_PRG_INEL Num  5.3
GRADE_POINTS_INEL  Num  6.3
UNT_TAKEN_GPA_INEL Num  5.3
FA_CAR_TYPE        Char 1                    Xlat
UNT_TAKEN_FA_NOPIT Num  5.3
LOCK_OVRD_DATE     Date 10
LOCK_OVRD_OPRID    Char 30
OVRD_CENSUSDT_LOCK Char 1                    Y/N                    'N'
UNT_TRNSFR         Num  5.3
TRF_PASSED_GPA     Num  5.3
TRF_PASSED_NOGPA   Num  5.3
UNT_TEST_CREDIT    Num  5.3
UNT_OTHER          Num  5.3
TC_UNITS_ADJUST    Num  5.3
TOT_TRNSFR         Num  5.3
TOT_TEST_CREDIT    Num  5.3
TOT_OTHER          Num  5.3
TOT_TC_UNIT_ADJUST Num  5.3
FA_EXP_DT_REBUILD  Char 1                    Y/N                    'N'
FA_UNIT_ANTIC      Num  5.3
FA_UNIT_COMPLETED  Num  5.3
FA_UNIT_IN_PROG    Num  5.3
FA_UNIT_CURRENT    Num  5.3
FA_LOAD_CURRENT    Char 1                    Prmt FA_LOAD_VW
FA_REBUILD_DT      Date 10
ACAD_PLAN_TYPE     Char 3                    Xlat
FA_LOAD_CHANGE_IND Char 1                    Xlat
CENSUS_DT          Date 10
AID_YEAR_CL        Char 4                    Prmt AID_YEAR_FAT_VW
OVRD_AID_YEAR      Char 1                    Y/N
FA_OEE_STUDENT     Char 1                    Y/N
DIR_LND_YR_CL      Char 2                    Xlat
OVRD_DIR_LND_YR    Char 1                    Y/N
SFA_ASG_AC_LVL_BOT Char 1                    Xlat
SFA_ASG_AC_LVL_EOT Char 1                    Xlat
OVRD_ASG_BOT       Char 1                    Y/N                    'N'
OVRD_ASG_EOT       Char 1                    Y/N                    'N'
SFA_ASG_AC_LVL_BCL Char 1                    Xlat
SFA_ASG_AC_LVL_ECL Char 1                    Xlat
SFA_ASG_UNITS_BOT  Num  5.3
SFA_ASG_UNITS_EOT  Num  5.3
SFA_ASG_WI_MTH     Char 1                    Xlat
SFA_ASG_WI_MTH_OVR Char 1                    Y/N
SFA_ASG_WI_MTH_CL  Char 1                    Xlat
SFA_ASG_WI_TRM     Num  3.2
SFA_ASG_WI_TRM_OVR Char 1                    Y/N
SFA_ASG_WI_TRM_CL  Num  3.2
SFA_ASG_WI_TCR     Num  3.2
SFA_ASG_WI_TCR_OVR Char 1                    Y/N
SFA_ASG_WI_TCR_CL  Num  3.2
SFA_ASG_WI_CUM_BOT Num  4.2
SFA_ASG_WI_CUM_EOT Num  4.2
SFA_ASG_WI_USED    Char 1

Record: UPG_SFAAL_TAO	
	Description	HERA Acad Level Upgrade Temp	
	Record Type	Temporal	
	Parent Record	GROUP_CONT_INFO	
	Related Language	 	
	DDL Space Name	SAAPP	
	Owner ID	SFA	

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
INSTITUTION        Char 5      KA
RECORD_COUNT       Num  7

Record: UPG_SFATM_TAO	
	Description	Upgrade HERA Acad Level and WI	
	Record Type	Temporal	
	Parent Record	 	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFA	
	Comments	
		State Record for HERA Acad Level and Weeks of Instruction process

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
EMPLID             Char 11     KA
INSTITUTION        Char 5      KA
STRM               Char 4      KA
EFFDT              Date 10     KD
EFFSEQ             Num  3      KA
FA_STATS_CALC_REQ  Char 1

Record: UPG_SFA_AL_AET	
	Description	Upgrade HERA Acad Level and WI	
	Record Type	Derived/Work	
	Parent Record	 	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFA	
	Comments	
		State Record for HERA Acad Level and Weeks of Instruction process

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
RUN_CNTL_ID        Char 30
OPRID              Char 30
AE_APPLID          Char 12
AE_SECTION         Char 8
RECORD_COUNT       Num  7

Record: UPG_SFA_TM2_AET	
	Description	Upgrade HERA Acad Level and WI	
	Record Type	Derived/Work	
	Parent Record	 	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFA	
	Comments	
		State Record for HERA Acad Level and Weeks of Instruction process

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
RUN_CNTL_ID        Char 30
OPRID              Char 30
AE_APPLID          Char 12
AE_SECTION         Char 8
RECORD_COUNT       Num  7

Record: UPG_SFA_TM3_AET	
	Description	Upgrade HERA Acad Level and WI	
	Record Type	Derived/Work	
	Parent Record	 	
	Related Language	 	
	DDL Space Name	FAAPP	
	Owner ID	SFA	
	Comments	
		State Record for HERA Acad Level and Weeks of Instruction process

FieldName          Type   Len  Key  Srch Req Edit Prompt          C Default                          
PROCESS_INSTANCE   Num  10     KA
RUN_CNTL_ID        Char 30
OPRID              Char 30
AE_APPLID          Char 12
AE_SECTION         Char 8
RECORD_COUNT       Num  7

Field Detail

Field: AV_INC_MAN_MGD_MEM	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SAV	
	Comments	
		Flag to signify whether manually managedgifts are to be included dur
		ing the Gift initialization process (AVPGCLUB).

Label ID            Short Name       Long Name                       Def
AV_INC_MGD_MAN      Inc. Man. Mem.   Include Managed Members         Yes

Field: GCLUB_ADDED_BY	
	Field Type	Char
	Length	1
	Format	UpperCase
	Family Name	 
	Display Name	 
	Owner ID	SAV	

Label ID            Short Name       Long Name                       Def
GCLUB_ADDED_BY      Added By         Added By                        Yes

Field: SFA_ASG_AC_LVL_BOT	
	Field Type	Char
	Length	1
	Format	UpperCase
	Family Name	 
	Display Name	 
	Owner ID	SFAT
	Comments	ACG/SMART Grant Acadeic Level at the Beginning of the term.

Label ID            Short Name       Long Name                       Def
ACADEMICLEVEL       Level            HERA Academic Level
ACADLEVEL-TERMSTAR  Term Start       Acad Level - Term Start
ACAD_LEVEL_BOT      Start Level      Academic Level - Term Start     Yes
BOT                 BOT              Beginning of Term
START               Start            Start

Field: SFA_ASG_CALDR_TYPE	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
ACADCALTYPE         Clndr Type       Academic Calendar Type          Yes
ACADEMIC_CALENDAR   Acad Clndr       Academic Calendar
ACAD_CALEND         AcadCalend       Acad Calendar

Field: SFA_ASG_FAT_AL_PB	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	

Label ID            Short Name       Long Name                       Def
SFA_ASG_FAT_AL_PB   HERA Level       HERA Level                      Yes

Field: SFA_ASG_HRS_CRDTS	
	Field Type	Num	
	Length	4	
	Decimal Positions	0	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
HOURS_CREDITS       Hrs/Cred         Hours/Credits in Acad Year      Yes

Field: SFA_ASG_SMART_CIP	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAD	

Label ID            Short Name       Long Name                       Def
SMART               SMART            SMART Enrollment Verification   Yes

Field: SFA_ASG_UNITS_BOT	
	Field Type	Num	
	Length	9	
	Decimal Positions	3	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
HERA_UNITS          HERA Units       HERA Cumulative Units
SFA_ASG_UNITS_BOT   Begin Units      Units Beginning of Term         Yes

Field: SFA_ASG_UNITS_EOT	
	Field Type	Num	
	Length	9	
	Decimal Positions	3	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_UNITS_EOT   End Units        Units End of Term               Yes

Field: SFA_ASG_WI_CUM_BOT	
	Field Type	Num	
	Length	7	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_CUM      Cumulative       Cumulative Weeks                Yes
SFA_ASG_WI_CUM_BOT  Beginning        Beginning of Term

Field: SFA_ASG_WI_CUM_EOT	
	Field Type	Num	
	Length	7	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_EOT      End of Term      End of Term Cumulative          Yes

Field: SFA_ASG_WI_MTH	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
CARPROGPLAN         Career Set Up    Career/Program/Plan Set Up
DEFLTMETHOD         Default Set Up   Default Weeks of Inst Method
SFA_ASG_WI_MTH      Method           Weeks of Instruction Method     Yes
WEEKSOFINSTRUCTION  Weeks            Weeks of Instruction

Field: SFA_ASG_WI_MTH_CL	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_MTH_CL   Calc WI Meth     Calculated Weeks of Inst Meth   Yes

Field: SFA_ASG_WI_MTH_OVR	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_MTH_OVR  Ovrd             Override Weeks of Instrct Meth  Yes

Field: SFA_ASG_WI_STRM	
	Field Type	Char	
	Length	4	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
BEGINWITERM         Beginning Term   Begin Weeks if Inst calc Term   Yes
STRM                Term             Term

Field: SFA_ASG_WI_TCR	
	Field Type	Num	
	Length	6	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_TCR      Weeks            Transfer Weeks                  Yes

Field: SFA_ASG_WI_TCR_CL	
	Field Type	Num	
	Length	6	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_TCR      Weeks            Calculated Transfer Weeks       Yes

Field: SFA_ASG_WI_TCR_OVR	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_TCR_OVR  Ovrd             Override Transfer Weeks         Yes

Field: SFA_ASG_WI_TRM	
	Field Type	Num	
	Length	6	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	

Label ID            Short Name       Long Name                       Def
HERAWEEKS           HERA             HERA Weeks of Instruction       Yes
SFA_ASG_WI_TRM      Weeks for Term   Weeks of Instruction for Term
TERM_WEEKS          Term             Term Weeks
WEEKSOFINST         Weeks            Weeks if Instruction

Field: SFA_ASG_WI_TRM_CL	
	Field Type	Num	
	Length	6	
	Decimal Positions	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_TRM_CL   Calc Term Weeks  Calculated Term Weeks           Yes

Field: SFA_ASG_WI_TRM_OVR	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
SFA_ASG_WI_TRM_OVR  Ovrd Term Weeks  Override Term Weeks of Inst     Yes

Field: SFA_ASG_WI_USED	
	Field Type	Char	
	Length	1	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
NEWMETHODUSED       New Method Ued   New Level Method Used           Yes
SFA_ASG_WI_USED     Weeks Used       Weeks of Instruction Used

Field: SFA_ASG_WKS_ACADYR	
	Field Type	Char	
	Length	2	
	Format	UpperCase	
	Family Name	 	
	Display Name	 	
	Owner ID	SFAT	

Label ID            Short Name       Long Name                       Def
WEEKS_PROG_ACADYR   Weeks Acad Yr    Weeks in Program Acad Year      Yes

Translate Value Detail

Translate Value: GCLUB_ADDED_BY (C)	ENG	1900-01-01
	Field Name	GCLUB_ADDED_BY
	Value	C
	EffDt	1900-01-01
	Status	Active
	Long Name	Batch Process	Computer
	Short Name	Batch	Comp

Translate Value: GCLUB_ADDED_BY (X)	ENG	1900-01-01
	Field Name	GCLUB_ADDED_BY	
	Value	X	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Managed Manually	
	Short Name	Mgd. Man.	

Translate Value: GCLUB_MBR_STATUS (D)	ENG	1900-01-01
	Field Name	GCLUB_MBR_STATUS	
	Value	D	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Removed - Donor request	
	Short Name	Remove - D	

Translate Value: GCLUB_MBR_STATUS (R)	ENG	1900-01-01
	Field Name	GCLUB_MBR_STATUS	
	Value	R	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Removed - Manually	
	Short Name	Remove - M	

Translate Value: GCLUB_MBR_STATUS (X)	ENG	1900-01-01
	Field Name	GCLUB_MBR_STATUS	
	Value	X	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Managed Member	
	Short Name	Mgd Member	

Translate Value: SFA_ASG_CALDR_TYPE (1)	ENG	1900-01-01
	Field Name	SFA_ASG_CALDR_TYPE	
	Value	1	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Semester/Trimester, 2 payments	
	Short Name	Sem/Tri 2	

Translate Value: SFA_ASG_CALDR_TYPE (2)	ENG	1900-01-01
	Field Name	SFA_ASG_CALDR_TYPE	
	Value	2	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Quarter, 3 payments	
	Short Name	Quarter 3	

Translate Value: SFA_ASG_CALDR_TYPE (3)	ENG	1900-01-01
	Field Name	SFA_ASG_CALDR_TYPE	
	Value	3	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Semester/Trimester, 3 payments	
	Short Name	Sem/Tri 3	

Translate Value: SFA_ASG_CALDR_TYPE (4)	ENG	1900-01-01
	Field Name	SFA_ASG_CALDR_TYPE	
	Value	4	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Quarter, 4 payments	
	Short Name	Quarter, 4	

Translate Value: SFA_ASG_SMART_CIP (1)	ENG	1900-01-01
	Field Name	SFA_ASG_SMART_CIP	
	Value	1	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Course Catalog	
	Short Name	Course	

Translate Value: SFA_ASG_SMART_CIP (2)	ENG	1900-01-01
	Field Name	SFA_ASG_SMART_CIP	
	Value	2	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Subject Table	
	Short Name	Subject	

Translate Value: SFA_ASG_WI_MTH (C)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH	
	Value	C	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Credit Based	
	Short Name	Credit	

Translate Value: SFA_ASG_WI_MTH (E)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH	
	Value	E	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Exact Accounting	
	Short Name	Exact	

Translate Value: SFA_ASG_WI_MTH (L)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH	
	Value	L	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Grade Level	
	Short Name	Level	

Translate Value: SFA_ASG_WI_MTH (T)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH	
	Value	T	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Term Based	
	Short Name	Term	

Translate Value: SFA_ASG_WI_MTH_CL (C)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH_CL	
	Value	C	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Credit Based	
	Short Name	Credit	

Translate Value: SFA_ASG_WI_MTH_CL (E)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH_CL	
	Value	E	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Exact Accouting	
	Short Name	Exact	

Translate Value: SFA_ASG_WI_MTH_CL (L)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH_CL	
	Value	L	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Grade Level	
	Short Name	Level	

Translate Value: SFA_ASG_WI_MTH_CL (T)	ENG	1900-01-01
	Field Name	SFA_ASG_WI_MTH_CL	
	Value	T	
	EffDt	1900-01-01	
	Status	Active	
	Long Name	Term Based	
	Short Name	Term	

Page Detail

Page: AV_GCLUB_MBR_SBP (ENG)
	Description	 
	Type	SubPage
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   DERIVED_AV_GP   STAFF_ID           [None ]             Hide
SubPage  2     0                                      ''                  -> AV_FISCAL_YR_SBP
ScrArea  .3    1                                      ''                  Lvl 1 #1
EditBox  .4    1   AV_GCLUB_MBR    GCLUB_CD           -GCLUB_CD           CtrlFld
EditBox  .5    1   AV_GCLUB_TBL    GLCUB_NAME         [None ]             Gray Related:4
EditBox  .6    1   AV_GCLUB_MBR    FISCAL_YEAR        +FISCAL_YEAR
EditBox  .7    1   AV_GCLUB_TBL    STAFF_ID           +STAFF_ID           Hide Related:4
EditBox  .8    1   AV_GCLUB_MBR    GCLUB_LVL          -GCLUB_LVL
EditBox  .9    1   AV_GCLUB_MBR    GCLUB_MBR_DT       +GCLUB_MBR_DT       Century
ComboBox .10   1   AV_GCLUB_MBR    GCLUB_MBR_STATUS   +GCLUB_MBR_STATUS   XLatShort
ComboBox .10   1   AV_GCLUB_MBR    GCLUB_MBR_STATUS   +GCLUB_MBR_STATUS   XLatLong
EditBox  .11   1   AV_GCLUB_MBR    CURRENCY_CD        [None ]             Gray
EditBox  .12   1   AV_GCLUB_MBR    GCLUB_ADDED_BY     +GCLUB_ADDED_BY     Hide CtrlFld
EditBox  .13   1   XLATTABLE       XLATLONGNAME       [None ]             Gray Related:12
EditBox  .14   1   AV_GCLUB_MBR    LAST_UPDATE_DTTM   -LAST_UPD_DTTM2     Gray
EditBox  .15   1   AV_GCLUB_MBR    GCLUB_AMT          -GCLUB_AMT          Zero noPrompt Commas
EditBox  .16   1   AV_GCLUB_MBR    DESCRLONG          +DESCRLONG

Page: AV_RELATE_E_SP (ENG)
	Description	 
	Type	Secondary Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   AV_RELATE_EP_VW EXT_ORG_ID_RELATED -                   Gray CtrlFld
EditBox  2     0   EXT_ORG_TBL     DESCR              [None ]             Hide Related:1
EditBox  1     0   AV_RELATE_EP_VW EXT_ORG_ID_RELATED -EXT_ORG_ID_RELATED Gray CtrlFld
EditBox  2     0   AV_EXT_ORG_2_VW NAME               +NAME               Hide Related:1
EditBox  3     0   AV_RELATE_EP_VW EXT_ORG_ID         [None ]             Hide CtrlFld
EditBox  4     0   AV_ORG_DATA_VW  DESCR              [None ]             Hide Related:3
EditBox  5     0   EXT_ORG_TBL     CITY               [None ]             Hide Related:1
EditBox  6     0   EXT_ORG_TBL     STATE              [None ]             Hide Related:1
EditBox  7     0   EXT_ORG_TBL     POSTAL             [None ]             Hide Related:1
EditBox  8     0   EXT_ORG_TBL     COUNTY             [None ]             Hide Related:1
EditBox  9     0   EXT_ORG_TBL     COUNTRY            [None ]             Hide Related:1
EditBox  10    0   EXT_ORG_TBL     ADDRESS2           [None ]             Hide Related:1
EditBox  11    0   EXT_ORG_TBL     ADDRESS3           [None ]             Hide Related:1
EditBox  12    0   EXT_ORG_TBL     ADDRESS4           [None ]             Hide Related:1
EditBox  13    0   EXT_ORG_TBL     ADDRESS1           [None ]             Hide Related:1
ComboBox 14    0   AV_RELATE_EP_VW ORG_RELATION       +                   Hide CtrlFld XLatLong
ComboBox 14    0   AV_RELATE_EP_VW ORG_RELATION       +ORG_RELATION       Hide CtrlFld XLatLong
EditBox  15    0   AV_XL_O_REL_VW  XLATLONGNAME       [None ]             Gray Related:14
EditBox  16    0   AV_RELATE_EP_VW ORG_RELATE_RCP     +                   Hide CtrlFld
EditBox  17    0   AV_RELATE_EP_VW DESCR              +                   Gray
EditBox  18    0   AV_RELATE_EP_VW BEGIN_DT           +                   Gray Century
EditBox  19    0   AV_RELATE_EP_VW END_DT             +                   Gray Century
EditBox  16    0   AV_RELATE_EP_VW ORG_RELATE_RCP     +ORG_RELATE_RCP     Hide CtrlFld
EditBox  17    0   DERIVED_AV      DESCR              +DESCR              Gray
EditBox  18    0   AV_RELATE_EP_VW BEGIN_DT           +BEGIN_DT           Gray Century
EditBox  19    0   AV_RELATE_EP_VW END_DT             +END_DT             Gray Century
EditBox  20    0   AV_O_RCP_REL_VW ORG_RELATE_RCP     [None ]             Hide Related:14
EditBox  21    0   AV_O_REL_RCP_VW RELATIONSHIP_NAME  [None ]             Gray Related:16
EditBox  22    0   AV_RELATE_EP_VW SRC_DESCR          +                   Gray
EditBox  23    0   AV_RELATE_EP_VW EMAILID            +                   Gray
EditBox  24    0   AV_RELATE_EP_VW URL_ADDRESS        +                   Gray
EditBox  25    0   AV_RELATE_EP_VW COMMENTS           +                   Gray
PushBtn  26    0   DERIVED_AV_PO   ADDRESS_BTN        -                   PushBtn->SecPage AV_EP_REL_ADDR_SP
EditBox  22    0   AV_RELATE_EP_VW SRC_DESCR          +SRC_DESCR          Gray
EditBox  23    0   AV_RELATE_EP_VW EMAILID            +EMAILID            Gray
EditBox  24    0   AV_RELATE_EP_VW URL_ADDRESS        +URL_ADDRESS        Gray
EditBox  25    0   AV_RELATE_EP_VW COMMENTS           +COMMENTS           Gray
PushBtn  26    0   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     PushBtn->SecPage AV_EP_REL_ADDR_SP
ScrBar   .27   1                                      [None ]             Lvl 1 #1 Hide
EditBox  .28   1   AV_EXT_ORG_VW   EXT_ORG_ID         [None ]             Hide

Page: AV_RELATIONSHIPS_E (ENG)
	Description	 
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   AV_ORG_DATA_VW  DESCR              [None ]             Hide
SubPage  2     0                                      ''                  -> AV_ORG_SRCH_SBP
ScrArea  .3    1                                      [#14390,23]         Lvl 1 #1
EditBox  .4    1   AV_RELATE_E     EXT_ORG_ID_RELATED +EXT_ORG_ID_RELATED CtrlFld
EditBox  .5    1   EXT_ORG_TBL     DESCR              [None ]             Hide Related:4
EditBox  .5    1   AV_EXT_ORG_2_VW NAME               [None ]             Hide Related:4
EditBox  .6    1   AV_RELATE_E     ORG_RELATE_NBR     +ORG_RELATE_NBR     Gray
EditBox  .7    1   DERIVED_AV_PO   EXT_ORG_ID_RELATED [None ]             Hide
EditBox  .8    1   EXT_ORG_TBL     CITY               [None ]             Hide Related:4
EditBox  .9    1   EXT_ORG_TBL     STATE              [None ]             Hide Related:4
EditBox  .10   1   EXT_ORG_TBL     POSTAL             [None ]             Hide Related:4
EditBox  .11   1   EXT_ORG_TBL     COUNTY             [None ]             Hide Related:4
EditBox  .12   1   EXT_ORG_TBL     COUNTRY            [None ]             Hide Related:4
EditBox  .13   1   EXT_ORG_TBL     ADDRESS2           [None ]             Hide Related:4
EditBox  .14   1   EXT_ORG_TBL     ADDRESS3           [None ]             Hide Related:4
EditBox  .15   1   EXT_ORG_TBL     ADDRESS4           [None ]             Hide Related:4
EditBox  .16   1   EXT_ORG_TBL     ADDRESS1           [None ]             Hide Related:4
EditBox  .8    1   AV_EXT_ORG_2_VW CITY               [None ]             Hide Related:4
EditBox  .9    1   AV_EXT_ORG_2_VW STATE              [None ]             Hide Related:4
EditBox  .10   1   AV_EXT_ORG_2_VW POSTAL             [None ]             Hide Related:4
EditBox  .11   1   AV_EXT_ORG_2_VW COUNTY             [None ]             Hide Related:4
EditBox  .12   1   AV_EXT_ORG_2_VW COUNTRY            [None ]             Hide Related:4
EditBox  .13   1   AV_EXT_ORG_2_VW ADDRESS2           [None ]             Hide Related:4
EditBox  .14   1   AV_EXT_ORG_2_VW ADDRESS3           [None ]             Hide Related:4
EditBox  .15   1   AV_EXT_ORG_2_VW ADDRESS4           [None ]             Hide Related:4
EditBox  .16   1   AV_EXT_ORG_2_VW ADDRESS1           [None ]             Hide Related:4
ComboBox .17   1   AV_RELATE_E     ORG_RELATION       +ORG_RELATION       CtrlFld XLatLong
EditBox  .18   1   AV_XL_O_REL_VW  XLATLONGNAME       [None ]             Hide Related:17
EditBox  .19   1   AV_RELATE_E     ORG_RELATE_RCP     +ORG_RELATE_RCP     CtrlFld
EditBox  .20   1   AV_RELATE_E     DESCR              +DESCR
EditBox  .21   1   AV_RELATE_E     BEGIN_DT           +BEGIN_DT           Century
EditBox  .22   1   AV_RELATE_E     END_DT             +END_DT             Century
EditBox  .23   1   AV_O_RCP_REL_VW ORG_RELATE_RCP     [None ]             Hide Related:17
EditBox  .24   1   AV_O_REL_RCP_VW RELATIONSHIP_NAME  [None ]             Gray Related:19
EditBox  .25   1   AV_RELATE_E     SRC_DESCR          +SRC_DESCR
EditBox  .26   1   AV_RELATE_E     EMAILID            +EMAILID
EditBox  .27   1   AV_RELATE_E     URL_ADDRESS        +URL_ADDRESS
EditBox  .28   1   AV_RELATE_E     COMMENTS           +COMMENTS
PushBtn  .29   1   DERIVED_AV_PO   ADDRESS_BTN        -ADDRESS_BTN        HypLink->SecPage AV_O_REL_ADDR_SEC
PushBtn  .29   1   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     HypLink->SecPage AV_O_REL_ADDR_SEC
ScrBar   .30   1                                      [None ]             Lvl 1 #1 noSel Hide
EditBox  .31   1   AV_RELATE_E_VW  ORG_RELATE_NBR     [None ]             Hide
ScrBar   .32   1                                      [None ]             Lvl 1 #1 Hide
EditBox  .33   1   AV_EXT_ORG_VW   EXT_ORG_ID         [None ]             Hide

Page: AV_RELATION_EP (ENG)
	Description	 
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0   AV_ORG_DATA_VW                     ''                  -> AV_INST_E_SBP
ScrArea  .2    1                                      [#14390,23]         Lvl 1 #1
EditBox  .3    1   AV_RELATE_PE    EMPLID             [None ]             CtrlFld
EditBox  .4    1   PERSONAL_DATA   NAME               [None ]             Hide Related:3
EditBox  .5    1   AV_RELATE_PE    PE_RELATE_NBR      +PE_RELATE_NBR      Gray
EditBox  .6    1   AV_LBL_WRK      RLTD_ID_LBL        +RLTD_ID_LBL        Hide
ComboBox .7    1   AV_RELATE_PE    PE_RELATION        +PE_RELATION        Prompt: EP_REL_DESCR CtrlFld
EditBox  .8    1   AV_PE_RLTN_TBL  PE_REL_DESCR       [None ]             Hide Related:7
EditBox  .9    1   AV_PE_RLTN_TBL  EP_REL_DESCR       [None ]             Hide Related:7
EditBox  .10   1   PERSONAL_DATA   POSTAL             [None ]             Hide Related:3
EditBox  .11   1   PERSONAL_DATA   ADDRESS2           [None ]             Hide Related:3
EditBox  .12   1   PERSONAL_DATA   ADDRESS1           [None ]             Hide Related:3
EditBox  .13   1   AV_RELATE_PE    BEGIN_DT           +BEGIN_DT           Century
EditBox  .14   1   AV_RELATE_PE    END_DT             +END_DT             Century
EditBox  .15   1   PERSONAL_DATA   STATE              [None ]             Hide Related:3
EditBox  .16   1   PERSONAL_DATA   COUNTRY            [None ]             Hide Related:3
EditBox  .17   1   AV_RELATE_PE    NAME               +NAME
EditBox  .18   1   AV_RELATE_PE    NAME_PREFIX        -NAME_PREFIX
EditBox  .19   1   AV_RELATE_PE    NAME_SUFFIX        -NAME_SUFFIX
EditBox  .20   1   PERSONAL_DATA   NAME_PREFIX        [None ]             Hide Related:3
EditBox  .21   1   PERSONAL_DATA   NAME_SUFFIX        [None ]             Hide Related:3
EditBox  .22   1   AV_RELATE_PE    SSN                -SSN
EditBox  .23   1   PERSONAL_DATA   SEX                [None ]             Hide Related:3
EditBox  .24   1   PERS_NID_VW     NATIONAL_ID        [None ]             Hide Related:3
EditBox  .25   1   AV_RELATE_PE    SEX                +SEX
EditBox  .26   1   PERSONAL_DATA   ADDRESS4           [None ]             Hide Related:3
EditBox  .27   1   PERSONAL_DATA   ADDRESS3           [None ]             Hide Related:3
EditBox  .28   1   AV_RELATE_PE    SRC_DESCR          +SRC_DESCR
EditBox  .29   1   PERSONAL_DATA   COUNTY             [None ]             Hide Related:3
EditBox  .30   1   PERSONAL_DATA   CITY               [None ]             Hide Related:3
EditBox  .31   1   AV_RELATE_PE    COMMENTS           +COMMENTS
PushBtn  .32   1   DERIVED_AV_PO   ADDRESS_BTN        -ADDRESS_BTN        HypLink->SecPage AV_PE_REL_ADDR_SEC
PushBtn  .32   1   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     HypLink->PCode
SecPage  .33   1                                      ''                  -> AV_PE_REL_ADDR_SEC noDefrr Hide

Page: AV_RELATION_EP_SP (ENG)
	Description	 
	Type	Secondary Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   AV_RELATE_PE_VW EXT_ORG_ID         [None ]             Hide CtrlFld
EditBox  2     0   AV_RELATE_O_VW  DESCR50            [None ]             Hide Related:1
EditBox  3     0   AV_RELATE_PE_VW EMPLID             +EMPLID             Gray CtrlFld
EditBox  4     0   PERSONAL_DATA   NAME               [None ]             Hide Related:3
ComboBox 5     0   AV_RELATE_PE_VW PE_RELATION        +PE_RELATION        Prompt: EP_REL_DESCR Hide CtrlFld
EditBox  6     0   AV_PE_RLTN_TBL  PE_REL_DESCR       [None ]             Hide Related:5
EditBox  7     0   AV_PE_RLTN_TBL  EP_REL_DESCR       [None ]             Gray Related:5
EditBox  8     0   PERSONAL_DATA   POSTAL             [None ]             Hide Related:3
EditBox  9     0   PERSONAL_DATA   ADDRESS2           [None ]             Hide Related:3
EditBox  10    0   PERSONAL_DATA   ADDRESS1           [None ]             Hide Related:3
EditBox  11    0   AV_RELATE_PE_VW BEGIN_DT           +BEGIN_DT           Gray Century
EditBox  12    0   AV_RELATE_PE_VW END_DT             +END_DT             Gray Century
EditBox  13    0   PERSONAL_DATA   STATE              [None ]             Hide Related:3
EditBox  14    0   PERSONAL_DATA   COUNTRY            [None ]             Hide Related:3
EditBox  15    0   AV_RELATE_PE_VW NAME               +NAME               Gray
EditBox  15    0   DERIVED_AV      AV_RELATION_NAME   -AV_RELATION_NAME   Gray
EditBox  16    0   AV_RELATE_PE_VW NAME_PREFIX        +NAME_PREFIX        Gray
EditBox  17    0   AV_RELATE_PE_VW NAME_SUFFIX        +NAME_SUFFIX        Gray
EditBox  18    0   PERSONAL_DATA   NAME_PREFIX        [None ]             Hide Related:3
EditBox  19    0   PERSONAL_DATA   NAME_SUFFIX        [None ]             Hide Related:3
EditBox  20    0   AV_RELATE_PE_VW SSN                +SSN                Gray
EditBox  21    0   PERSONAL_DATA   SEX                [None ]             Hide Related:3
EditBox  22    0   PERS_NID_VW     NATIONAL_ID        [None ]             Hide Related:3
EditBox  23    0   AV_RELATE_PE_VW SEX                +SEX                Gray
EditBox  24    0   PERSONAL_DATA   ADDRESS4           [None ]             Hide Related:3
EditBox  25    0   PERSONAL_DATA   ADDRESS3           [None ]             Hide Related:3
EditBox  26    0   AV_RELATE_PE_VW SRC_DESCR          +SRC_DESCR          Gray
EditBox  27    0   PERSONAL_DATA   COUNTY             [None ]             Hide Related:3
EditBox  28    0   PERSONAL_DATA   CITY               [None ]             Hide Related:3
EditBox  29    0   AV_RELATE_PE_VW COMMENTS           +COMMENTS           Gray
PushBtn  30    0   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     PushBtn->SecPage AV_PE_REL_ADDR_SP

Page: AV_RELATION_PE (ENG)
	Description	 
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0                                      ''                  -> AV_INST_SBP
ScrArea  .2    1                                      [#14390,60]         Lvl 1 #1
EditBox  .3    1   AV_RELATE_PE    EXT_ORG_ID         [None ]             CtrlFld
EditBox  .4    1   EXT_ORG_TBL     DESCR              [None ]             Hide Related:3
EditBox  .4    1   AV_EXT_ORG_2_VW NAME               [None ]             Hide Related:3
EditBox  .5    1   AV_RELATE_PE    PE_RELATE_NBR      +PE_RELATE_NBR      Gray
EditBox  .6    1   DERIVED_AV_PO   EXT_ORG_ID_RELATED +EXT_ORG_ID_RELATED Hide
ComboBox .7    1   AV_RELATE_PE    PE_RELATION        +PE_RELATION        Prompt: PE_REL_DESCR CtrlFld
EditBox  .8    1   AV_PE_RLTN_TBL  PE_REL_DESCR       [None ]             Hide Related:7
EditBox  .9    1   AV_PE_RLTN_TBL  EP_REL_DESCR       [None ]             Hide Related:7
EditBox  .10   1   EXT_ORG_TBL     POSTAL             [None ]             Hide Related:3
EditBox  .11   1   EXT_ORG_TBL     ADDRESS2           [None ]             Hide Related:3
EditBox  .10   1   AV_EXT_ORG_2_VW POSTAL             [None ]             Hide Related:3
EditBox  .11   1   AV_EXT_ORG_2_VW ADDRESS2           [None ]             Hide Related:3
EditBox  .12   1   AV_RELATE_PE    DESCR              +DESCR
EditBox  .13   1   EXT_ORG_TBL     ADDRESS1           [None ]             Hide Related:3
EditBox  .13   1   AV_EXT_ORG_2_VW ADDRESS1           [None ]             Hide Related:3
EditBox  .14   1   AV_RELATE_PE    BEGIN_DT           +BEGIN_DT           Century
EditBox  .15   1   AV_RELATE_PE    END_DT             +END_DT             Century
EditBox  .16   1   EXT_ORG_TBL     STATE              [None ]             Hide Related:3
EditBox  .17   1   EXT_ORG_TBL     COUNTRY            [None ]             Hide Related:3
EditBox  .18   1   EXT_ORG_TBL     ADDRESS4           [None ]             Hide Related:3
EditBox  .19   1   EXT_ORG_TBL     ADDRESS3           [None ]             Hide Related:3
EditBox  .16   1   AV_EXT_ORG_2_VW STATE              [None ]             Hide Related:3
EditBox  .17   1   AV_EXT_ORG_2_VW COUNTRY            [None ]             Hide Related:3
EditBox  .18   1   AV_EXT_ORG_2_VW ADDRESS4           [None ]             Hide Related:3
EditBox  .19   1   AV_EXT_ORG_2_VW ADDRESS3           [None ]             Hide Related:3
EditBox  .20   1   AV_RELATE_PE    SRC_DESCR          +SRC_DESCR
EditBox  .21   1   EXT_ORG_TBL     COUNTY             [None ]             Hide Related:3
EditBox  .22   1   EXT_ORG_TBL     CITY               [None ]             Hide Related:3
EditBox  .21   1   AV_EXT_ORG_2_VW COUNTY             [None ]             Hide Related:3
EditBox  .22   1   AV_EXT_ORG_2_VW CITY               [None ]             Hide Related:3
EditBox  .23   1   AV_RELATE_PE    COMMENTS           +COMMENTS
PushBtn  .24   1   DERIVED_AV_PO   ADDRESS_BTN        -ADDRESS_BTN        HypLink->SecPage AV_PE_REL_ADDR_SEC
PushBtn  .24   1   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     HypLink->PCode
SecPage  .25   1                                      ''                  -> AV_PE_REL_ADDR_SEC noDefrr Hide

Page: AV_RELATION_PE_SP (ENG)
	Description	 
	Type	Secondary Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   AV_RELATE_PE_VW EXT_ORG_ID         +EXT_ORG_ID         Gray CtrlFld
EditBox  2     0   AV_RELATE_PE_VW NAME               +NAME               Gray
EditBox  3     0   EXT_ORG_TBL     DESCR              [None ]             Hide Related:1
EditBox  2     0   DERIVED_AV_PO   NAME               +NAME               Gray
EditBox  3     0   AV_EXT_ORG_2_VW NAME               [None ]             Hide Related:1
EditBox  4     0   DERIVED_AV_PO   EXT_ORG_ID_RELATED [None ]             Hide
ComboBox 5     0   AV_RELATE_PE_VW PE_RELATION        +PE_RELATION        Prompt: PE_REL_DESCR Hide CtrlFld
EditBox  6     0   AV_PE_RLTN_TBL  PE_REL_DESCR       [None ]             Gray Related:5
EditBox  7     0   AV_PE_RLTN_TBL  PE_REL_DESCR       [None ]             Hide Related:5
EditBox  8     0   AV_PE_RLTN_TBL  EP_REL_DESCR       [None ]             Hide Related:5
EditBox  9     0   EXT_ORG_TBL     POSTAL             [None ]             Hide Related:1
EditBox  10    0   EXT_ORG_TBL     ADDRESS2           [None ]             Hide Related:1
EditBox  11    0   EXT_ORG_TBL     ADDRESS1           [None ]             Hide Related:1
EditBox  12    0   AV_RELATE_PE_VW BEGIN_DT           +BEGIN_DT           Gray Century
EditBox  13    0   AV_RELATE_PE_VW END_DT             +END_DT             Gray Century
EditBox  14    0   EXT_ORG_TBL     STATE              [None ]             Hide Related:1
EditBox  15    0   EXT_ORG_TBL     COUNTRY            [None ]             Hide Related:1
EditBox  16    0   EXT_ORG_TBL     ADDRESS4           [None ]             Hide Related:1
EditBox  17    0   EXT_ORG_TBL     ADDRESS3           [None ]             Hide Related:1
EditBox  18    0   AV_RELATE_PE_VW SRC_DESCR          +SRC_DESCR          Gray
EditBox  19    0   EXT_ORG_TBL     COUNTY             [None ]             Hide Related:1
EditBox  20    0   EXT_ORG_TBL     CITY               [None ]             Hide Related:1
EditBox  21    0   AV_RELATE_PE_VW COMMENTS           +COMMENTS           Gray
PushBtn  22    0   DERIVED_AV_PO   ADDRESS_BTN        -BUTTON_ADDRESS     PushBtn->SecPage AV_PE_REL_ADDR_SP

Page: AV_RUNCTL_GCLUBS (ENG)
	Description	Giving Clubs Run Control Panel
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SAV
	Comments	This is the panel used to run the Giving Clubs backgroud process.

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0   PRCSRUNCNTL                        ''                  -> PRCSRUNCNTL_SBP
EditBox  2     0   AV_RUNCTL_GCLUB INSTITUTION        -INSTITUTION        noDefrr Gray CtrlFld
EditBox  3     0   AV_RUNCTL_GCLUB PROCESS_DATE       -PROCESS_DATE       Century
EditBox  4     0   AV_RUNCTL_GCLUB COMMIT_LEVEL       +COMMIT_LEVEL
EditBox  5     0   AV_RUNCTL_GCLUB CURRENCY_CD        +CURRENCY_CD        Gray
EditBox  6     0   AV_INSTALL_INST BASE_CURRENCY      [None ]             Hide Related:2
GroupBox 7     0   AV_RUNCTL_GCLUB AV_GCLUB_PRCS      +GCLUB_PRCS
RadioBtn 8     0   AV_RUNCTL_GCLUB AV_GCLUB_PRCS      [XLatLong]          Value:U
RadioBtn 9     0   AV_RUNCTL_GCLUB AV_GCLUB_PRCS      [XLatLong]          Value:S
RadioBtn 10    0   AV_RUNCTL_GCLUB AV_GCLUB_PRCS      [XLatLong]          Value:A
SubPage  11    0                                      ''                  -> AV_FISCAL_YR_SBP
PSGrid   .12   1   AV_RUNCTL_GCINT                    [None ]             Lvl 1 #5
EditBox  .13   1   AV_RUNCTL_GCINT GCLUB_CD           +GCLUB_CD           CtrlFld
EditBox  .14   1   AV_GCLUB_TBL    GLCUB_NAME         +GLCUB_NAME         Gray Related:13
CheckBox 11    0   AV_RUNCTL_GCLUB AV_INC_MAN_MGD_MEM +AV_INC_MGD_MAN     On:Y Off:N
SubPage  12    0                                      ''                  -> AV_FISCAL_YR_SBP
PSGrid   .13   1   AV_RUNCTL_GCINT                    [None ]             Lvl 1 #5
EditBox  .14   1   AV_RUNCTL_GCINT GCLUB_CD           +GCLUB_CD           CtrlFld
EditBox  .15   1   AV_GCLUB_TBL    GLCUB_NAME         +GLCUB_NAME         Gray Related:14

Page: DISB_RULE_ITM1 (ENG)
	Description	Disbursement Rule Item Type 1
	Type	Standard Page
	Allow Deferred Proc.	No
	Owner ID	SFAD
	Comments	General Item type disbursement rule

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  2     0   DERIVED         EDITTABLE          [None ]             Hide
EditBox  3     0   DERIVED_ITM_WRK SETID              [None ]             Hide
EditBox  4     0   DISB_RULE_ITM   ITEM_TYPE          +ITEM_TYPE          Gray CtrlFld
EditBox  5     0   DISB_RULE_ITM   AID_YEAR           +AID_YEAR           Gray CtrlFld
EditBox  6     0   DISB_RULE_ITM   INSTITUTION        -INSTITUTION        Gray CtrlFld
EditBox  7     0   ITEM_TP_FA_AWRD DESCR              [None ]             Gray Related:4
EditBox  8     0   DISB_RULE_ITM   ACAD_CAREER        +ACAD_CAREER        Hide CtrlFld
EditBox  9     0   ITEM_TYPE_FA    LOAN_PROGRAM       [None ]             Hide Related:5
EditBox  10    0   XLATTABLE       XLATLONGNAME       [None ]             Gray Related:8
ScrArea  .11   1                                      [#14403,16]         Lvl 1 #1
EditBox  .12   1   DISB_RULE_ITM   EFFDT              -EFFDT              Century
ComboBox .13   1   DISB_RULE_ITM   EFF_STATUS         -EFF_STATUS         XLatShort
EditBox  .14   1   DISB_RULE_ITM   DESCR              -DESCR
EditBox  .15   1   DISB_RULE_ITM   DESCRSHORT         -DESCRSHORT
SecPage  .16   1                                      [Image]             -> DISB_RULE_COPY Hide
PushBtn  .17   1   DERIVED_FA_COPY COPY_DATA_PUSHBTN  [#14407,90]         HypLink->PCode
HorRule  .18   1                                      [None ]
CheckBox .19   1   DISB_RULE_ITM   REVIEW_IND         +REVIEW_IND         On:Y Off:N
CheckBox .20   1   DISB_RULE_ITM   CAREER_MATCH_IND   +CAREER_MATCH_IND   On:Y Off:N
CheckBox .21   1   DISB_RULE_ITM   POST_DISB_RED_CDT  +POST_DISB_RED_CDT  On:Y Off:N
CheckBox .22   1   DISB_RULE_ITM   PKG_IND            +PKG_IND            On:Y Off:N
CheckBox .23   1   DISB_RULE_ITM   HONOR_DISB_IND     +HONOR_DISB_IND     On:Y Off:N
CheckBox .24   1   DISB_RULE_ITM   POST_DISB_RED      +POST_DISB_RED      On:Y Off:N
CheckBox .25   1   DISB_RULE_ITM   VERF_IND           +VERF_IND           On:Y Off:N
CheckBox .26   1   DISB_RULE_ITM   SAT_PROG_IND       +SAT_PROG_IND       On:Y Off:N
CheckBox .27   1   DISB_RULE_ITM   SFA_ASG_ACAD_IND   +ACAD_LVL           On:Y Off:N
CheckBox .28   1   DISB_RULE_ITM   EFC_IND            +EFC_IND            On:Y Off:N
CheckBox .29   1   DISB_RULE_ITM   HLD_DSB_FEDOVR_IND +HLD_DSB_FEDOVR_IND On:Y Off:N
CheckBox .30   1   DISB_RULE_ITM   SFA_ASG_CIP_IND    +CIP_CODE           On:Y Off:N
CheckBox .31   1   DISB_RULE_ITM   NSLDS_LOAN_YR_IND  +NSLDS_LOAN_YR_IND  On:Y Off:N
CheckBox .32   1   DISB_RULE_ITM   HLD_DSB_INSOVR_IND +HLD_DSB_INSOVR_IND On:Y Off:N
CheckBox .33   1   DISB_RULE_ITM   SFA_ASG_GPA_IND    +MIN_GPA            On:Y Off:N
CheckBox .34   1   DISB_RULE_ITM   LVL_MATCH_BDG_IND  +LVL_MATCH_BDG_IND  On:Y Off:N
CheckBox .35   1   DISB_RULE_ITM   WITHDRAW_IND       +WITHDRAW_IND       On:Y Off:N
CheckBox .36   1   DISB_RULE_ITM   SFA_ASG_IGRADE_IND +INCOMP_GRADE       On:Y Off:N Hide
CheckBox .37   1   DISB_RULE_ITM   AUTH_IF_ENROLL     +AUTH_IF_ENROLL     On:Y Off:N
CheckBox .38   1   DISB_RULE_ITM   FEE_MATCH_IND      +FEE_MATCH_IND      On:Y Off:N
CheckBox .39   1   DISB_RULE_ITM   SFA_ASG_PELL_IND   +PELL_IND           On:Y Off:N
CheckBox .40   1   DISB_RULE_ITM   LOAN_INTERVIEW_SW  +LOAN_INTERVIEW_SW  On:Y Off:N
CheckBox .41   1   DISB_RULE_ITM   AUTH_TO_FEE_IND    +AUTH_TO_FEE_IND    On:Y Off:N
CheckBox .42   1   DISB_RULE_ITM   LD_MATCH_BDG_IND   +LD_MATCH_BDG_IND   On:Y Off:N
GroupBox .43   1   DERIVED_FA_LBL  FA_LD_LEVEL_RULES  +FA_LD_LEVEL_RULES
ComboBox .44   1   DISB_RULE_ITM   DISB_PRORATN_RULE  +DISB_PRORATN_RULE  Prompt: DISB_PRORATN_RULE
CheckBox .45   1   DISB_RULE_ITM   PRORA_CENSUS_DT_SW +PRORA_CENSUS_DT_SW On:Y Off:N
CheckBox .46   1   DISB_RULE_ITM   LD_MATCH_AWD_IND   +LD_MATCH_AWD_IND   On:Y Off:N
ComboBox .47   1   DISB_RULE_ITM   FA_USE_CURRENT_LD  +FA_USE_CURRENT_LD  XLatShort
HorRule  .42   1                                      [None ]
ComboBox .43   1   DISB_RULE_ITM   SFA_ASG_SMART_CIP  +SMART              XLatShort
CheckBox .44   1   DISB_RULE_ITM   LD_MATCH_BDG_IND   +LD_MATCH_BDG_IND   On:Y Off:N
GroupBox .45   1   DERIVED_FA_LBL  FA_LD_LEVEL_RULES  +FA_LD_LEVEL_RULES
ComboBox .46   1   DISB_RULE_ITM   DISB_PRORATN_RULE  +DISB_PRORATN_RULE  Prompt: DISB_PRORATN_RULE
CheckBox .47   1   DISB_RULE_ITM   PRORA_CENSUS_DT_SW +PRORA_CENSUS_DT_SW On:Y Off:N
CheckBox .48   1   DISB_RULE_ITM   LD_MATCH_AWD_IND   +LD_MATCH_AWD_IND   On:Y Off:N
ComboBox .49   1   DISB_RULE_ITM   FA_USE_CURRENT_LD  +FA_USE_CURRENT_LD  XLatShort

Page: SFA_ASG_AL_COPY (ENG)
	Description	HERA Academic Level Setup Copy	
	Type	Secondary Page	
	Allow Deferred Proc.	Yes	
	Owner ID	SFAT	

Type     ID    Lvl Record          Field              Label               Attributes
GroupBox 1     0   DERIVED_FA_COPY COPY_FROM_TO_LBL   +COPY_FROM
GroupBox 2     0   DERIVED_FA_COPY COPY_FROM_TO_LBL   +COPY_TO
EditBox  3     0   SFA_ASG_AL_TBL  INSTITUTION        -INSTITUTION        Gray
EditBox  4     0   DERIVED_FA_COPY INSTITUTION        -INSTITUTION
EditBox  5     0   SFA_ASG_AL_TBL  AID_YEAR           +AID_YEAR           Gray
EditBox  6     0   DERIVED_FA_COPY AID_YEAR           +AID_YEAR
ScrBar   .7    1                                      [None ]             Lvl 1 #1
EditBox  .8    1   SFA_ASG_AL_COPY INSTITUTION        [None ]             Hide

Page: SFA_ASG_AL_SUBP (ENG)
	Description	ACG/SMART Acad Lv Setup Header
	Type	SubPage
	Allow Deferred Proc.	Yes
	Owner ID	SFAT
	Comments	Sub page used on ACG/SMART Academic Level Setup page.

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   INSTITUTION_TBL INSTITUTION        +INSTITUTION        Gray CtrlFld
EditBox  1     0   AID_YEAR_TBL    INSTITUTION        +INSTITUTION        Gray CtrlFld
EditBox  2     0   INSTITUTION_TBL DESCR              [None ]             Gray Related:1
EditBox  3     0   AID_YEAR_TBL    AID_YEAR           +AID_YEAR           Gray CtrlFld noPrompt
EditBox  4     0   AID_YEAR_TBL    DESCR              [None ]             Gray Related:3

Page: SFA_ASG_AL_TBL (ENG)
	Description	HERA Academic Level Set Up
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SFAT
	Comments	ACG/SMART Academic Level Setup used by Financial Aid Term to determi
		ne HERA Academic Level.

Type     ID    Lvl Record          Field              Label               Attributes
Label    1     0                                      [#14400,451]
SubPage  2     0                                      ''                  -> SFA_ASG_AL_SUBP
PSGrid   .3    1   SFA_ASG_AL_TBL                     [None ]             Lvl 1 #**
EditBox  .4    1   SFA_ASG_AL_TBL  ACAD_CAREER        -ACAD_CAREER
EditBox  .5    1   SFA_ASG_AL_TBL  ACAD_PROG          +PROGRAM
EditBox  .6    1   SFA_ASG_AL_TBL  ACAD_PLAN          +PLAN
EditBox  .7    1   SFA_ASG_AL_TBL  LEVEL_LOAD_RULE    +LEVEL_LOAD_RULE
SecPage  2     0                                      ''                  -> SFA_ASG_AL_COPY noDefrr Hide
PushBtn  3     0   DERIVED_FA_COPY COPY_DATA_PUSHBTN  -COPY_DATA_PUSHBTN  PushBtn->PCode
SubPage  4     0                                      ''                  -> SFA_ASG_AL_SUBP
PSGrid   .5    1   SFA_ASG_AL_TBL                     [None ]             Lvl 1 #**
EditBox  .6    1   SFA_ASG_AL_TBL  ACAD_CAREER        -ACAD_CAREER
EditBox  .7    1   SFA_ASG_AL_TBL  ACAD_PROG          +PROGRAM
EditBox  .8    1   SFA_ASG_AL_TBL  ACAD_PLAN          +PLAN
EditBox  .9    1   SFA_ASG_AL_TBL  LEVEL_LOAD_RULE    +LEVEL_LOAD_RULE
EditBox  .10   1   SFA_ASG_AL_TBL  INSTITUTION        -INSTITUTION        Hide
EditBox  .11   1   SFA_ASG_AL_TBL  AID_YEAR           -AID_YEAR           Hide noPrompt

Page: SFA_ASG_ELIG (ENG)
	Description	ACG/SMART Eligibility
	Type	Standard Page
	Allow Deferred Proc.	Yes
	Owner ID	SFA
	Comments	ACG/SMART page to review, update and enter student Eligibility infor
		mation.

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0   DERIVED_CS                         ''                  -> PERS_FERPA_SRVC
SubPage  2     0   DERIVED_CM                         ''                  -> THREE_C_BUTTONS
CheckBox 3     0   SFA_ASG_ELIG    SFA_ASG_PROC_FLAG  [None ]             On:Y Off:N Hide
EditBox  4     0   PERSONAL_DATA   FERPA              [None ]             Hide
EditBox  5     0   SFA_ASG_ELIG    EMPLID             -EMPLID             Gray CtrlFld
EditBox  6     0   PERSONAL_DATA   NAME               [None ]             Gray Related:5
EditBox  7     0   SFA_ASG_ELIG    INSTITUTION        -INSTITUTION        Gray
ComboBox 8     0   SFA_ASG_ELIG    SFA_ASG_GRANT_TYPE +SFA_ASG_GRANT_TYPE Gray XLatLong
EditBox  9     0   SFA_ASG_ELIG    AID_YEAR           +AID_YEAR           Gray
EditBox  10    0   SFA_ASG_ELIG    STRM               +STRM               Hide CtrlFld
EditBox  11    0   TERM_VAL_TBL    DESCR              [None ]             Gray Related:10
ScrArea  .12   1                                      [None ]             Lvl 1 #1
ComboBox .13   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_STAT  +SFA_ASG_ELIG_STAT  XLatLong
Label    .14   1                                      [#14426,543]
CheckBox .15   1   SFA_ASG_ELIGDTL SFA_ASG_ACLVL_OVRD [None ]             On:Y Off:N
ComboBox .16   1   SFA_ASG_ELIGDTL SFA_ASG_ACAD_LEVEL +SFA_ASG_HERA_LVL   XLatLong
EditBox  .17   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_SEQ   -SFA_ASG_ELIG_SEQ   Gray
ComboBox .18   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_SRC   -SFA_ASG_ELIG_SRC   Gray XLatShort
CheckBox .19   1   SFA_ASG_ELIGDTL SFA_ASG_DISB_PRTCT +SFA_ASG_DISB_PRTCT On:Y Off:N
EditBox  .20   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_DTTM  +SFA_ASG_ELIG_DTTM  Gray
ComboBox .21   1   SFA_ASG_ELIGDTL SFA_COD_ELIGRSN_CD +SFA_COD_ELIG       XLatShort
SecPage  .22   1                                      ''                  -> SFA_ASG_CIPSEL_SEC noDefrr Hide
EditBox  .23   1   SFA_ASG_ELIGDTL SFA_COD_HS_PROG_CD +SFA_ASG_HS_PROGRAM
GroupBox .24   1   SFA_ASG_ELIGRSN                    'Other Information'
PushBtn  .25   1   DERIVED_GRANTS  SFA_CR_DTL_PB      +SFA_ASG_CIPSEL_PB  HypLink->PCode
PushBtn  .26   1                                      [#14408,53]         HypLink->InternalLink
CheckBox .27   1   SFA_ASG_ELIGDTL SFA_ASG_CIPCD_OVRD [None ]             On:Y Off:N
EditBox  .28   1   SFA_ASG_ELIGDTL CIP_CODE           +CIP_CODE
PushBtn  .29   1   SFA_ASG_ELIGRSN                    [#14426,549]        HypLink->InternalLink
CheckBox .30   1   SFA_ASG_ELIGDTL SFA_ASG_GPA_OVRD   [None ]             On:Y Off:N
PushBtn  .31   1   SFA_ASG_ELIGRSN                    [#14426,553]        HypLink->InternalLink
EditBox  .32   1   SFA_ASG_ELIGDTL SFA_ASG_GPA        +SFA_ASG_GPA
PushBtn  .33   1   SFA_ASG_ELIGRSN                    [#14426,548]        HypLink->InternalLink
PushBtn  .34   1   SFA_ASG_ELIGRSN                    [#14426,550]        HypLink->InternalLink
PushBtn  .35   1   SFA_ASG_ELIGRSN                    [#14426,552]        HypLink->InternalLink
PushBtn  .36   1   SFA_ASG_ELIGRSN                    [#14426,551]        HypLink->InternalLink
PSGrid   ..37  2   SFA_ASG_ELIGRSN                    [None ]             Lvl 2 #** Gray
TabSepar ..38  2                                      [#14426,1004]
EditBox  ..39  2   SFA_ASG_ELIGRSN DTTM_STAMP_SEC     -DTTM_STAMP_SEC     Gray Century
EditBox  ..40  2   SFA_ASG_ELIGRSN MESSAGE_SET_NBR    +MESSAGE_SET_NBR    Hide
EditBox  ..41  2   SFA_ASG_ELIGRSN MESSAGE_NBR        +MESSAGE_NBR        Hide CtrlFld
EditBox  ..42  2   MESSAGE_CATALOG MESSAGE_TEXT       +MESSAGE_TEXT       Gray Related:41
TabSepar ..43  2                                      [#14426,1005]
EditBox  ..44  2   SFA_ASG_ELIGRSN EQUATION_NAME      +EQUATION_NAME      Gray
EditBox  ..45  2   SFA_ASG_ELIGRSN MESSAGE_SET_NBR    +MESSAGE_SET_NBR    Gray
EditBox  ..46  2   SFA_ASG_ELIGRSN MESSAGE_NBR        +MESSAGE_NBR        Gray
PushBtn  12    0   DERIVED_GRANTS  SFA_ASG_FAT_AL_PB  -SFA_ASG_FAT_AL_PB  HypLink->PCode SFA_ASG_ELIGAL_SEC
SecPage  13    0                                      ''                  -> SFA_ASG_ELIGAL_SEC noDefrr Hide
ScrArea  .14   1                                      [None ]             Lvl 1 #1
ComboBox .15   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_STAT  +SFA_ASG_ELIG_STAT  XLatLong
Label    .16   1                                      [#14426,543]
CheckBox .17   1   SFA_ASG_ELIGDTL SFA_ASG_ACLVL_OVRD [None ]             On:Y Off:N
ComboBox .18   1   SFA_ASG_ELIGDTL SFA_ASG_ACAD_LEVEL +SFA_ASG_HERA_LVL   XLatLong
EditBox  .19   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_SEQ   -SFA_ASG_ELIG_SEQ   Gray
ComboBox .20   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_SRC   -SFA_ASG_ELIG_SRC   Gray XLatShort
CheckBox .21   1   SFA_ASG_ELIGDTL SFA_ASG_DISB_PRTCT +SFA_ASG_DISB_PRTCT On:Y Off:N
EditBox  .22   1   SFA_ASG_ELIGDTL SFA_ASG_ELIG_DTTM  +SFA_ASG_ELIG_DTTM  Gray
ComboBox .23   1   SFA_ASG_ELIGDTL SFA_COD_ELIGRSN_CD +SFA_COD_ELIG       XLatShort
SecPage  .24   1                                      ''                  -> SFA_ASG_CIPSEL_SEC noDefrr Hide
EditBox  .25   1   SFA_ASG_ELIGDTL SFA_COD_HS_PROG_CD +SFA_ASG_HS_PROGRAM
GroupBox .26   1   SFA_ASG_ELIGRSN                    'Other Information'
PushBtn  .27   1   DERIVED_GRANTS  SFA_CR_DTL_PB      +SFA_ASG_CIPSEL_PB  HypLink->PCode
PushBtn  .28   1                                      [#14408,53]         HypLink->InternalLink
CheckBox .29   1   SFA_ASG_ELIGDTL SFA_ASG_CIPCD_OVRD [None ]             On:Y Off:N
EditBox  .30   1   SFA_ASG_ELIGDTL CIP_CODE           +CIP_CODE
PushBtn  .31   1   SFA_ASG_ELIGRSN                    [#14426,549]        HypLink->InternalLink
CheckBox .32   1   SFA_ASG_ELIGDTL SFA_ASG_GPA_OVRD   [None ]             On:Y Off:N
PushBtn  .33   1   SFA_ASG_ELIGRSN                    [#14426,553]        HypLink->InternalLink
PushBtn  .34   1   SFA_ASG_ELIGRSN                    [#14426,555]        HypLink->InternalLink
EditBox  .35   1   SFA_ASG_ELIGDTL SFA_ASG_GPA        +SFA_ASG_GPA
PushBtn  .36   1   SFA_ASG_ELIGRSN                    [#14426,548]        HypLink->InternalLink
PushBtn  .37   1   SFA_ASG_ELIGRSN                    [#14426,550]        HypLink->InternalLink
PushBtn  .38   1   SFA_ASG_ELIGRSN                    [#14426,552]        HypLink->InternalLink
PushBtn  .39   1   SFA_ASG_ELIGRSN                    [#14426,551]        HypLink->InternalLink
PSGrid   ..40  2   SFA_ASG_ELIGRSN                    [None ]             Lvl 2 #** Gray
TabSepar ..41  2                                      [#14426,1004]
EditBox  ..42  2   SFA_ASG_ELIGRSN DTTM_STAMP_SEC     -DTTM_STAMP_SEC     Gray Century
EditBox  ..43  2   SFA_ASG_ELIGRSN MESSAGE_SET_NBR    +MESSAGE_SET_NBR    Hide
EditBox  ..44  2   SFA_ASG_ELIGRSN MESSAGE_NBR        +MESSAGE_NBR        Hide CtrlFld
EditBox  ..45  2   MESSAGE_CATALOG MESSAGE_TEXT       +MESSAGE_TEXT       Gray Related:44
TabSepar ..46  2                                      [#14426,1005]
EditBox  ..47  2   SFA_ASG_ELIGRSN EQUATION_NAME      +EQUATION_NAME      Gray
EditBox  ..48  2   SFA_ASG_ELIGRSN MESSAGE_SET_NBR    +MESSAGE_SET_NBR    Gray
EditBox  ..49  2   SFA_ASG_ELIGRSN MESSAGE_NBR        +MESSAGE_NBR        Gray

Page: SFA_ASG_ELIGAL_SEC (ENG)
	Description	HERA Academic Level	
	Type	Secondary Page	
	Allow Deferred Proc.	No	
	Owner ID	SFAT	
	Comments	
		Secondary Page used in FA Term to view a students ASG Academic Level
		Info.

Type     ID    Lvl Record          Field              Label               Attributes
EditBox  1     0   SFA_ASG_ELIG    EMPLID             -EMPLID             Gray CtrlFld
EditBox  2     0   PERSONAL_DATA   NAME               [None ]             Gray Related:1
EditBox  3     0   SFA_ASG_ELIG    INSTITUTION        -INSTITUTION        Gray
ComboBox 4     0   SFA_ASG_ELIG    SFA_ASG_GRANT_TYPE +SFA_ASG_GRANT_TYPE Gray XLatLong
CheckBox 5     0   SFA_ASG_ELIG    SFA_ASG_PROC_FLAG  [None ]             On:Y Off:N Hide
EditBox  6     0   SFA_ASG_ELIG    AID_YEAR           +AID_YEAR           Gray
EditBox  7     0   SFA_ASG_ELIG    STRM               +STRM               Hide CtrlFld
EditBox  8     0   TERM_VAL_TBL    DESCR              [None ]             Gray Related:7
GroupBox 9     0   SFA_ASG_ELG_DER SFA_ASG_AC_LVL_BOT +ACADEMICLEVEL
EditBox  10    0   SA_LBL_WRK      OVERRIDE           +OVERRIDE           Hide CtrlFld noPrompt
EditBox  11    0   SA_LBL_WRK      CALC_VALS          +CALC_VALS          Hide CtrlFld noPrompt
EditBox  12    0   SFA_ASG_ELG_DER SFA_ASG_WI_USED    +NEWMETHODUSED      Hide
CheckBox 13    0   SFA_ASG_ELG_DER OVRD_ASG_BOT       [None ]             On:Y Off:N Gray
ComboBox 14    0   SFA_ASG_ELG_DER SFA_ASG_AC_LVL_BOT +BOT                Gray XLatShort
ComboBox 15    0   SFA_ASG_ELG_DER SFA_ASG_AC_LVL_BCL [None ]             Gray XLatShort
CheckBox 16    0   SFA_ASG_ELG_DER OVRD_ASG_EOT       [None ]             On:Y Off:N Gray
ComboBox 17    0   SFA_ASG_ELG_DER SFA_ASG_AC_LVL_EOT +EOT                Gray XLatShort
ComboBox 18    0   SFA_ASG_ELG_DER SFA_ASG_AC_LVL_ECL [None ]             Gray XLatShort
GroupBox 19    0   SFA_ASG_ELG_DER SFA_ASG_WI_TRM     +HERAWEEKS
EditBox  20    0   SA_LBL_WRK      OVERRIDE           +OVERRIDE           Hide CtrlFld noPrompt
EditBox  21    0   SA_LBL_WRK      CALC_VALS          +CALC_VALS          Hide CtrlFld noPrompt
CheckBox 22    0   SFA_ASG_ELG_DER SFA_ASG_WI_MTH_OVR [None ]             On:Y Off:N Gray
ComboBox 23    0   SFA_ASG_ELG_DER SFA_ASG_WI_MTH     -SFA_ASG_WI_MTH     Gray XLatShort
ComboBox 24    0   SFA_ASG_ELG_DER SFA_ASG_WI_MTH_CL  [None ]             Gray XLatShort
CheckBox 25    0   SFA_ASG_ELG_DER SFA_ASG_WI_TRM_OVR [None ]             On:Y Off:N Gray
EditBox  26    0   SFA_ASG_ELG_DER SFA_ASG_WI_TRM     -WEEKSOFINST        Gray noPrompt
EditBox  27    0   SFA_ASG_ELG_DER SFA_ASG_WI_TRM_CL  [None ]             Gray
CheckBox 28    0   SFA_ASG_ELG_DER SFA_ASG_WI_TCR_OVR [None ]             On:Y Off:N Gray
EditBox  29    0   SFA_ASG_ELG_DER SFA_ASG_WI_TCR     +SFA_ASG_WI_TCR     Gray noPrompt
EditBox  30    0   SFA_ASG_ELG_DER SFA_ASG_WI_TCR_CL  [None ]             Gray
EditBox  31    0   SFA_ASG_ELG_DER SFA_ASG_WI_CUM_BOT +SFA_ASG_WI_CUM     Hide
EditBox  32    0   SFA_ASG_ELG_DER SFA_ASG_WI_CUM_BOT +SFA_ASG_WI_CUM_BOT Gray
EditBox  33    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
EditBox  34    0   SFA_ASG_ELG_DER SFA_ASG_WI_CUM_EOT -SFA_ASG_WI_EOT     Gray
EditBox  35    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
GroupBox 36    0   SFA_ASG_ELG_DER SFA_ASG_UNITS_BOT  +HERA_UNITS
EditBox  37    0   SFA_ASG_ELG_DER SFA_ASG_UNITS_BOT  +SFA_ASG_UNITS_BOT  Gray noPrompt
EditBox  38    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
EditBox  39    0   SFA_ASG_ELG_DER SFA_ASG_UNITS_EOT  +SFA_ASG_UNITS_EOT  Gray noPrompt
EditBox  40    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide

Page: SFA_ASG_WI_TBL (ENG)
	Description	HERA Academic Level Set Up	
	Type	Standard Page	
	Allow Deferred Proc.	Yes	
	Owner ID	SFAT	
	Comments	
		ACG/SMART Academic Level Setup used by Financial Aid Term to determi
		ne HERA Academic Level.

Type     ID    Lvl Record          Field              Label               Attributes
Label    1     0                                      [#14400,454]
EditBox  2     0   SFA_ASG_WI_TBL  INSTITUTION        +INSTITUTION        Gray CtrlFld
EditBox  3     0   INSTITUTION_TBL DESCR              [None ]             Gray Related:2
GroupBox 4     0   SFA_ASG_WI_TBL  SFA_ASG_WI_MTH     -DEFLTMETHOD
ComboBox 5     0   SFA_ASG_WI_TBL  SFA_ASG_WI_MTH     +SFA_ASG_WI_MTH     XLatLong
ComboBox 6     0   SFA_ASG_WI_TBL  SFA_ASG_CALDR_TYPE +ACADCALTYPE        XLatLong
EditBox  7     0   SFA_ASG_WI_TBL  SFA_ASG_HRS_CRDTS  +HOURS_CREDITS
EditBox  8     0   SFA_ASG_WI_TBL  SFA_ASG_WKS_ACADYR +WEEKS_PROG_ACADYR
EditBox  9     0   SFA_ASG_WI_TBL  SFA_ASG_WI_STRM    +BEGINWITERM        CtrlFld
EditBox  10    0   TERM_VAL_TBL    DESCR              [None ]             Gray Related:9
PSGrid   .11   1   SFA_ASG_WI_CAR                     [#14400,455]        Lvl 1 #**
EditBox  .12   1   SFA_ASG_WI_CAR  ACAD_CAREER        -ACAD_CAREER
EditBox  .13   1   SFA_ASG_WI_CAR  ACAD_PROG          -PROGRAM
EditBox  .14   1   SFA_ASG_WI_CAR  ACAD_PLAN          -PLAN
ComboBox .15   1   SFA_ASG_WI_CAR  SFA_ASG_WI_MTH     +SFA_ASG_WI_MTH     XLatLong
ComboBox .16   1   SFA_ASG_WI_CAR  SFA_ASG_CALDR_TYPE +ACADCALTYPE        XLatLong
EditBox  .17   1   SFA_ASG_WI_CAR  SFA_ASG_HRS_CRDTS  +HOURS_CREDITS
EditBox  .18   1   SFA_ASG_WI_CAR  SFA_ASG_WKS_ACADYR +WEEKS_PROG_ACADYR

Page: SFA_RUNCTL_FISAP10 (ENG)
	Description	FISAP 2009	
	Type	Standard Page	
	Allow Deferred Proc.	Yes	
	Owner ID	SFAG	

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0                                      ''                  -> PRCSRUNCNTL_SBP
HorRule  2     0                                      [None ]
Label    3     0                                      [#14404,434]
ComboBox 4     0   RUNCNTL_FA_FISP INSTITUTION        -INSTITUTION        Prompt: DESCR
ComboBox 5     0   RUNCNTL_FA_FISP AID_YEAR           +AID_YEAR           Prompt: DESCR
GroupBox 6     0   DERIVED_FA_LBL  OVRD_LBL           +OVRD_LBL
CheckBox 7     0   RUNCNTL_FA_FISP SSA_CITIZEN_OVRD   +SSACITIZENSHIPOVRD On:Y Off:N
CheckBox 8     0   RUNCNTL_FA_FISP INS_MATCH_OVRD     +DHS_INS_MATCH_OVRD On:Y Off:N

Page: STDNT_FA_ASGAL_SEC (ENG)
	Description	HERA Academic Level
	Type	Secondary Page
	Allow Deferred Proc.	No
	Owner ID	SFAT
	Comments	Secondary Page used in FA Term to view a students ASG Academic Level
		Info.

Type     ID    Lvl Record          Field              Label               Attributes
SubPage  1     0                                      ''                  -> STDNT_FA_TERM_SBP3
EditBox  2     0   SA_LBL_WRK      OVERRIDE           +OVERRIDE           Hide CtrlFld noPrompt
EditBox  3     0   SA_LBL_WRK      CALC_VALS          +CALC_VALS          Hide CtrlFld noPrompt
ComboBox 4     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_BCL [None ]             Gray XLatShort
ComboBox 5     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_BOT +BOT                XLatShort
GroupBox 2     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_BOT +ACADEMICLEVEL
EditBox  3     0   SA_LBL_WRK      OVERRIDE           +OVERRIDE           Hide CtrlFld noPrompt
EditBox  4     0   SA_LBL_WRK      CALC_VALS          +CALC_VALS          Hide CtrlFld noPrompt
EditBox  5     0   STDNT_FA_TERM   SFA_ASG_WI_USED    +NEWMETHODUSED      Hide
CheckBox 6     0   STDNT_FA_TERM   OVRD_ASG_BOT       [None ]             On:Y Off:N
CheckBox 7     0   STDNT_FA_TERM   OVRD_ASG_EOT       [None ]             On:Y Off:N
ComboBox 8     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_EOT +EOT                XLatShort
ComboBox 9     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_ECL [None ]             Gray XLatShort
ComboBox 7     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_BOT +BOT                XLatShort
ComboBox 8     0   STDNT_FA_TERM   SFA_ASG_AC_LVL_BCL [None ]             Gray XLatShort
CheckBox 9     0   STDNT_FA_TERM   OVRD_ASG_EOT       [None ]             On:Y Off:N
ComboBox 10    0   STDNT_FA_TERM   SFA_ASG_AC_LVL_EOT +EOT                XLatShort
ComboBox 11    0   STDNT_FA_TERM   SFA_ASG_AC_LVL_ECL [None ]             Gray XLatShort
GroupBox 12    0   STDNT_FA_TERM   SFA_ASG_WI_TRM     +HERAWEEKS
EditBox  13    0   SA_LBL_WRK      OVERRIDE           +OVERRIDE           Hide CtrlFld noPrompt
EditBox  14    0   SA_LBL_WRK      CALC_VALS          +CALC_VALS          Hide CtrlFld noPrompt
CheckBox 15    0   STDNT_FA_TERM   SFA_ASG_WI_MTH_OVR [None ]             On:Y Off:N
ComboBox 16    0   STDNT_FA_TERM   SFA_ASG_WI_MTH     -SFA_ASG_WI_MTH     XLatShort
ComboBox 17    0   STDNT_FA_TERM   SFA_ASG_WI_MTH_CL  [None ]             Gray XLatShort
CheckBox 18    0   STDNT_FA_TERM   SFA_ASG_WI_TRM_OVR [None ]             On:Y Off:N
EditBox  19    0   STDNT_FA_TERM   SFA_ASG_WI_TRM     -WEEKSOFINST        Zero noPrompt
EditBox  20    0   STDNT_FA_TERM   SFA_ASG_WI_TRM_CL  [None ]             Gray Zero
CheckBox 21    0   STDNT_FA_TERM   SFA_ASG_WI_TCR_OVR [None ]             On:Y Off:N
EditBox  22    0   STDNT_FA_TERM   SFA_ASG_WI_TCR     +SFA_ASG_WI_TCR     Zero noPrompt
EditBox  23    0   STDNT_FA_TERM   SFA_ASG_WI_TCR_CL  [None ]             Gray Zero
EditBox  24    0   STDNT_FA_TERM   SFA_ASG_WI_CUM_BOT +SFA_ASG_WI_CUM     Hide
EditBox  25    0   STDNT_FA_TERM   SFA_ASG_WI_CUM_BOT +SFA_ASG_WI_CUM_BOT Gray Zero
EditBox  26    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
EditBox  27    0   STDNT_FA_TERM   SFA_ASG_WI_CUM_EOT -SFA_ASG_WI_EOT     Gray Zero
EditBox  28    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
GroupBox 29    0   STDNT_FA_TERM   SFA_ASG_UNITS_BOT  +HERA_UNITS
EditBox  30    0   STDNT_FA_TERM   SFA_ASG_UNITS_BOT  +SFA_ASG_UNITS_BOT  Gray Zero noPrompt
EditBox  31    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide
EditBox  32    0   STDNT_FA_TERM   SFA_ASG_UNITS_EOT  +SFA_ASG_UNITS_EOT  Gray Zero noPrompt
EditBox  33    0   DERIVED_FA_LBLP NOT_APPLICABLE_LBL -NOT_APPLICABLE_LBL Hide

Menu Detail

Menu: DESIGN_FINANCIAL_AID1
	Menu Type	Standard
	Description	 
	Menu Label	Design &Financial Aid1
	Menu Group	Design &Student Administration
	Installed	Yes
	Menu Order	80
	  add Separator	No
	Group Order	7
	  add Separator	Yes

Bar/Menu Item              Description                    Component          Market OverrideSearchRec
SETUP_A-B                  Setup A-&B
SFA_ASG_HS_PROGRAM           ACG State Program Codes  SFA_ASG_HS_PROGRAM GBL
SFA_ASG_PARMS                ACG/SMART Processing Opt SFA_ASG_PARMS      GBL
SFA_ASG_SETUP                ACG/SMART Reporting Opti SFA_ASG_SETUP      GBL
AGGREGATE_AID_LIMITS         &Aggregate Aid Limits    AGGR_AID_TBL       GBL
AGGR_LVL_XREF                Aggregate &Levels Xref   AGGR_LVL_XREF      GBL
AGGR_PROG_TABLE              Aggregate &Programs      AGGR_PROG_TABLE    GBL
ADMIT_LEVEL_ASSOCIATIONS     A&dmit Level Association ADMIT_LVL_TBL      GBL
FA_DFLT_RULE_SET             Aid Processing &Rule Set FA_DFLT_RULE_SET   GBL
AID_YEAR_TABLE               Aid &Year Table          AID_YEAR_TABLE     GBL
FA_APP_SOURCE_RANK           Application &Source Rank FA_APP_SOURCE_RANK GBL
AWARD_ADJUST_REASONS         Award Ad&justment Reason AWRD_ADJ_RSN_TBL   GBL
AWARD_MESSAGES               Award &Messages          AWARD_MESSAGES     GBL
BUDGET_CATEGORY_TABLE        Budget &Categories       BUDGET_CATG_TBL    GBL
BUDGET_ITEM_TABLE            Budget I&tems            BUDGET_ITEM_TABLE  GBL
BUDGET_FORMULA               Budget &Formulas         BUDGET_FORMULA     GBL
BUDGET_TREE                  Budget T&rees            BUDGET_TREE_TBL    GBL
BUDGET_GROUP_TABLE           Budget &Groups           BUDGET_GROUP_TABLE GBL
BUDGET_ASSIGNMENT            &Budget Assignment       BUDGET_ASSIGNMENT  GBL
BUDGET_ASGN_RUNCTL           B&udget Assignment Run C BUDGET_ASGN_RUNCTL GBL
BUDGET_TREE_ADDR_USG         Budget Tree Address Usa& ISIR_ADDRESS       GBL

SETUP_C-E                  Setup &C-E
CAREERS_FOR_SCHOOL_CDS       Careers for Sc&hool Code SCHOOL_CAREER1     GBL
CAREER_TYPE                  Career &Type             CAREER_TYPE        GBL
CNAS_MESSAGES                &CNAS Messages           CNAS_MESSAGES      GBL
CNAS_OPTION_TBL              CNAS &Option Table       CNAS_OPTION_TBL    GBL
CNAS_RULE_SETUP              CNAS &Rule Setup         CNAS_SETUP_TBL     GBL
CNAS_SETUP                   C&NAS Setup              CSL_SETUP_TABLES   GBL
SFA_COD_EDIT_CODE            COD Edit Codes           SFA_COD_EDIT_CODE  GBL
SFA_COD_LOOKUP               COD System Table for ACG SFA_COD_LOOKUP     GBL
COD_LOOKUP                   COD System Table         COD_LOOKUP         GBL
PROCESS_COMMIT               Commit Le&vels           PROCESS_COMMIT_TBL GBL
COMMITTEES                   Co&mmittees              COMMITTEE_MAINT    GBL
COMMITTEE_TYPES_ROLES        Committee T&ypes/Roles   COMMITTEE_TABLE    GBL
COST_CODE                    Cost Co&de               CAN_COST_CODE      GBL
DL_CHANGE_DEFN_WK            Direct &Lending Change F DL_CHG_XREF_WK     GBL
AUTH_CALENDAR                Disb/Authori&zation Cale AUTH_CALENDER      GBL
DISBURSEMENT_ID_TABLE        Disbursement &ID Table   DISBURSE_ID_TBL    GBL
DISBURSEMENT_PLAN_TABLE      Disbursement &Plan Table DISBURSE_PLAN_TBL  GBL
DISB_PRORATION               Disbursement Proration R DISB_PRORATION     GBL
DISB_RULE_GLB                Disbursement Rules: &Glo DISB_RULE_GLB      GBL
DISB_RULE_ITEM               Dis&bursement Rules: Ite DISB_RULE_ITEM     GBL
DISBURSEMENT_SPLIT_CODES     Disburs&ement Split Code DISB_SPLIT_CD      GBL
SPLIT_CODES_FOR_DISBURSE_IDS Disbursement Split Cd Fo DISB_ID_SPLIT      GBL
EARLY_FIN_AID_CATEGORIES     Early Fin Aid Categorie& ERLY_FA_CTG_TBL    GBL
MENUITEM3                    EDI &Entity Codes        EC_ENTITY_CODE_TBL GBL
MENUITEM5                    EDI E&xternal Partners   EC_EXT_PARTNER_DEF GBL
MENUITEM6                    EDI &Internal Partners   EC_INT_PARTNER_DEF GBL
EC_TP_PROFILE                EDI Partner Pro&file     EC_TP_PROFILE      GBL
SFA_ASG_CIP_CODE             Eligible CIP Codes for S SFA_ASG_CIP_CODE   GBL
EQUATION_ENGINE              E&quation Engine         EQUATION_ENGINE    GBL
EQTN_DATA_TBL                Equation &Data Tables    EQTN_DATA_TBL      GBL
EQTN_EXTERN_TBL              Equation E&xternal Subro EQTN_EXTERN_TBL    GBL
SFA_EQ_GROUP_SETUP           Equation Group Setup     SFA_EQ_GROUP_SETUP GBL
EQTN_SQL_TBL                 Equation &SQL Routines   EQTN_SQL_TBL       GBL
EQTN_TEST_DATA               Equation &Test Data      EQTN_TEST_DATA     GBL

SETUP_F-K                  Setup &F-K
FA_EDI_DEST                  FA &EDI Destination      FA_EDI_DEST        GBL
FA_ECTRANS                   FA EDI T&ransactions     FA_ECTRANS         GBL
FA_TERM_SETUP                &FA Term Setup           FA_TERM_SETUP      GBL
FEDERAL_AID_YEAR_TABLE       Federal &Aid Year Table  FED_AID_YR_TBL     GBL
FANLTR_DEFAULTS              FE A&ward Notif. Default FANLTR_DEFAULTS    GBL
FANLTR_FORM_TYPE             FE Award Notif. &Form Ty FANLTR_FORM_TYPE   GBL
FILE_LOAD_CONTROL            File &Load Control       CSL_CONTROL        GBL
FINANCIAL_AID_ITEM_TYPES     Financial Aid Item T&ype FINANCIAL_AID_ITEM GBL
FISCAL_ITEM_TYPES            Fis&cal Item Types       ITEM_TYP_FISCAL    GBL
GUAR_LOAD_MAINT              &Guarantor Load Maint    GUAR_LOAD_MAINT    GBL
SFA_ASG_AL_TBL               HERA Academic Level Set  SFA_ASG_AL_TBL     GBL
SFA_ASG_WI_TBL               HERA Weeks of Instructio SFA_ASG_WI_TBL     GBL
INAS_ASMPTN_CODES            &INAS Assumption Codes   INAS_ASMPTN_CODES  GBL
LOCAL_POLICY_PT_07           INAS Local P&olicy Opts  LOCAL_POLICY_PT_07 GBL
LOCAL_POLICY_PT_08           INAS Local P&olicy Opts  LOCAL_POLICY_PT_08 GBL
LOCAL_POLICY_PT_09           INAS Local P&olicy Opts  LOCAL_POLICY_PT_09 GBL
INSTALLATION_FA              Installation &Defaults-F INSTALLATION_FA    GBL
INST_CROSS_REFERENCE         I&nstitutional Cross Ref INST_XREF          GBL
FA_INST_DEFN                 Inst Mass Pac&kaging Def FA_INST_DEFN       GBL
ISIR_DATA_LOAD_PARMS         ISIR Da&ta Load Parms    ISIR_INST_CONTROL  GBL
ISIR_MESSAGE_TABLES          ISIR Message Ta&bles     ISIR_MESSAGES      GBL
ISIR_SAR_CROSS_REFERENCE     ISIR/&SAR Cross Referenc ISIR_SAR_XREF      GBL
ITEM_TYPES                   Ite&m Types              ITEM_TYPE_PANEL    GBL
KEYWORDS                     Key&words                KEYWORDS           GBL

PROCESS                    &Process
AID_YEAR_SETUP               Aid Year Setup           AID_YEAR_SETUP     GBL
---------------
ASSIGN_PKG_RTNG_COMPENENTS   Assign &Packaging Rtng C RUNCNTL_FA_PKG_RC  GBL
---------------
RUNCTL_AUTHORIZE             Authori&ze Disbursements RUNCTL_AUTHRIZE    GBL
RUN_CNTL_DISB                &Disbursements           RUNCTL_DISBURSE    GBL
---------------
AWARD_NOTIFICATION_MC        Award &Notification (MC) FA_MASS_CHANGE     GBL
FA_AWARD_LETTER              &Award Notification Lett RUNCTL_FAN_SEL     GBL
FA_AWARD_LETTER_PRINT        &Print Award Letter      RUNCTL_FAN_PRINT   GBL
---------------
CHECKLIST_ASSIGNMENT         Checklist &Assignment    CHKLST_ASSIGNMENT  GBL
---------------
RUNCTL_FAPTRMU1SQR           &1. Create FA Term Drive RUNCTL_FATERMLOAD1 GBL
BUILD_FATERM                 &2. Build FA Terms       RUNCTL_FATERMLOAD2 GBL
---------------                                                          GBL
MASS_CHANGE                  Run &Mass Change         RUN_MASSCHNG       GBL
STDNT_AID_ATTR_REVIEW        Stdnt Aid Attr &Review ( STDNT_AID_ATTR_REV GBL
UPD_STDNT_AID_ATTR           Update Stdnt &Aid Attrib UPD_STDNT_AID_ATTR GBL
UPD_STDNT_FA_TERM            Update Stdnt &FA Term    UPD_STDNT_FA_TERM  GBL

REPORT                     &Report
FA724                        FA724 Admit Level Associ RUNCTL_FA724       GBL
FA715                        FA715 Aggregate Aid Limi RUNCTL_FA715       GBL
FA716_AGGR_LEVEL_XREF        FA716 Aggregate Level X- RUNCTL_FA716       GBL
FA723                        FA723 Aggregate Programs RUNCTL_FA723       GBL
FA725                        FA725 Aid Year Table     RUNCTL_FA725       GBL
FA726                        FA726 Application Source RUNCTL_FA726       GBL
FA727                        FA727 Award Adjustment R RUNCTL_FA727       GBL
FA728                        FA728 Award Messages     RUNCTL_FA728       GBL
FA729                        FA729 Budget Assignment- RUNCTL_FA729       GBL
FIN_AID_CAREERS_TERMS        FA701 &Careers and Terms RUNCTL_FA_RPT_701  GBL
FIN_AID_BUDGET_CATEGORIES    FA702 Budget &Categories RUNCTL_FA_RPT_702  GBL
FIN_AID_BUDGET_ITEMS         FA704 Budget &Items      RUNCTL_FA_RPT_704  GBL
FIN_AID_DISBURSE_PLAN        FA706 &Disbursement Plan RUNCTL_FA_RPT_706  GBL
FIN_AID_DISB_SPLIT_CODES     FA708 Disbursement &Spli RUNCTL_FA_RPT_708  GBL
FA714                        FA714 Fin Aid Item Types RUNCTL_FA714       GBL
EQTN_PRT_RUN_CNTL            FA753 Equation Print     EQTN_PRT_RUN_CNTL  GBL
FIN_AID_FISCAL_ITEM_TYPES    FA802 &Fiscal Item Types RUNCTL_FA_RPT_802  GBL
FIN_AID_PKG_PLAN             FA710 Packaging Plan &Ru RUNCTL_FA_RPT_710  GBL
FIN_AID_PKG_EQUATIONS        FA712 Packaging &Equatio RUNCTL_FA_RPT_712  GBL
FA_RELATED_ITEMS             FA711 &Related Item Grou RUNCTL_FA_RPT_711  GBL
RUN_CNTL_FA740               FA740 Careers For Aid Ye RUNCTL_FA740       GBL
FA744                        FA744 FA Installation De RUNCTL_FA744       GBL

INQUIRE                    &Inquire
FISCAL_AGGREGATE_AREA        Fiscal  Aggregate &Summa AGGR_AREA_FISCAL   GBL
DISB_AUTH_CAL_SUMRY          &Disb/Auth Calendar Summ DISB/AUTH_CAL_SMRY GBL
EQTN_RUN_RESULTS             Equation Run Results     EQTN_RUN_RESULTS   GBL
EQUATION_VIEW                Equation &View           EQUATION_VIEW      GBL

Menu: PACKAGE_AID
	Menu Type	Standard
	Description	 
	Menu Label	&Package and Disburse Aid
	Menu Group	Administer &Financial Aid
	Installed	Yes
	Menu Order	4
	  add Separator	No
	Group Order	4
	  add Separator	No

Bar/Menu Item              Description                    Component          Market OverrideSearchRec
USE                        &Use
AWARD_ENTRY_MC               Award Entry              AWARD_ENTRY_MC     GBL
AWARD_MANUAL_MC              Award &Entry/Manual      AWARD_MANUAL_MC    GBL
AWARD_OVERRIDE_MC            Award O&verride          AWARD_OVERRIDE_MC  GBL
AWARD_SUMMARY_MASS_ACTION    Award Summary/&Mass Acti AWARD_SUMMARY      GBL
AWARD_NOTIFICATION_MC        Award Noti&f. Selection  FA_MASS_CHANGE     GBL
---------------
PROG_CASH                    &Cash Summary            PROG_CASH          GBL
DISBURSE_AID                 &Disburse Aid            DISBURSE_AID       GBL
DISBURSE_AID_WO              Disburse Aid &W/Override DISBURSE_AID_WO    GBL
EARLY_FIN_AID_OFFER          &Early Financial Aid Off ERLY_FA_OFFER      GBL
STDNT_AWD_PER_RSRC           Education &Resources     STDNT_AWD_PER_RSRC GBL
ANTICIPTD_AID_EDIT           E&xpire Anticipated Aid  ANTICIPTD_AID_EDIT GBL
AWARD_NOTIF_DETAIL           FE Award N&otification   AWARD_NOTIF_DETAIL GBL
FINANCIAL_AID_TERM           Financial Aid &Term      STDNT_FA_TERM      GBL
AGGREGATE_INPUT              &Incoming Aggregates     AGGREGATE_INPUT    GBL
---------------
FA_INST_STDLIST              Inst Mass Pkg by &Studen FA_INST_STDLIST    GBL
FA_INST_PLANQRY              Inst Mass Pkg Plans by & FA_INST_PLANQRY    GBL
FA_INST_STDPLAN              Inst Mass Pkg Stdnts by  FA_INST_STDPLAN    GBL
MASS_PKG_STDLIST             Mass Packaging by &Stude FA_BPKG_STDLIST    GBL
FA_BPKG_PLANQRY              Mass Packaging Plans by  FA_BPKG_PLANQRY    GBL
FA_BPKG_STDPLAN              Mass Packaging Stdnts by FA_BPKG_STDPLAN    GBL
---------------
PACKAGING_STATUS_SUMMARY     &Packaging Status Summar STDNT_AID_PACKAGE  GBL
STDNT_PKG_VARS               Packaging &Variables     STDNT_PKG_VARS     GBL
SAA_REVIEW_MC                &Review Stdnt Aid Attr M SAA_REVIEW_MC      GBL
REVIEW_USER_EDITS            Review &User Edit Messag REVIEW_USER_EDITS  GBL
SERVICE_INDICATOR_DATA       Service I&ndicator Data  SERVICE_IND_PERS   GBL
WORK_STUDY_PLACEMENT         Work Study &Placement    STDNT_WRKSTUDY_AWD GBL
RETURN_TIV_FUNDS_HERA        Return of TI&V Worksheet SFA_STDNT_RTN_TIV  GBL
SFA_TIV_RTN_TRACK            Return of TIV Funds Trac SFA_TIV_RTN_TRACK  GBL
SFA_TIV_PWD_TRACK            PW Disbursement Tracking SFA_TIV_PWD_TRACK  GBL
SFA_TIV_STU_TRACK            Rtn TIV Funds Stu Sum HE SFA_TIV_STU_TRACK  GBL

SETUP                      &Setup
FA_DFLT_RULE_SET             Aid Processing &Rule Set FA_DFLT_RULE_SET   GBL
AWARD_ADJUST_REASONS         Award Ad&justment Reason AWRD_ADJ_RSN_TBL   GBL
AWARD_MESSAGES               &Award Messages          AWARD_MESSAGES     GBL
AUTH_CALENDAR                &Disb/Authorization Cale AUTH_CALENDER      GBL
DISB_PRORATION               Disbursement &Proration  DISB_PRORATION     GBL
DISB_RULE_GLB                Disbursement Rules: G&lo DISB_RULE_GLB      GBL
DISB_RULE_ITEM               Dis&bursement Rules: Ite DISB_RULE_ITEM     GBL
EARLY_FIN_AID_CATEGORIES     Early Fin Aid Cate&gorie ERLY_FA_CTG_TBL    GBL
FANLTR_DEFAULTS              FE Award &Notif. Default FANLTR_DEFAULTS    GBL
FANLTR_EQTN_SEL              FE Award Notif. &Select. FANLTR_EQTN_SEL    GBL
FINANCIAL_AID_ITEM_TYPES     Financial Aid Item T&ype FINANCIAL_AID_ITEM GBL
FISCAL_ITEM_TYPES            &Fiscal Item Types       ITEM_TYP_FISCAL    GBL
FA_INST_DEFN                 &Inst Mass Packaging Def FA_INST_DEFN       GBL
ITEM_TYPES                   &Item Types              ITEM_TYPE_PANEL    GBL
MASS_PKG_DEFN                &Mass Packaging Definiti FA_BPKG_DEFN       GBL
PKG_EQUATION_TBL             Packaging &Equation      PKG_EQUATION_TBL   GBL
PACKAGE_PLAN_TABL            Pac&kaging Plan          PACKAGE_PLAN_TABLE GBL
PACKAGE_RATING_COMPS         Package Rating &Componen PKG_RTNGCMP_GROUP  GBL
EQUITY_ITEM_TYPES            Pkg E&quity Item Types   PKG_EQUITY_GROUP   GBL
PKG_REL_ITEM_GROUP           Pkg &Related Item Type G PKG_REL_ITEM_GROUP GBL
FA_PRCSDEMO_TBL              &Process Demo            FA_PRCSDEMO_TBL    GBL
SETUP_RTN_TIV                Return of TI&V Aid Rules RTRN_TIV_FND_SETUP GBL
SORT_ORDER_FLDS              Sort Order &Fields       SORT_ORDER_FLDS    GBL
SORT_NAME_TBL                &Sort Order Names        SORT_NAME_TBL      GBL

INQUIRE1                   Inquire &1
ACTIVE_SERVICE_INDICATORS    &Active Service Indicato ACTIVE_SRVC_INDICA GBL
AGGREGATE_AID                Agg&regate Aid           STDNT_AGGR_AWDS    GBL
ANTICIPATED_AID_TERM         Anticipated Aid by Te&rm ANTICIPTD_AID_SUMM GBL
ANTICIPATED_AID_ITEM_TYPE    Anticipated Aid by &Item ANTICIPATED_AID    GBL
AS_OF_STATUS                 As &Of Status            AS_OF_STATUS       GBL
STDNT_DISB                   Authorization/Di&sbursem STDNT_DISB         GBL
AWARD_ACTIVITY_SUMMARY       Award &Activity          AWARD_ACTIVITY     GBL
AWARD_CATEGORY_SUMMARY       Award Ca&tegory Summary  STDNT_AWRD_CATG    GBL
FA_EARNINGS                  Awards/&Earnings Summary FA_EARNINGS        GBL
AWARD_NOTIFICATION_SUMMARY   Award &Notification Summ STDNT_FAN_ATRBT    GBL
STDNT_AWRD_INQUIRY           Award &Summary           STDNT_AWRD_INQUIRY GBL
BUDGET_REVIEW                &Budget Review           STDNT_BUDGET_SUMM  GBL
CHECKLIST_SUMMARY            Chec&klist Summary       CHKLST_SUMM_PERS   GBL
COMMENT_SUMMARY              Comment &Summary         OPR_3C_SUM_PERS    GBL
COMMUNICATION_SUMMARY        Commu&nication Summary   COMM_SUMMARY_PERS  GBL
CUSTOMER_ACCOUNTS            &Customer Accounts       ACCOUNT_VW         GBL
AWARD_NOTIF_INQ              FE Award N&otification I AWARD_NOTIF_INQ    GBL
FANLTR_SUMMARY               FE Award &Notification S FANLTR_SUMMARY     GBL
FISCAL_AGGREGATE_AREA        Fiscal  Aggregate &Summa AGGR_AREA_FISCAL   GBL
---------------

INQUIRE2                   Inquire &2
FA_JOB_SUMMARY               &Job Summary             FA_JOB_SUMMARY     GBL
PKG_BATCH_SUMM               Mass Packaging Summary   PKG_BATCH_SUMM     GBL
PKG_BATCH_STDNT              &Mass Packaging &Details PKG_BATCH_STDNT    GBL
PKG_BATCH_ERROR              Mass Packaging &Errors   PKG_BATCH_ERROR    GBL
NSLDS_INQUIRY                NS&LDS Inquiry           NSLDS_LOAN_INFO    GBL
FA_SS_AWRD_INQUIRY           Self-Service &Activity   FA_SS_AWRD_INQUIRY GBL
SS_FA_BATCH_INQ              Self-Service &Batch Summ FA_SS_BATCH_INQ    GBL
FA_SS_REQUEST_INQ            Self-Service &Requests   FA_SS_REQUEST_INQ  GBL
FA_SS_STAT_INQUIRY           Self-Service &Status     FA_SS_STAT_INQUIRY GBL
---------------
SS_FA_AU_STATUS              &Financial Aid Status    SS_FA_AU_STATUS    GBL

PROCESS                    &Process
ASSIGN_PKG_RTNG_COMPENENTS   Assign &Packaging Rtng C RUNCNTL_FA_PKG_RC  GBL
RUNCTL_AUTHORIZE             Authori&ze Aid           RUNCTL_AUTHRIZE    GBL
FA_AWARD_LETTER              Award &Notification Lett RUNCTL_FAN_SEL     GBL
FA_AWARD_LETTER_EXTRACT      Award Ltr &Data Extract  RUNCTL_FAN_EXTRACT GBL
RUN_CNTL_DISB                &Disburse Aid            RUNCTL_DISBURSE    GBL
RUN_CNTL_FANLTR              FE &Award Notification   RUN_CNTL_FANLTR    GBL
FAN_RPRT_RUNCTL              FE Award Notification &R FAN_RPRT_RUNCTL    GBL
RUNCTL_FA_INST               Inst Mass Packaging &Sel RUNCTL_FA_INST     GBL
RUNCTL_FA_INST_ASN           Inst Mass Packaging Assi RUNCTL_FA_INST_ASN GBL
RUNCTL_FA_INST_PRC           Inst Mass Packaging &Pro RUNCTL_FA_INST_PRC GBL
MASS_PKG_SEL                 Mass Packaging &Select   RUNCTL_FA_BPKG     GBL
MASS_PKG_ASN                 Mass Packaging Assi&gn   RUNCTL_FA_BPKG_ASN GBL
MASS_PKG_PRC                 Mass Packaging &Process  RUNCTL_FA_BPKG_PRC GBL
MASS_CHANGE                  &Run Mass Change         RUN_MASSCHNG       GBL
RUNCTL_FA_SS_AWARD           &Self-Service Awards     RUNCTL_FA_SS_AWARD GBL
SFA_RUN_SS_ACCESS            Self-Service &Access     SFA_RUN_SS_ACCESS  GBL

REPORT                     &Report
RUN_CNTL_FA913_RPT           &Authorization Failure R RUN_CNTL_FA913_RPT GBL
RUN_CNTL_FA906_RPT           Award vs. Disb &Reconcil RUN_CNTL_FA906_RPT GBL
FIN_AID_PKG_PLAN             FA710 Packaging Plan &Ru RUNCTL_FA_RPT_710  GBL
FA_RELATED_ITEMS             FA711 &Related Item Grou RUNCTL_FA_RPT_711  GBL
FIN_AID_DISB_AWARDS          FA801 &Award Data by Ite RUNCTL_FA_RPT_801  GBL
RUNCTL_FA_RPT_821            FA821 Batch Packaging &S RUNCTL_FA_RPT_821  GBL
RUNCTL_FA_RPT_822            FA822 Batch Packaging &D RUNCTL_FA_RPT_822  GBL
RUNCNTL_FATRMAWD             FA Term - Census         RUNCNTL_FATRMAWD   GBL
FUND_ROSTER                  &Fund Roster             RUN_CNTL_FA920_RPT GBL
RETURN_TIV_AID_RPT           Return of TI&V Aid Repor RUNCTL_FATIVRTN    GBL
RUN_CNTL_FA922_RPT           Overaward Report         RUN_CNTL_FA922_RPT GBL
---------------
RUNCTL_FA_FISAP03            FISAP Report 03          RUNCTL_FA_FISAP03  GBL
RUNCTL_FA_FISAP04            FISAP Report 04          RUNCTL_FA_FISAP04  GBL
RUNCTL_FA_FISAP05            FISAP Report 05          RUNCTL_FA_FISAP05  GBL
SFA_RUNCTL_FISAP06           FISAP Report 06          SFA_RUNCTL_FISAP06 GBL
SFA_RUNCTL_FISAP07           FISAP Report 07          SFA_RUNCTL_FISAP07 GBL
SFA_RUNCTL_FISAP08           FISAP Report 08          SFA_RUNCTL_FISAP08 GBL
SFA_RUNCTL_FISAP09           FISAP Report 09          SFA_RUNCTL_FISAP09 GBL
SFA_RUNCTL_FISAP10           FISAP Report 10          SFA_RUNCTL_FISAP10 GBL

Component Detail

Component: AV_CNST_RELATION_W (GBL)
	Description	Constituent Relation
	Search Record	AV_INST_WP_SRCH
	Add Search Record	
	Disable Saving Page	Yes	No
	Include in Navigator	Yes
	Mandatory SpellCheck	No
	Detail Page	PERSONAL_DATA1
	Actions	Update 
	Comments	This panelgroup displays all relationships for constituents in a wor
		kset.

	Internet
	Primary Action	Search
	Default Action	Update 
	Default Lookup Type	Advanced
	Allow Action Mode Sel.	Yes
	Link to App Page    Msg	124
	                    Nbr	62
	Link to Search Page Msg	124
	                    Nbr	63
	Instructional Text  Msg	124
	                    Nbr	50
	Disp Folder Tab (top)	Yes
	Disp Hiperlinks (bottom)	Yes
	Processing Mode	Interactive
	Allow Expert Entry	No
	Show ToolBar	Yes
	   Save	No	Yes
	   Cancel	No
	   SpellCheck	No
	   Return to List	Yes
	   Next in List	Yes
	   Prev in List	Yes
	   Next Page	Yes
	   Prev Page	Yes
	   Refresh	No
	   Notify	No
	   View Worklist	No
	   Next Worklist	No
	   Prov Worklist	No
	   Add	No
	   Update	Yes
	   UpdateAll	No
	   Correction	No
	Show Pagebar	Yes
	   Help Link	Yes
	   Copy URL Link	Yes
	   New Window Link	Yes
	   Customize Page Link	Yes

Panel Name         Item Name                Hid  Item Label              Folder Tab Label
AV_RELATION_PNL_W  AV_RELATION_PNL_W             Constituent Relationshi

Component: AV_ORG_RELATION_W (GBL)
	Description	Org Relationship Summary
	Search Record	AV_INST_WE_SRCH
	Add Search Record	
	Disable Saving Page	Yes	No
	Include in Navigator	Yes
	Mandatory SpellCheck	No
	Actions	Update 

	Internet
	Primary Action	Search
	Default Action	Update 
	Default Lookup Type	Advanced
	Allow Action Mode Sel.	Yes
	Link to App Page    Msg	124
	                    Nbr	62
	Link to Search Page Msg	124
	                    Nbr	63
	Instructional Text  Msg	124
	                    Nbr	50
	Disp Folder Tab (top)	Yes
	Disp Hiperlinks (bottom)	Yes
	Processing Mode	Interactive
	Allow Expert Entry	No
	Show ToolBar	Yes
	   Save	No	Yes
	   Cancel	No
	   SpellCheck	No
	   Return to List	Yes
	   Next in List	Yes
	   Prev in List	Yes
	   Next Page	Yes
	   Prev Page	Yes
	   Refresh	No
	   Notify	No
	   View Worklist	No
	   Next Worklist	No
	   Prov Worklist	No
	   Add	No
	   Update	Yes
	   UpdateAll	No
	   Correction	No
	Show Pagebar	Yes
	   Help Link	Yes
	   Copy URL Link	Yes
	   New Window Link	Yes
	   Customize Page Link	Yes

Panel Name         Item Name                Hid  Item Label              Folder Tab Label
AV_ORG_RELATION_W  AV_ORG_RELATION_W             Org Relationship Summar

Component: SFA_ASG_AL_TBL (GBL)
	Description	HERA Academic Level Setup
	Search Record	AID_YEAR_SRCH	INSTITUTION_TBL
	Add Search Record	
	Disable Saving Page	No
	Include in Navigator	Yes
	Mandatory SpellCheck	No
	Detail Page	SFA_ASG_AL_TBL
	Actions	Update 
	Comments	Used by FA Term program FAPTRMU1.CBL to determine HERA Academic Leve
		l on STDNT_FA_TERM table.

	Internet
	Primary Action	Search
	Default Action	Update 
	Default Lookup Type	Advanced
	Allow Action Mode Sel.	Yes
	Link to App Page    Msg	124
	                    Nbr	62
	Link to Search Page Msg	124
	                    Nbr	63
	Instructional Text  Msg	124
	                    Nbr	50
	Disp Folder Tab (top)	No
	Disp Hiperlinks (bottom)	No
	Processing Mode	Interactive
	Allow Expert Entry	Yes
	Show ToolBar	Yes
	   Save	Yes
	   Cancel	No
	   SpellCheck	No
	   Return to List	Yes
	   Next in List	Yes
	   Prev in List	Yes
	   Next Page	No
	   Prev Page	No
	   Refresh	Yes
	   Notify	No
	   View Worklist	No
	   Next Worklist	No
	   Prov Worklist	No
	   Add	No
	   Update	Yes
	   UpdateAll	No
	   Correction	No
	Show Pagebar	Yes
	   Help Link	Yes
	   Copy URL Link	Yes
	   New Window Link	Yes
	   Customize Page Link	Yes

Panel Name         Item Name                Hid  Item Label              Folder Tab Label
SFA_ASG_AL_TBL     SFA_ASG_AL_TBL                HERA Academic Level Set

Component: SFA_ASG_WI_TBL (GBL)
	Description	HERA Weeks of Instructn Setup	
	Search Record	INSTITUTION_VW3	
	Add Search Record	
	Disable Saving Page	No	
	Include in Navigator	Yes	
	Mandatory SpellCheck	No	
	Detail Page	SFA_ASG_WI_TBL	
	Actions	Update 	
	Comments	
		Used by FA Term program FAPTRMU1.CBL to determine HERA Weeks of Inst
		ructions and HERA Academic Level on STDNT_FA_TERM table.

	Internet
	Primary Action	Search	
	Default Action	Update 	
	Default Lookup Type	Advanced	
	Allow Action Mode Sel.	Yes	
	Link to App Page    Msg	124	
	                    Nbr	62	
	Link to Search Page Msg	124	
	                    Nbr	63	
	Instructional Text  Msg	124	
	                    Nbr	50	
	Disp Folder Tab (top)	No	
	Disp Hiperlinks (bottom)	No	
	Processing Mode	Interactive	
	Allow Expert Entry	Yes	
	Show ToolBar	Yes	
	   Save	Yes	
	   Cancel	No	
	   SpellCheck	No	
	   Return to List	Yes	
	   Next in List	Yes	
	   Prev in List	Yes	
	   Next Page	No	
	   Prev Page	No	
	   Refresh	Yes	
	   Notify	No	
	   View Worklist	No	
	   Next Worklist	No	
	   Prov Worklist	No	
	   Add	No	
	   Update	Yes	
	   UpdateAll	No	
	   Correction	No	
	Show Pagebar	Yes	
	   Help Link	Yes	
	   Copy URL Link	Yes	
	   New Window Link	Yes	
	   Customize Page Link	Yes	

Panel Name         Item Name                Hid  Item Label              Folder Tab Label
SFA_ASG_WI_TBL     SFA_ASG_WI_TBL                HERA Weeks of Instructi

Component: SFA_RUNCTL_FISAP10 (GBL)
	Description	FISAP 2010 Report	
	Search Record	PRCSRUNCNTL	
	Add Search Record	
	Disable Saving Page	No	
	Include in Navigator	Yes	
	Mandatory SpellCheck	No	
	Detail Page	SFA_RUNCTL_FISAP08	
	Actions	Add Update 	

	Internet
	Primary Action	Search	
	Default Action	Update 	
	Default Lookup Type	Basic	
	Allow Action Mode Sel.	Yes	
	Link to App Page    Msg	124	
	                    Nbr	62	
	Link to Search Page Msg	124	
	                    Nbr	63	
	Instructional Text  Msg	124	
	                    Nbr	50	
	Disp Folder Tab (top)	No	
	Disp Hiperlinks (bottom)	Yes	
	Processing Mode	Interactive	
	Allow Expert Entry	No	
	Show ToolBar	Yes	
	   Save	Yes	
	   Cancel	No	
	   SpellCheck	No	
	   Return to List	Yes	
	   Next in List	No	
	   Prev in List	No	
	   Next Page	Yes	
	   Prev Page	Yes	
	   Refresh	No	
	   Notify	No	
	   View Worklist	No	
	   Next Worklist	No	
	   Prov Worklist	No	
	   Add	Yes	
	   Update	Yes	
	   UpdateAll	No	
	   Correction	No	
	Show Pagebar	Yes	
	   Help Link	Yes	
	   Copy URL Link	Yes	
	   New Window Link	Yes	
	   Customize Page Link	Yes	

Panel Name         Item Name                Hid  Item Label              Folder Tab Label
SFA_RUNCTL_FISAP10 SFA_RUNCTL_FISAP10            Sfa Runctl Fisap10

Process Definition Detail

Process Definition: Application Engine 	UPD701889_A1
	Description	UPD701889_A1	
	Long Desc	
		HERA Level Setup Upgrade
	Priority	Medium	
	API Aware	Yes	

	Definition Options
	Server Name	 	
	Recurrence	 	

	Override Options
	Parameter List	None	
	CommandLine	None	
	Working Dir	None	

	Destination Options
	Type	Any	
	Source	User Specified	
	Output	 	

Component
PRCSMULTI

Process Group
HRALL
SAALL

Process Definition: Application Engine 	UPD701889_A2
	Description	UPD701889_A2	
	Long Desc	
		WI upgrade FA Calc on STDNT_FA_TERM
	Priority	Medium	
	API Aware	Yes	

	Definition Options
	Server Name	 	
	Recurrence	 	

	Override Options
	Parameter List	None	
	CommandLine	None	
	Working Dir	None	

	Destination Options
	Type	Any	
	Source	User Specified	
	Output	 	

Component
PRCSMULTI

Process Group
HRALL
SAALL

Process Definition: Application Engine 	UPD701889_A3
	Description	UPD701889_A3	
	Long Desc	
		WI upgrade FA Calc on STDNT_CAR_TERM
	Priority	Medium	
	API Aware	Yes	

	Definition Options
	Server Name	 	
	Recurrence	 	

	Override Options
	Parameter List	None	
	CommandLine	None	
	Working Dir	None	

	Destination Options
	Type	Any	
	Source	User Specified	
	Output	 	

Component
PRCSMULTI

Process Group
HRALL
SAALL

Process Definition: SQR Report 	FAPFSP10
	Description	FAPFSP10	
	Long Desc	
		FAPFSP10
	Priority	Medium	
	API Aware	Yes	

	Definition Options
	Server Name	 	
	Recurrence	 	

	Override Options
	Parameter List	None	
	CommandLine	None	
	Working Dir	None	

	Destination Options
	Type	Any	
	Source	User Specified	
	Output	 	

Component
SFA_RUNCTL_FISAP10

Process Group
HRALL
SAALL

Message Catalog Detail

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 453 (ENG)
	Severity	Message	
	Msg Text	HERA Weeks of Instruction Method requireds other field data.	
	Explanation	
		At lease one of the following four fields is blank: Weeks of Instruc
		tion Method, Hours/Credits in Acad Year, Weeks in Program Acad Year
		and Academic Calendar.   These fields are required to calculate HERA
		weeks of Instruction. Please fill in the appropriate values on the
		fields.

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 454 (ENG)
	Severity	Message	
	Msg Text	HERA Weeks of Instruction Set Up	
	Explanation	

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 455 (ENG)
	Severity	Message	
	Msg Text	Career/Program/Plan Set Up	
	Explanation	

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 456 (ENG)
	Severity	Message	
	Msg Text	Data entered in this field will not be used to determine the student's HERA level.	
	Explanation	
		The current method does not accept weeks of instruction values.

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 457 (ENG)
	Severity	Message	
	Msg Text	The current method does not accept weeks of instruction values.	
	Explanation	
		Data entered in either the Term Weeks or Transfer Weeks will not be
		used to determine the student's HERA level.

Message Catalog Entry: Stdnt Admin - Financial Aid 	14400, 458 (ENG)
	Severity	Message	
	Msg Text	Copy HERA Academic Level Set Up	
	Explanation	

Message Catalog Entry: ISIR/Profile Panel MSGS 	14404, 434 (ENG)
	Severity	Message
	Msg Text	Report on Eligible Aid Applicants for Award Year 2007 - 2008	Profile Load 08/09
	Explanation	

Message Catalog Entry: Stdnt Admin - ACG/SMART 	14426, 5160 (ENG)
	Severity	Message	
	Msg Text	PASSED: No posted transfer coursework for the student's career, program, and plan.	
	Explanation	
		PASSED: No posted transfer coursework for the student's career, prog
		ram, and plan.

Message Catalog Entry: Stdnt Admin - ACG/SMART 	14426, 5161 (ENG)
	Severity	Message	
	Msg Text	PASSED: Transfer weeks of instruction review appears to have been completed.	
	Explanation	
		PASSED: Transfer weeks of instruction review appears to have been co
		mpleted.

Message Catalog Entry: Stdnt Admin - ACG/SMART 	14426, 5162 (ENG)
	Severity	Message	
	Msg Text	REVIEW REQUIRED: Student appears to have posted transfer coursework that requires review.	
	Explanation	
		REVIEW REQUIRED: Student appears to have posted transfer coursework
		that requires review.

Message Catalog Entry: Stdnt Admin - ACG/SMART 	14426, 555 (ENG)
	Severity	Message	
	Msg Text	Transfer Credit - Manual	
	Explanation	
		PIA Label

Message Catalog Entry: Stdnt Admin - Authorization 	14441, 91 (ENG)
	Severity	Message	
	Msg Text	Student is not enrolled in an eligible course with the required CIP Code for the HERA grant.	
	Explanation	
		You may wish to check with the student's academic advisor to see if
		any of the enrolled courses now satisfies this requirement.

Appl Engine (Program) Detail

Appl Engine (Prog): UPD701889_A1
	Description	HERA Level Setup upgrade	
	Disable Restart	Yes	
	Application Library	No	
	ProgType	Standard	
	Batch Only	No	
	Message Set	0	
	Instance Count	0	
	TempTable cannot Assign	Continue	
	Date Override	No	
	As of Date	01/01/1900	
	Owner ID	SFA	
	Comments	
		HERA FA Term Weeks of Instruction upgrade.  This program updates the
		existing HERA Level set up table with the maximum Aid Year values f
		rom tehe AID_YEAR_TBL.  It then creates new set up data for the data
		for all Aid Years in the Aid Year table by copying the existing dat
		a.

State Record     Def
UPG_SFA_AL_AET   YES

Temp Record    
UPG_SFAAL_TAO

Appl Engine (Prog): UPD701889_A2
	Description	WI upgrade FA Calc on FA Term	
	Disable Restart	Yes	
	Application Library	No	
	ProgType	Standard	
	Batch Only	No	
	Message Set	0	
	Instance Count	0	
	TempTable cannot Assign	Continue	
	Date Override	No	
	As of Date	01/01/1900	
	Owner ID	SFA	
	Comments	
		HERA FA Term Weeks of Instruction upgrade. This program updates the
		FA Calc flag on STDNT_FA_TERM for all Students with terms that have
		HERA Awards, HERA Eligibility and student whose most recent FA Term
		has a HERA BOT Level value.

State Record     Def
UPG_SFA_TM2_AET  YES

Temp Record    
UPG_SFATM_TAO

Appl Engine (Prog): UPD701889_A3
	Description	WI upgrade FA Calc on STCARTRM	
	Disable Restart	Yes	
	Application Library	No	
	ProgType	Standard	
	Batch Only	No	
	Message Set	0	
	Instance Count	0	
	TempTable cannot Assign	Continue	
	Date Override	No	
	As of Date	01/01/1900	
	Owner ID	SFA	
	Comments	
		HERA FA Term Weeks of Instruction upgrade.  This program update the
		FA Calc flag on STDNT_CAR_TERM for all students who have new WI fiel
		d amounts on the Transfer tables,  TRNS_CRSE_TRM, TRNS_TEST_TRM and
		TRNS_OTHR_TRM.

State Record     Def
UPG_SFA_TM3_AET  YES

Appl Engine (Section) Detail

Appl Engine (Section): AV_GCLUB 	DELMBR
	Description	Delete Gclub Mbr Data
	Market	GBL
	DataBase	Default
	EffDt	01/01/1900
	Effective Status	Active
	Section Type	Prepare Only
	Auto Commit	No

Step/Action        Description                    Attributes

[Step10  ]
[PeopleCode  ]
[SQL         ]

[Step20  ]
[PeopleCode  ]
[SQL         ]

Appl Engine (Section): UPD701889_A1 	DRIVER
	Description	Main Processing  Driver	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	

Step/Action        Description                    Attributes

[Step010 ]         SELECT INSTITUTION
[SQL         ] Get Institutions

[Step020 ]         GET COUNT
[SQL         ] Count # of Inst

[Step030 ]         Message the Count
[Log Message ]                                MsgSet: 18030 Number: 4 Param: %AESECTION, %AESTEP, %BIND(UPG_SFA_AL_AET.RECORD_COUNT) INST, 'UPG_SFAAL_TAO'

[Step040 ]         If Inst found, call LVL Update
[Call Section] Call Section HERALVL           Section: UPD701889_A1.HERALVL
[PeopleCode  ] Any Records Found?

Appl Engine (Section): UPD701889_A1 	HERALVL
	Description	Aid Year	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	

Step/Action        Description                    Attributes

[Step010 ]         Update Aid Year
[SQL         ] Update SFA_ASG_AL_TBL

[Step020 ]         Log Updates
[Log Message ]                                MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'SFA_ASG_AL_TBL'

[Step030 ]         Insert New Years
[SQL         ] Insert into SFA_ASG_AL_TBL

[Step040 ]         Step031 description
[Log Message ]                                MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'SFA_ASG_AL_TBL'

Appl Engine (Section): UPD701889_A1 	MAIN
	Description	MAIN description	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	
	Access	Public	

Step/Action        Description                    Attributes

[Step010 ]         Start  Program Message
[Log Message ] Log Message Start              MsgSet: 18030 Number: 2 Param: %AEPROGRAM

[Step020 ]         Call Driver
[Call Section]                                Section: UPD701889_A1.DRIVER

[Step030 ]         End Program Message
[Log Message ] Log Message End                MsgSet: 18030 Number: 5 Param: %AEPROGRAM

Appl Engine (Section): UPD701889_A2 	MAIN
	Description	MAIN description	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	
	Access	Public	

Step/Action        Description                    Attributes

[Step010 ]         Start  Program Message
[Log Message ] Log Message Start              MsgSet: 18030 Number: 2 Param: %AEPROGRAM

[Step020 ]         Call Driver
[Call Section]                                Section: UPD701889_A2.WICALC

[Step030 ]         End Program Message
[Log Message ] Log Message End                MsgSet: 18030 Number: 5 Param: %AEPROGRAM

Appl Engine (Section): UPD701889_A2 	WICALC
	Description	Update FA Term FA Calc Flag	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	

Step/Action        Description                    Attributes

[Step010 ]         Clear Temp Table
[SQL         ] Delete UPG_SFATM_TAO

[Step020 ]         Get Grant Recip FA Term Keys
[SQL         ] Insert into UPG_SFATM_TAO

[Step025 ]         Msg count after tmp insert
[Log Message ]                                MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_FA_TERM'

[Step030 ]         Update FA Calc for Grant Recip
[SQL         ] Update STDNT_FA_TERM FA Calc

[Step035 ]         Clear Temp Table
[SQL         ] Delete UPG_SFATM_TAO

[Step040 ]         Get Grant Elig FA Term Keys
[SQL         ] Insert into UPG_SFATM_TAO

[Step045 ]         Msg count after tmp insert
[Log Message ]                                MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_FA_TERM'

[Step050 ]         Update FA Calc for Grant Elig
[SQL         ] Update STDNT_FA_TERM Fa Calc

[Step055 ]         Clear Temp
[SQL         ] Delete UPG_SFATM_TAO

[Step060 ]         Get All max term UGRD Keys
[SQL         ] Insert into UPG_SFATM_TAO

[Step065 ]         Msg count after tmp insert
[Log Message ] Log Message                    MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_FA_TERM'

[Step070 ]         Update FA Calc for Grant Elig
[SQL         ] Update STDNT_FA_TERM Fa Calc

Appl Engine (Section): UPD701889_A3 	MAIN
	Description	MAIN description	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	
	Access	Public	

Step/Action        Description                    Attributes

[Step010 ]         Start  Program Message
[Log Message ] Log Message Start              MsgSet: 18030 Number: 2 Param: %AEPROGRAM

[Step020 ]         Call Driver
[Call Section]                                Section: UPD701889_A3.STCARTRM

[Step030 ]         End Program Message
[Log Message ] Log Message End                MsgSet: 18030 Number: 5 Param: %AEPROGRAM

Appl Engine (Section): UPD701889_A3 	STCARTRM
	Description	Section1 description	
	Market	GBL	
	DataBase	Default	
	EffDt	01/01/1900	
	Effective Status	Active	
	Section Type	Prepare Only	
	Auto Commit	No	

Step/Action        Description                    Attributes

[Step010 ]         Update STDNT_CAR_TERM
[SQL         ] TRNS_CRSE_TERM

[Step020 ]         Count
[Log Message ] Log Message                    MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_CAR_TERM'

[Step030 ]         Update STDNT_CAR_TERM
[SQL         ] TRNS_TEST_TERM

[Step040 ]         Count
[Log Message ] Log Message                    MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_CAR_TERM'

[Step050 ]         Update STDNT_CAR_TERM
[SQL         ] TRNS_OTHR_TERM

[Step060 ]         Count
[Log Message ] Log Message                    MsgSet: 18030 Number: 3 Param: %AESECTION, %AESTEP, %SQLROWS, 'STDNT_CAR_TERM'

SQL Detail

SQL: AID_YEAR_SRCH 	View

SQL Statement

SELECT INSTITUTION,
      AID_YEAR,
      DESCR,
      DESCRSHORT,
      ACAD_YEAR_START,
      ACAD_YEAR_END
 FROM  PS_AID_YEAR_TBL

SQL: AV_EXT_ORG_2_VW 	View

SQL Statement
SELECT EXT_ORG_ID,
      EFFDT,
      EFF_STATUS,
      DESCR
 FROM  PS_EXT_ORG_TBL
SELECT A.EXT_ORG_ID,
      A.EFFDT,
      A.DESCR,
      A.ORG_LOCATION,
      A.ADDRESS1,
      A.ADDRESS2,
      A.ADDRESS3,
      A.ADDRESS4,
      A.CITY,
      A.STATE,
      A.COUNTY,
      A.POSTAL,
      A.COUNTRY
 FROM  PS_EXT_ORG_TBL A
 WHERE %EffdtCheck(EXT_ORG_TBL A1, A, %CurrentDateIn)

SQL: AV_GCLUB    DELMBR  Step10  S 	ApplEng
	ApplEng	AV_GCLUB    
	Section	DELMBR  
	Step   	Step10  
	Action 	SQL
	Market	GBL

SQL Statement
DELETE FROM %Table(AV_GCLUB_MBR)
 WHERE %Table(AV_GCLUB_MBR) .INSTITUTION = %Bind(INSTITUTION)
   AND %Table(AV_GCLUB_MBR) .GCLUB_CD IN (SELECT A1.GCLUB_CD
 FROM  %Table(AV_GCLUB_TBL) A1
 WHERE A1.INSTITUTION = %Table(AV_GCLUB_MBR) .INSTITUTION
   AND A1.GCLUB_CD = %Table(AV_GCLUB_MBR) .GCLUB_CD
   AND A1.STATUS = 'A')
   AND (%Table(AV_GCLUB_MBR) .GCLUB_MBR_STATUS = 'A'
   OR  %Table(AV_GCLUB_MBR) .GCLUB_MBR_STATUS = 'M')

SQL: AV_GCLUB    DELMBR  Step20  S 	ApplEng
	ApplEng	AV_GCLUB    
	Section	DELMBR  
	Step   	Step20  
	Action 	SQL
	Market	GBL

SQL Statement
DELETE FROM %Table(AV_GCLUB_MBR)
 WHERE %Table(AV_GCLUB_MBR) .INSTITUTION = %Bind(INSTITUTION)
   AND %Table(AV_GCLUB_MBR) .GCLUB_CD IN (SELECT A1.GCLUB_CD
 FROM  %Table(AV_RUNCTL_GCINT) A1,
       %Table(AV_GCLUB_TBL) B1
 WHERE A1.OPRID = %Bind(OPRID)
   AND A1.RUN_CNTL_ID = %Bind(RUN_CNTL_ID)
   AND A1.INSTITUTION = B1.INSTITUTION
   AND A1.GCLUB_CD = B1.GCLUB_CD
   AND B1.STATUS = 'A')
   AND (%Table(AV_GCLUB_MBR) .GCLUB_MBR_STATUS = 'A'
   OR  %Table(AV_GCLUB_MBR) .GCLUB_MBR_STATUS = 'M')

SQL: AV_GC_ML_SUM_VW 	View

SQL Statement
SELECT INSTITUTION,
      GCLUB_CD,
      GCLUB_LVL,
      FISCAL_YEAR,
      CURRENCY_CD,
      SUM(GCLUB_AMT)
 FROM  PS_AV_GCLUB_MBR
 WHERE GCLUB_MBR_STATUS = 'M'
 WHERE (GCLUB_MBR_STATUS = 'M'
        OR  GCLUB_MBR_STATUS = 'X')
 GROUP BY INSTITUTION,
      GCLUB_CD,
      GCLUB_LVL,
      FISCAL_YEAR,
      CURRENCY_CD

SQL: DISB_RULE_ZCOPY 	View

SQL Statement
SELECT INSTITUTION,
      AID_YEAR,
      ACAD_CAREER,
      ITEM_TYPE,
      EFFDT,
      EFF_STATUS,
      DESCR,
      DESCRSHORT,
      SAT_PROG_IND,
      VERF_IND,
      PKG_IND,
      REVIEW_IND,
      HONOR_DISB_IND,
      WITHDRAW_IND,
      FEE_MATCH_IND,
      FEE_MATCH_TOL_VAL,
      EFC_IND,
      LD_MATCH_AWD_IND,
      LD_MATCH_BDG_IND,
      LVL_MATCH_BDG_IND,
      MIN_GPA_ON_FA_TERM,
      MIN_GPA_PRIOR_TERM,
      UNITS_MINIMUM,
      HLD_DSB_FEDOVR_IND,
      HLD_DSB_INSOVR_IND,
      STATE_RESIDENCE,
      ETHNIC_GROUP,
      ACAD_PLAN,
      ACAD_SUB_PLAN,
      FORM_OF_STUDY,
      ATHL_PARTIC_CD,
      STDNT_GROUP,
      CAREER_MATCH_IND,
      ACAD_STANDING,
      SPORT,
      COUNTRY,
      NSLDS_LOAN_YR_IND,
      FFELP_TOL_VAL,
      DISB_PRORATN_RULE,
      AUTH_TO_FEE_IND,
      AUTH_IF_ENROLL,
      POST_DISB_RED,
      POST_DISB_RED_CDT,
      LOAN_INTERVIEW_SW,
      PRORA_CENSUS_DT_SW,
      FA_USE_CURRENT_LD,
      FA_USE_CURR_UNITS,
      SFA_ASG_ACAD_IND,
      SFA_ASG_CIP_IND,
      SFA_ASG_GPA_IND,
      SFA_ASG_IGRADE_IND,
      SFA_ASG_PELL_IND,
      SFA_ASG_MIN_GPA
      SFA_ASG_MIN_GPA,
      SFA_ASG_SMART_CIP
 FROM  PS_DISB_RULE_ITM

SQL: INSTITUTION_VW3 	View

SQL Statement

SELECT A.INSTITUTION,
      A.EFFDT,
      A.EFF_STATUS,
      A.DESCR,
      A.DESCRSHORT
 FROM  PS_INSTITUTION_TBL A
 WHERE A.EFFDT = (SELECT MAX(A1.EFFDT)
      FROM  PS_INSTITUTION_TBL A1
      WHERE A1.INSTITUTION = A.INSTITUTION
        AND A1.EFFDT <= %CurrentDateIn)
        AND A.EFF_STATUS = 'A'

SQL: SFA_ASG_AL_COPY 	View

SQL Statement

SELECT INSTITUTION,
      AID_YEAR,
      ACAD_CAREER,
      ACAD_PROG,
      ACAD_PLAN,
      LEVEL_LOAD_RULE
 FROM  PS_SFA_ASG_AL_TBL

SQL: SFA_ASG_FATALVW 	View

SQL Statement

SELECT B.EMPLID,
      B.INSTITUTION,
      B.AID_YEAR,
      B.SFA_ASG_GRANT_TYPE,
      A.STRM,
      A.SFA_ASG_AC_LVL_BOT,
      A.SFA_ASG_AC_LVL_EOT,
      A.OVRD_ASG_BOT,
      A.OVRD_ASG_EOT,
      A.SFA_ASG_AC_LVL_BCL,
      A.SFA_ASG_AC_LVL_ECL,
      A.SFA_ASG_UNITS_BOT,
      A.SFA_ASG_UNITS_EOT,
      A.SFA_ASG_WI_MTH,
      A.SFA_ASG_WI_MTH_OVR,
      A.SFA_ASG_WI_MTH_CL,
      A.SFA_ASG_WI_TRM,
      A.SFA_ASG_WI_TRM_OVR,
      A.SFA_ASG_WI_TRM_CL,
      A.SFA_ASG_WI_TCR,
      A.SFA_ASG_WI_TCR_OVR,
      A.SFA_ASG_WI_TCR_CL,
      A.SFA_ASG_WI_CUM_BOT,
      A.SFA_ASG_WI_CUM_EOT,
      A.SFA_ASG_WI_USED
 FROM  PS_STDNT_FA_TERM A,
       PS_SFA_ASG_ELIG B
 WHERE A.EMPLID = B.EMPLID
   AND A.INSTITUTION = B.INSTITUTION
   AND A.STRM = B.STRM
   AND A.EFFDT = (SELECT MAX(A1.EFFDT)
      FROM  PS_STDNT_FA_TERM A1
      WHERE A1.EMPLID = A.EMPLID
        AND A1.INSTITUTION = A.INSTITUTION
        AND A1.STRM = A.STRM
        AND A1.EFFDT <= %CurrentDateIn)
        AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ)
            FROM  PS_STDNT_FA_TERM A2
            WHERE A2.EMPLID = A.EMPLID
              AND A2.INSTITUTION = A.INSTITUTION
              AND A2.STRM = A.STRM
              AND A2.EFFDT = A.EFFDT)
        AND A.EFF_STATUS = 'A'

SQL: UPD701889_A1DRIVER  Step010 S 	ApplEng
	ApplEng	UPD701889_A1	
	Section	DRIVER  	
	Step   	Step010 	
	Action 	SQL	
	Market	GBL	

SQL Statement

INSERT INTO %Table(UPG_SFAAL_TAO)
      (PROCESS_INSTANCE,
      INSTITUTION,
      RECORD_COUNT)
 SELECT DISTINCT
      %Bind(PROCESS_INSTANCE),
      A.INSTITUTION,
      0
 FROM  PS_SFA_ASG_AL_TBL A

SQL: UPD701889_A1DRIVER  Step020 S 	ApplEng
	ApplEng	UPD701889_A1	
	Section	DRIVER  	
	Step   	Step020 	
	Action 	SQL	
	Market	GBL	

SQL Statement

%Select(RECORD_COUNT)
 SELECT COUNT(*)
 FROM  %Table(UPG_SFAAL_TAO)
 WHERE PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)

SQL: UPD701889_A1HERALVL Step010 S 	ApplEng
	ApplEng	UPD701889_A1	
	Section	HERALVL 	
	Step   	Step010 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE %Table(SFA_ASG_AL_TBL) SET
      AID_YEAR = (SELECT MAX(A.AID_YEAR)
      FROM  PS_AID_YEAR_TBL A
      WHERE A.INSTITUTION = %Table(SFA_ASG_AL_TBL) .INSTITUTION)
 WHERE AID_YEAR = ' '

SQL: UPD701889_A1HERALVL Step030 S 	ApplEng
	ApplEng	UPD701889_A1	
	Section	HERALVL 	
	Step   	Step030 	
	Action 	SQL	
	Market	GBL	

SQL Statement

INSERT INTO PS_SFA_ASG_AL_TBL
      (INSTITUTION,
      AID_YEAR,
      ACAD_CAREER,
      ACAD_PROG,
      ACAD_PLAN,
      LEVEL_LOAD_RULE)
 SELECT
      A.INSTITUTION,
      B.AID_YEAR,
      A.ACAD_CAREER,
      A.ACAD_PROG,
      A.ACAD_PLAN,
      A.LEVEL_LOAD_RULE
 FROM  PS_SFA_ASG_AL_TBL A,
       PS_AID_YEAR_TBL B
 WHERE A.INSTITUTION = B.INSTITUTION
   AND B.AID_YEAR <> A.AID_YEAR

SQL: UPD701889_A2WICALC  Step010 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step010 	
	Action 	SQL	
	Market	GBL	

SQL Statement

DELETE FROM %Table(UPG_SFATM_TAO)
 WHERE PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)

SQL: UPD701889_A2WICALC  Step020 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step020 	
	Action 	SQL	
	Market	GBL	

SQL Statement

INSERT INTO %Table(UPG_SFATM_TAO)
      (PROCESS_INSTANCE,
      EMPLID,
      INSTITUTION,
      STRM,
      EFFDT,
      EFFSEQ,
      FA_STATS_CALC_REQ)
 SELECT
      %Bind(PROCESS_INSTANCE),
      A.EMPLID,
      A.INSTITUTION,
      A.STRM,
      A.EFFDT,
      A.EFFSEQ,
      'Y'
 FROM  PS_STDNT_FA_TERM A
 WHERE A.EFFDT = (SELECT MAX(A1.EFFDT)
      FROM  PS_STDNT_FA_TERM A1
      WHERE A1.EMPLID = A.EMPLID
        AND A1.INSTITUTION = A.INSTITUTION
        AND A1.STRM = A.STRM
        AND A1.EFFDT <= %CurrentDateIn)
        AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ)
            FROM  PS_STDNT_FA_TERM A2
            WHERE A2.EMPLID = A.EMPLID
              AND A2.INSTITUTION = A.INSTITUTION
              AND A2.STRM = A.STRM
              AND A2.EFFDT = A.EFFDT)
        AND A.EFF_STATUS = 'A'
        AND EXISTS (SELECT DISTINCT E.EMPLID
            FROM  PS_STDNT_AWARDS E,
                  PS_ITEM_TYPE_FA G
            WHERE E.EMPLID = A.EMPLID
              AND E.INSTITUTION = A.INSTITUTION
              AND E.AID_YEAR = A.AID_YEAR
              AND G.SETID = E.SETID
              AND G.ITEM_TYPE = E.ITEM_TYPE
              AND G.AID_YEAR = E.AID_YEAR
              AND G.EFFDT = (SELECT MAX(G1.EFFDT)
                  FROM  PS_ITEM_TYPE_FA G1
                  WHERE G1.SETID = G.SETID
                    AND G1.ITEM_TYPE = G.ITEM_TYPE
                    AND G1.AID_YEAR = G.AID_YEAR
                    AND G1.EFFDT <= %CurrentDateIn)
                    AND G.EFF_STATUS = 'A'
                    AND G.FA_SOURCE = 'F'
                    AND G.FEDERAL_ID IN ('ACG', 'SMRT'))

SQL: UPD701889_A2WICALC  Step030 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step030 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_FA_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  %Table(UPG_SFATM_TAO)
      WHERE %Table(UPG_SFATM_TAO) .PROCESS_INSTANCE = %Bind(UPG_SFA_AL_AET.PROCESS_INSTANCE)
   AND EMPLID = %Table(UPG_SFATM_TAO) .EMPLID
   AND INSTITUTION = %Table(UPG_SFATM_TAO) .INSTITUTION
   AND STRM = %Table(UPG_SFATM_TAO) .STRM
   AND EFFDT = %Table(UPG_SFATM_TAO) .EFFDT
   AND EFFSEQ = %Table(UPG_SFATM_TAO) .EFFSEQ)

SQL: UPD701889_A2WICALC  Step035 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step035 	
	Action 	SQL	
	Market	GBL	

SQL Statement

DELETE FROM %Table(UPG_SFATM_TAO)
 WHERE PROCESS_INSTANCE = %Bind(UPG_SFA_AL_AET.PROCESS_INSTANCE)

SQL: UPD701889_A2WICALC  Step040 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step040 	
	Action 	SQL	
	Market	GBL	

SQL Statement

INSERT INTO %Table(UPG_SFATM_TAO)
      (PROCESS_INSTANCE,
      EMPLID,
      INSTITUTION,
      STRM,
      EFFDT,
      EFFSEQ,
      FA_STATS_CALC_REQ)
 SELECT
      %Bind(PROCESS_INSTANCE),
      A.EMPLID,
      A.INSTITUTION,
      A.STRM,
      A.EFFDT,
      A.EFFSEQ,
      'Y'
 FROM  PS_STDNT_FA_TERM A
 WHERE A.EFFDT = (SELECT MAX(A1.EFFDT)
      FROM  PS_STDNT_FA_TERM A1
      WHERE A1.EMPLID = A.EMPLID
        AND A1.INSTITUTION = A.INSTITUTION
        AND A1.STRM = A.STRM
        AND A1.EFFDT <= %CurrentDateIn)
        AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ)
            FROM  PS_STDNT_FA_TERM A2
            WHERE A2.EMPLID = A.EMPLID
              AND A2.INSTITUTION = A.INSTITUTION
              AND A2.STRM = A.STRM
              AND A2.EFFDT = A.EFFDT)
        AND A.EFF_STATUS = 'A'
        AND EXISTS (SELECT DISTINCT E.EMPLID
            FROM  PS_SFA_ASG_ELIG E
            WHERE E.EMPLID = A.EMPLID
              AND E.INSTITUTION = A.INSTITUTION
              AND E.AID_YEAR = A.AID_YEAR
              AND E.STRM = A.STRM)

SQL: UPD701889_A2WICALC  Step050 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step050 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_FA_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  %Table(UPG_SFATM_TAO)
      WHERE %Table(UPG_SFATM_TAO) .PROCESS_INSTANCE = %Bind(UPG_SFA_AL_AET.PROCESS_INSTANCE)
   AND EMPLID = %Table(UPG_SFATM_TAO) .EMPLID
   AND INSTITUTION = %Table(UPG_SFATM_TAO) .INSTITUTION
   AND STRM = %Table(UPG_SFATM_TAO) .STRM
   AND EFFDT = %Table(UPG_SFATM_TAO) .EFFDT
   AND EFFSEQ = %Table(UPG_SFATM_TAO) .EFFSEQ)

SQL: UPD701889_A2WICALC  Step055 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step055 	
	Action 	SQL	
	Market	GBL	

SQL Statement

DELETE FROM %Table(UPG_SFATM_TAO)
 WHERE PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)

SQL: UPD701889_A2WICALC  Step060 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step060 	
	Action 	SQL	
	Market	GBL	

SQL Statement

INSERT INTO %Table(UPG_SFATM_TAO)
      (PROCESS_INSTANCE,
      EMPLID,
      INSTITUTION,
      STRM,
      EFFDT,
      EFFSEQ,
      FA_STATS_CALC_REQ)
 SELECT
      %Bind(PROCESS_INSTANCE),
      A.EMPLID,
      A.INSTITUTION,
      A.STRM,
      A.EFFDT,
      A.EFFSEQ,
      'Y'
 FROM  PS_STDNT_FA_TERM A
 WHERE A.EFFDT = (SELECT MAX(A1.EFFDT)
      FROM  PS_STDNT_FA_TERM A1
      WHERE A1.EMPLID = A.EMPLID
        AND A1.INSTITUTION = A.INSTITUTION
        AND A1.STRM = A.STRM
        AND A1.EFFDT <= %CurrentDateIn)
        AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ)
            FROM  PS_STDNT_FA_TERM A2
            WHERE A2.EMPLID = A.EMPLID
              AND A2.INSTITUTION = A.INSTITUTION
              AND A2.STRM = A.STRM
              AND A2.EFFDT = A.EFFDT)
        AND A.EFF_STATUS = 'A'
        AND EXISTS (SELECT DISTINCT B.EMPLID
            FROM  PS_STDNT_FA_TERM B
            WHERE B.EMPLID = A.EMPLID
              AND B.INSTITUTION = A.INSTITUTION
              AND B.STRM = (SELECT MAX(B3.STRM)
                  FROM  PS_STDNT_FA_TERM B3
                  WHERE B3.EMPLID = B.EMPLID
                    AND B3.INSTITUTION = B.INSTITUTION)
              AND B.EFFDT = (SELECT MAX(B1.EFFDT)
                  FROM  PS_STDNT_FA_TERM B1
                  WHERE B1.EMPLID = B.EMPLID
                    AND B1.INSTITUTION = B.INSTITUTION
                    AND B1.STRM = B.STRM
                    AND B1.EFFDT <= %CurrentDateIn)
                    AND B.EFFSEQ = (SELECT MAX(B2.EFFSEQ)
                        FROM  PS_STDNT_FA_TERM B2
                        WHERE B2.EMPLID = B.EMPLID
                          AND B2.INSTITUTION = B.INSTITUTION
                          AND B2.STRM = B.STRM
                          AND B2.EFFDT = B.EFFDT)
                    AND B.EFF_STATUS = 'A'
                    AND B.SFA_ASG_AC_LVL_BOT <> ' ')

SQL: UPD701889_A2WICALC  Step070 S 	ApplEng
	ApplEng	UPD701889_A2	
	Section	WICALC  	
	Step   	Step070 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_FA_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  %Table(UPG_SFATM_TAO)
      WHERE %Table(UPG_SFATM_TAO) .PROCESS_INSTANCE = %Bind(UPG_SFA_AL_AET.PROCESS_INSTANCE)
   AND EMPLID = %Table(UPG_SFATM_TAO) .EMPLID
   AND INSTITUTION = %Table(UPG_SFATM_TAO) .INSTITUTION
   AND STRM = %Table(UPG_SFATM_TAO) .STRM
   AND EFFDT = %Table(UPG_SFATM_TAO) .EFFDT
   AND EFFSEQ = %Table(UPG_SFATM_TAO) .EFFSEQ)

SQL: UPD701889_A3STCARTRMStep010 S 	ApplEng
	ApplEng	UPD701889_A3	
	Section	STCARTRM	
	Step   	Step010 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_CAR_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  PS_TRNS_CRSE_TERM B
      WHERE PS_STDNT_CAR_TERM.EMPLID = B.EMPLID
        AND PS_STDNT_CAR_TERM.ACAD_CAREER = B.ACAD_CAREER
        AND PS_STDNT_CAR_TERM.INSTITUTION = B.INSTITUTION
        AND PS_STDNT_CAR_TERM.STRM = B.ARTICULATION_TERM
        AND (B.SSR_FAWI_TKN > 0
              OR  B.SSR_FAWI_TKN_GPA > 0
              OR  B.SSR_FAWI_TKN_NOGPA > 0
              OR  B.SSR_FAWI_PSD > 0
              OR  B.SSR_FAWI_PSD_GPA > 0
              OR  B.SSR_FAWI_PSD_NOGPA > 0
              OR  B.SSR_FAWI_GRADE_PTS > 0
              OR  B.SSR_FAWI_GPA > 0))

SQL: UPD701889_A3STCARTRMStep030 S 	ApplEng
	ApplEng	UPD701889_A3	
	Section	STCARTRM	
	Step   	Step030 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_CAR_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  PS_TRNS_TEST_TERM B
      WHERE PS_STDNT_CAR_TERM.EMPLID = B.EMPLID
        AND PS_STDNT_CAR_TERM.ACAD_CAREER = B.ACAD_CAREER
        AND PS_STDNT_CAR_TERM.INSTITUTION = B.INSTITUTION
        AND PS_STDNT_CAR_TERM.STRM = B.ARTICULATION_TERM
        AND (B.SSR_FAWI_TKN_GPA > 0
              OR  B.SSR_FAWI_TKN_NOGPA > 0
              OR  B.SSR_FAWI_PSD > 0
              OR  B.SSR_FAWI_PSD_GPA > 0
              OR  B.SSR_FAWI_PSD_NOGPA > 0
              OR  B.SSR_FAWI_GRADE_PTS > 0
              OR  B.SSR_FAWI_GPA > 0))

SQL: UPD701889_A3STCARTRMStep050 S 	ApplEng
	ApplEng	UPD701889_A3	
	Section	STCARTRM	
	Step   	Step050 	
	Action 	SQL	
	Market	GBL	

SQL Statement

UPDATE PS_STDNT_CAR_TERM SET
      FA_STATS_CALC_REQ = 'Y'
 WHERE EXISTS (SELECT 'X'
      FROM  PS_TRNS_OTHR_TERM B
      WHERE PS_STDNT_CAR_TERM.EMPLID = B.EMPLID
        AND PS_STDNT_CAR_TERM.ACAD_CAREER = B.ACAD_CAREER
        AND PS_STDNT_CAR_TERM.INSTITUTION = B.INSTITUTION
        AND PS_STDNT_CAR_TERM.STRM = B.ARTICULATION_TERM
        AND (B.SSR_FAWI_TKN_GPA > 0
              OR  B.SSR_FAWI_TKN_NOGPA > 0
              OR  B.SSR_FAWI_PSD > 0
              OR  B.SSR_FAWI_PSD_GPA > 0
              OR  B.SSR_FAWI_PSD_NOGPA > 0
              OR  B.SSR_FAWI_GRADE_PTS > 0
              OR  B.SSR_FAWI_GPA > 0))

PeopleCode Detail

PeopleCode (Record): AID_YEAR_SRCH.INSTITUTION.SearchInit
SetSearchEdit(AID_YEAR_SRCH.INSTITUTION);
SetSearchDefault(AID_YEAR_SRCH.INSTITUTION);

PeopleCode (Record): AV_GCLUB_MBR.GCLUB_CD.FieldChange
If %PanelGroup = PanelGroup.AV_GCLUB_MBR Or
      %PanelGroup = PanelGroup.AV_GCLUB_MBR_E Or
      %PanelGroup = PanelGroup.AV_GCLUB_MBR_W Then
   If AV_GCLUB_TBL.GCLUB_RESET = "N" Then
      Hide(AV_GCLUB_MBR.FISCAL_YEAR);
   Else
      UnHide(AV_GCLUB_MBR.FISCAL_YEAR);
   End-If;
End-If;

PeopleCode (Record): AV_GCLUB_MBR.GCLUB_MBR_STATUS.FieldChange
If %Component = Component.AV_GCLUB_MBR Or
      %Component = Component.AV_GCLUB_MBR_E Then
   If AV_GCLUB_MBR.GCLUB_MBR_STATUS = "X" Then
      AV_GCLUB_MBR.GCLUB_ADDED_BY = "X"
   End-If;
End-If;

PeopleCode (Record): AV_RELATE_E.EXT_ORG_ID_RELATED.FieldChange
Function ga_ils-Ga AV_RELATE_E.DESCR);
Ga AV_RELATE_E.PHONE_DAY)
Function gray_fields
   Gray(AV_RELATE_E.DESCR);
   Gray(AV_RELATE_E.PHONE_DAY);
   Gray(AV_RELATE_E.PHONE_EVE);
   Gray(AV_RELATE_E.PHONE_FAX);
   Gray(AV_RELATE_E.ADDRESS1);
   Gray(AV_RELATE_E.ADDRESS2);
   Gray(AV_RELATE_E.ADDRESS3);
   Gray(AV_RELATE_E.ADDRESS4);
   Gray(AV_RELATE_E.CITY);
   Gray(AV_RELATE_E.COUNTY);
   Gray(AV_RELATE_E.POSTAL);
   Gray(AV_RELATE_E.COUNTRY);
   Gray(AV_RELATE_E.STATE);
   Gray(SA_LBL_WRK.CITY_TOWN1_LBL);
   Gray(SA_LBL_WRK.COUNTY_TOWN2_LBL);
   Gray(SA_LBL_WRK.STATE_PROVINCE_LBL);
End-Function;

Function update_fields
   AV_RELATE_E.DESCR = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.NAME);
   AV_RELATE_E.ADDRESS1 = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS1);
   AV_RELATE_E.ADDRESS2 = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS2);
   AV_RELATE_E.ADDRESS3 = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS3);
   AV_RELATE_E.ADDRESS4 = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS4);
   AV_RELATE_E.CITY = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.CITY);
   AV_RELATE_E.STATE = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.STATE);
   AV_RELATE_E.COUNTY = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.COUNTY);
   AV_RELATE_E.POSTAL = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.POSTAL);
   AV_RELATE_E.COUNTRY = GetRelField(AV_RELATE_E.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.COUNTRY);
End-Function;

If %PanelGroup = PanelGroup.AV_RELATIONSHIPS_E Then
   If All(AV_RELATE_E.EXT_ORG_ID_RELATED) Then
      update_fields();
      gray_fields();
   Else
      SetDefault(AV_RELATE_E.DESCR);
      SetDefault(AV_RELATE_E.PHONE_DAY);
      SetDefault(AV_RELATE_E.PHONE_EVE);
      SetDefault(AV_RELATE_E.PHONE_FAX);
      SetDefault(AV_RELATE_E.ADDRESS1);
      SetDefault(AV_RELATE_E.ADDRESS2);
      SetDefault(AV_RELATE_E.ADDRESS3);
      SetDefault(AV_RELATE_E.ADDRESS4);
      SetDefault(AV_RELATE_E.CITY);
      SetDefault(AV_RELATE_E.STATE);
      SetDefault(AV_RELATE_E.COUNTY);
      SetDefault(AV_RELATE_E.POSTAL);
      SetDefault(AV_RELATE_E.COUNTRY);
      UnGray(AV_RELATE_E.DESCR);
      UnGray(AV_RELATE_E.PHONE_DAY);
      UnGray(AV_RELATE_E.PHONE_EVE);
      UnGray(AV_RELATE_E.PHONE_FAX);
      UnGray(AV_RELATE_E.ADDRESS1);
      UnGray(AV_RELATE_E.ADDRESS2);
      UnGray(AV_RELATE_E.ADDRESS3);
      UnGray(AV_RELATE_E.ADDRESS4);
      UnGray(AV_RELATE_E.CITY);
      UnGray(AV_RELATE_E.COUNTY);
      UnGray(AV_RELATE_E.POSTAL);
      UnGray(AV_RELATE_E.COUNTRY);
      UnGray(AV_RELATE_E.STATE);
      UnGray(SA_LBL_WRK.CITY_TOWN1_LBL);
      UnGray(SA_LBL_WRK.COUNTY_TOWN2_LBL);
      UnGray(SA_LBL_WRK.STATE_PROVINCE_LBL);
   End-If;
End-If;

PeopleCode (Record): AV_RELATE_EP_VW.ORG_RELATE_NBR.RowInit
If %PanelGroup = PanelGroup.AV_ORG_RELATION Or
      %PanelGroup = PanelGroup.AV_ORG_RELATION_W Then
   /* IF EMPLID EXISTS THEN DISPLAY VALUE FROM PERSONAL_DATA */
   /* - ELSE DISPLAY EXTERNAL ORG TABLE */
   If All(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED) Then
      If AV_RELATE_EP_VW.SA_ID_TYPE = "P" Then
         DERIVED_AV.AV_RELATION_NAME = PERSONAL_DATA.NAME;
      Else
         DERIVED_AV.AV_RELATION_NAME = EXT_ORG_TBL.DESCR;
         DERIVED_AV.AV_RELATION_NAME = AV_EXT_ORG_2_VW.NAME;
      End-If;
   Else
      If AV_RELATE_EP_VW.SA_ID_TYPE = "O" Then
         DERIVED_AV.AV_RELATION_NAME = AV_RELATE_EP_VW.DESCR;
      Else
         DERIVED_AV.AV_RELATION_NAME = AV_RELATE_O_VW.DESCR50;
      End-If;
   End-If;
   If AV_RELATE_EP_VW.SA_ID_TYPE = "P" Then
      DERIVED_AV.AV_RELATION_ROLE = AV_CTYP_MIN_VW.DESCR;
      DERIVED_AV.AV_RELATIONSHIPS = AV_PE_RLTN_TBL.PE_REL_DESCR;
   Else
      DERIVED_AV.AV_RELATION_ROLE = AV_CTYP_MINE_VW.DESCR;
      DERIVED_AV.AV_RELATIONSHIPS = AV_XL_O_REL_VW.XLATLONGNAME;
   End-If;
   DERIVED_AV.AV_RELATION_ST_DT = AV_RELATE_EP_VW.BEGIN_DT;
   DERIVED_AV.AV_RELATION_END_DT = AV_RELATE_EP_VW.END_DT;
   If All(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED) And
         AV_RELATE_EP_VW.SA_ID_TYPE = "O" Then
      AV_RELATE_EP_VW.DESCR = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.DESCR);
      AV_RELATE_EP_VW.ADDRESS1 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.ADDRESS1);
      AV_RELATE_EP_VW.ADDRESS2 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.ADDRESS2);
      AV_RELATE_EP_VW.ADDRESS3 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.ADDRESS3);
      AV_RELATE_EP_VW.ADDRESS4 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.ADDRESS4);
      AV_RELATE_EP_VW.CITY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.CITY);
      AV_RELATE_EP_VW.STATE = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.STATE);
      AV_RELATE_EP_VW.COUNTY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.COUNTY);
      AV_RELATE_EP_VW.POSTAL = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.POSTAL);
      AV_RELATE_EP_VW.COUNTRY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, EXT_ORG_TBL.COUNTRY);
      /*      &RELATE_DESCR = AV_ORG_DATA_VW.DESCR | " is"; 
      &RELATION_NAME = GetRelField(ORG_RELATION, AV_XL_O_REL_VW.XLATLONGNAME); 
      &FIRST_CHAR = Left(&RELATION_NAME, 1); 
      Evaluate &FIRST_CHAR 
      When = "A"  
      When = "a"  
      When = "E"  
      When = "e"  
      When = "I"  
      When = "i"  
      When = "O"  
      When = "o"  
      When = "U"  
      When = "u"  
         &RELATE_DESCR = &RELATE_DESCR | " an "; 
      When-Other 
         &RELATE_DESCR = &RELATE_DESCR | " a "; 
      End-Evaluate; 
      &RELATE_DESCR = &RELATE_DESCR | &RELATION_NAME | " of " | DESCR | " (" | AV_O_REL_RCP_VW.RELATIONSHIP_NAME | ")"; 
      DERIVED_AV_PO.DESCR100 = &RELATE_DESCR; */
      AV_RELATE_EP_VW.DESCR = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.NAME);
      AV_RELATE_EP_VW.ADDRESS1 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS1);
      AV_RELATE_EP_VW.ADDRESS2 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS2);
      AV_RELATE_EP_VW.ADDRESS3 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS3);
      AV_RELATE_EP_VW.ADDRESS4 = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.ADDRESS4);
      AV_RELATE_EP_VW.CITY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.CITY);
      AV_RELATE_EP_VW.STATE = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.STATE);
      AV_RELATE_EP_VW.COUNTY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.COUNTY);
      AV_RELATE_EP_VW.POSTAL = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.POSTAL);
      AV_RELATE_EP_VW.COUNTRY = GetRelField(AV_RELATE_EP_VW.EXT_ORG_ID_RELATED, AV_EXT_ORG_2_VW.COUNTRY);

   End-If;
End-If;

PeopleCode (Record): AV_RELATE_PE.EMPLID.FieldChange
Local Rowset &ADDR_RS, &RS_ORG_LOC, &RS_EXT_ORG;

Function gray_fields
   Gray(AV_RELATE_PE.DESCR);
   Gray(AV_RELATE_PE.ADDRESS1);
   Gray(AV_RELATE_PE.ADDRESS2);
   Gray(AV_RELATE_PE.ADDRESS3);
   Gray(AV_RELATE_PE.ADDRESS4);
   Gray(AV_RELATE_PE.CITY);
   Gray(AV_RELATE_PE.NUM1);
   Gray(AV_RELATE_PE.NUM2);
   Gray(AV_RELATE_PE.HOUSE_TYPE);
   Gray(AV_RELATE_PE.ADDR_FIELD1);
   Gray(AV_RELATE_PE.ADDR_FIELD2);
   Gray(AV_RELATE_PE.ADDR_FIELD3);
   Gray(AV_RELATE_PE.COUNTY);
   Gray(AV_RELATE_PE.POSTAL);
   Gray(AV_RELATE_PE.COUNTRY);
   Gray(AV_RELATE_PE.STATE);
   Gray(SA_LBL_WRK.CITY_TOWN1_LBL);
   Gray(SA_LBL_WRK.COUNTY_TOWN2_LBL);
   Gray(SA_LBL_WRK.STATE_PROVINCE_LBL);
End-Function;

Function gray_fields_ppl
   Gray(AV_RELATE_PE.NAME);
   Gray(AV_RELATE_PE.SEX);
   Gray(AV_RELATE_PE.SSN);
   Gray(AV_RELATE_PE.NAME_PREFIX);
   Gray(AV_RELATE_PE.NAME_SUFFIX);
   Gray(AV_RELATE_PE.ADDRESS1);
   Gray(AV_RELATE_PE.ADDRESS2);
   Gray(AV_RELATE_PE.ADDRESS3);
   Gray(AV_RELATE_PE.ADDRESS4);
   Gray(AV_RELATE_PE.CITY);
   Gray(AV_RELATE_PE.NUM1);
   Gray(AV_RELATE_PE.NUM2);
   Gray(AV_RELATE_PE.HOUSE_TYPE);
   Gray(AV_RELATE_PE.ADDR_FIELD1);
   Gray(AV_RELATE_PE.ADDR_FIELD2);
   Gray(AV_RELATE_PE.ADDR_FIELD3);
   Gray(AV_RELATE_PE.COUNTY);
   Gray(AV_RELATE_PE.POSTAL);
   Gray(AV_RELATE_PE.COUNTRY);
   Gray(AV_RELATE_PE.STATE);
   Gray(SA_LBL_WRK.CITY_TOWN1_LBL);
   Gray(SA_LBL_WRK.COUNTY_TOWN2_LBL);
   Gray(SA_LBL_WRK.STATE_PROVINCE_LBL);
End-Function;

Function update_fields
   AV_RELATE_PE.DESCR = GetRelField(AV_RELATE_PE.EXT_ORG_ID, EXT_ORG_TBL.DESCR);
   AV_RELATE_PE.DESCR = GetRelField(AV_RELATE_PE.EXT_ORG_ID, AV_EXT_ORG_2_VW.NAME);
   
   &ORG_LOCATION = GetRelField(AV_RELATE_PE.EXT_ORG_ID, EXT_ORG_TBL.ORG_LOCATION);
   &ORG_LOCATION = GetRelField(AV_RELATE_PE.EXT_ORG_ID, AV_EXT_ORG_2_VW.ORG_LOCATION);
   
   If Not All(&ORG_LOCATION) Then
      &ORG_LOCATION = 1;
   End-If;
   
   &RS_ORG_LOC = CreateRowset(Record.ORG_LOCATION_VW);
   &RS_ORG_LOC.Fill("WHERE EXT_ORG_ID = :1 AND ORG_LOCATION = :2", AV_RELATE_PE.EXT_ORG_ID, &ORG_LOCATION);
   
   If &RS_ORG_LOC.ActiveRowCount = 1 And
         All(&RS_ORG_LOC(1).ORG_LOCATION_VW.EXT_ORG_ID.Value) Then
      
      AV_RELATE_PE.ADDRESS1 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS1.Value;
      AV_RELATE_PE.ADDRESS2 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS2.Value;
      AV_RELATE_PE.ADDRESS3 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS3.Value;
      AV_RELATE_PE.ADDRESS4 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS4.Value;
      AV_RELATE_PE.CITY = &RS_ORG_LOC(1).ORG_LOCATION_VW.CITY.Value;
      AV_RELATE_PE.NUM1 = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM1.Value;
      AV_RELATE_PE.NUM2 = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM2.Value;
      AV_RELATE_PE.HOUSE_TYPE = &RS_ORG_LOC(1).ORG_LOCATION_VW.HOUSE_TYPE.Value;
      AV_RELATE_PE.ADDR_FIELD1 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD1.Value;
      AV_RELATE_PE.ADDR_FIELD2 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD2.Value;
      AV_RELATE_PE.ADDR_FIELD3 = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD3.Value;
      AV_RELATE_PE.STATE = &RS_ORG_LOC(1).ORG_LOCATION_VW.STATE.Value;
      AV_RELATE_PE.COUNTY = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTY.Value;
      AV_RELATE_PE.POSTAL = &RS_ORG_LOC(1).ORG_LOCATION_VW.POSTAL.Value;
      AV_RELATE_PE.COUNTRY = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTRY.Value;
   End-If;
   
End-Function;

Function populate_fields(&recRelationship As Record)
   
   If &recRelationship.Name = Record.AV_RELATE_PE Then
      &recRelationship.DESCR.Value = GetRelField(AV_RELATE_PE.EXT_ORG_ID, AV_EXT_ORG_2_VW.NAME);
      
      &ORG_LOCATION = GetRelField(AV_RELATE_PE.EXT_ORG_ID, AV_EXT_ORG_2_VW.ORG_LOCATION);
      
      If Not All(&ORG_LOCATION) Then
         &ORG_LOCATION = 1;
      End-If;
      
      &RS_ORG_LOC = CreateRowset(Record.ORG_LOCATION_VW);
      &RS_ORG_LOC.Fill("WHERE EXT_ORG_ID = :1 AND ORG_LOCATION = :2", AV_RELATE_PE.EXT_ORG_ID, &ORG_LOCATION);
      
      If &RS_ORG_LOC.ActiveRowCount = 1 And
            All(&RS_ORG_LOC(1).ORG_LOCATION_VW.EXT_ORG_ID.Value) Then
         
         &recRelationship.ADDRESS1.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS1.Value;
         &recRelationship.ADDRESS2.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS2.Value;
         &recRelationship.ADDRESS3.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS3.Value;
         &recRelationship.ADDRESS4.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS4.Value;
         &recRelationship.CITY.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.CITY.Value;
         &recRelationship.NUM1.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM1.Value;
         &recRelationship.NUM2.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM2.Value;
         &recRelationship.HOUSE_TYPE.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.HOUSE_TYPE.Value;
         &recRelationship.ADDR_FIELD1.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD1.Value;
         &recRelationship.ADDR_FIELD2.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD2.Value;
         &recRelationship.ADDR_FIELD3.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD3.Value;
         &recRelationship.STATE.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.STATE.Value;
         &recRelationship.COUNTY.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTY.Value;
         &recRelationship.POSTAL.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.POSTAL.Value;
         &recRelationship.COUNTRY.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTRY.Value;
      End-If;
   End-If;
End-Function;

Function update_fields_ppl
   AV_RELATE_PE.NAME = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME);
   AV_RELATE_PE.NAME_PREFIX = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME_PREFIX);
   AV_RELATE_PE.NAME_SUFFIX = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME_SUFFIX);
   AV_RELATE_PE.SEX = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.SEX);
   AV_RELATE_PE.SSN = GetRelField(AV_RELATE_PE.EMPLID, PERS_NID_VW.NATIONAL_ID);
   AV_RELATE_PE.ADDRESS1 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS1);
   AV_RELATE_PE.ADDRESS2 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS2);
   AV_RELATE_PE.ADDRESS3 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS3);
   AV_RELATE_PE.ADDRESS4 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS4);
   AV_RELATE_PE.CITY = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.CITY);
   AV_RELATE_PE.NUM1 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NUM1);
   AV_RELATE_PE.NUM2 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NUM2);
   AV_RELATE_PE.HOUSE_TYPE = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.HOUSE_TYPE);
   AV_RELATE_PE.ADDR_FIELD1 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD1);
   AV_RELATE_PE.ADDR_FIELD2 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD2);
   AV_RELATE_PE.ADDR_FIELD3 = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD3);
   AV_RELATE_PE.STATE = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.STATE);
   AV_RELATE_PE.COUNTY = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.COUNTY);
   AV_RELATE_PE.POSTAL = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.POSTAL);
   AV_RELATE_PE.COUNTRY = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.COUNTRY);
End-Function;

Function populate_fields_ppl(&recRelationship As Record)
   
   If &recRelationship.Name = Record.AV_RELATE_PE Then
      &recRelationship.GetField(Field.NAME).Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME);
      &recRelationship.NAME_PREFIX.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME_PREFIX);
      &recRelationship.NAME_SUFFIX.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NAME_SUFFIX);
      &recRelationship.SEX.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.SEX);
      &recRelationship.SSN.Value = GetRelField(AV_RELATE_PE.EMPLID, PERS_NID_VW.NATIONAL_ID);
      &recRelationship.ADDRESS1.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS1);
      &recRelationship.ADDRESS2.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS2);
      &recRelationship.ADDRESS3.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS3);
      &recRelationship.ADDRESS4.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDRESS4);
      &recRelationship.CITY.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.CITY);
      &recRelationship.NUM1.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NUM1);
      &recRelationship.NUM2.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.NUM2);
      &recRelationship.HOUSE_TYPE.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.HOUSE_TYPE);
      &recRelationship.ADDR_FIELD1.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD1);
      &recRelationship.ADDR_FIELD2.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD2);
      &recRelationship.ADDR_FIELD3.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.ADDR_FIELD3);
      &recRelationship.STATE.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.STATE);
      &recRelationship.COUNTY.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.COUNTY);
      &recRelationship.POSTAL.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.POSTAL);
      &recRelationship.COUNTRY.Value = GetRelField(AV_RELATE_PE.EMPLID, PERSONAL_DATA.COUNTRY);
   End-If;
End-Function;

Function update_fields_primary
   
   If %Component = Component.AV_RELATION_PE Then
      &ADDR_RS = CreateRowset(Record.ADDRESSES);
      &ADDR_RS.Fill("WHERE EMPLID = :1 AND ADDRESS_TYPE = :2 AND EFFDT = (SELECT MAX(B.EFFDT) FROM PS_ADDRESSES B WHERE B.EMPLID = FILL.EMPLID AND B.ADDRESS_TYPE = FILL.ADDRESS_TYPE AND B.EFFDT <=      %CurrentDateIn AND B.EFF_STATUS = 'A') ", AV_CONTEXT_WRK.EMPLID, "HOME");
      
      If &ADDR_RS.ActiveRowCount = 1 And
            All(&ADDR_RS(1).ADDRESSES.EMPLID.Value) Then
         DERIVED_AV_PO.ADDRESS1_OTHER = &ADDR_RS(1).ADDRESSES.ADDRESS1.Value;
         DERIVED_AV_PO.ADDRESS2_OTHER = &ADDR_RS(1).ADDRESSES.ADDRESS2.Value;
         DERIVED_AV_PO.ADDRESS3_OTHER = &ADDR_RS(1).ADDRESSES.ADDRESS3.Value;
         DERIVED_AV_PO.ADDRESS4_OTHER = &ADDR_RS(1).ADDRESSES.ADDRESS4.Value;
         DERIVED_AV_PO.CITY_OTHER = &ADDR_RS(1).ADDRESSES.CITY.Value;
         DERIVED_AV_PO.NUM1_OTHER = &ADDR_RS(1).ADDRESSES.NUM1.Value;
         DERIVED_AV_PO.NUM2_OTHER = &ADDR_RS(1).ADDRESSES.NUM2.Value;
         DERIVED_AV_PO.HOUSE_TYPE_OTHER = &ADDR_RS(1).ADDRESSES.HOUSE_TYPE.Value;
         DERIVED_AV_PO.ADDR_FIELD1_OTHER = &ADDR_RS(1).ADDRESSES.ADDR_FIELD1.Value;
         DERIVED_AV_PO.ADDR_FIELD2_OTHER = &ADDR_RS(1).ADDRESSES.ADDR_FIELD2.Value;
         DERIVED_AV_PO.ADDR_FIELD3_OTHER = &ADDR_RS(1).ADDRESSES.ADDR_FIELD3.Value;
         DERIVED_AV_PO.STATE_OTHER = &ADDR_RS(1).ADDRESSES.STATE.Value;
         DERIVED_AV_PO.COUNTY_OTHER = &ADDR_RS(1).ADDRESSES.COUNTY.Value;
         DERIVED_AV_PO.POSTAL_OTHER = &ADDR_RS(1).ADDRESSES.POSTAL.Value;
         DERIVED_AV_PO.COUNTRY_OTHER = &ADDR_RS(1).ADDRESSES.COUNTRY.Value;
      End-If;
   End-If;
   
   If %Component = Component.AV_RELATION_EP Then
      &RS_EXT_ORG = CreateRowset(Record.EXT_ORG_TBL);
      &RS_EXT_ORG.Fill("WHERE EXT_ORG_ID = :1 AND EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EXT_ORG_TBL B WHERE B.EXT_ORG_ID = FILL.EXT_ORG_ID AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A') ", AV_CONTEXT_WRK.EXT_ORG_ID);
      &RS_EXT_ORG.Fill("WHERE EXT_ORG_ID = :1 AND EFFDT = (SELECT MAX(B.EFFDT) FROM PS_EXT_ORG_TBL B WHERE B.EXT_ORG_ID = FILL.EXT_ORG_ID AND B.EFFDT <= %CurrentDateIn) ", AV_CONTEXT_WRK.EXT_ORG_ID);
      
      &ORG_LOCATION = &RS_EXT_ORG(1).EXT_ORG_TBL.ORG_LOCATION.Value;
      
      If Not All(&ORG_LOCATION) Then
         &ORG_LOCATION = 1;
      End-If;
      
      &RS_ORG_LOC = CreateRowset(Record.ORG_LOCATION_VW);
      &RS_ORG_LOC.Fill("WHERE EXT_ORG_ID = :1 AND ORG_LOCATION = :2", AV_RELATE_PE.EXT_ORG_ID, &ORG_LOCATION);
      
      If &RS_ORG_LOC.ActiveRowCount = 1 And
            All(&RS_ORG_LOC(1).ORG_LOCATION_VW.EXT_ORG_ID.Value) Then
         DERIVED_AV_PO.ADDRESS1_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS1.Value;
         DERIVED_AV_PO.ADDRESS2_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS2.Value;
         DERIVED_AV_PO.ADDRESS3_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS3.Value;
         DERIVED_AV_PO.ADDRESS4_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDRESS4.Value;
         DERIVED_AV_PO.CITY_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.CITY.Value;
         DERIVED_AV_PO.NUM1_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM1.Value;
         DERIVED_AV_PO.NUM2_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.NUM2.Value;
         DERIVED_AV_PO.HOUSE_TYPE_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.HOUSE_TYPE.Value;
         DERIVED_AV_PO.ADDR_FIELD1_OTHER.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD1.Value;
         DERIVED_AV_PO.ADDR_FIELD2_OTHER.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD2.Value;
         DERIVED_AV_PO.ADDR_FIELD3_OTHER.Value = &RS_ORG_LOC(1).ORG_LOCATION_VW.ADDR_FIELD3.Value;
         DERIVED_AV_PO.STATE_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.STATE.Value;
         DERIVED_AV_PO.COUNTY_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTY.Value;
         DERIVED_AV_PO.POSTAL_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.POSTAL.Value;
         DERIVED_AV_PO.COUNTRY_OTHER = &RS_ORG_LOC(1).ORG_LOCATION_VW.COUNTRY.Value;
      End-If;
   End-If;
   
End-Function;

Function gray_fields_primary
   DERIVED_AV_PO.ADDRESS1_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDRESS2_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDRESS3_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDRESS4_OTHER.Enabled = False;
   DERIVED_AV_PO.CITY_OTHER.Enabled = False;
   DERIVED_AV_PO.NUM1_OTHER.Enabled = False;
   DERIVED_AV_PO.NUM2_OTHER.Enabled = False;
   DERIVED_AV_PO.HOUSE_TYPE_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDR_FIELD1_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDR_FIELD2_OTHER.Enabled = False;
   DERIVED_AV_PO.ADDR_FIELD3_OTHER.Enabled = False;
   DERIVED_AV_PO.STATE_OTHER.Enabled = False;
   DERIVED_AV_PO.COUNTY_OTHER.Enabled = False;
   DERIVED_AV_PO.POSTAL_OTHER.Enabled = False;
   DERIVED_AV_PO.COUNTRY_OTHER.Enabled = False;
End-Function;

If %PanelGroup = PanelGroup.AV_RELATION_EP Then
   If All(AV_RELATE_PE.EMPLID) Then
      gray_fields_ppl();
      update_fields_ppl();
   Else
      SetDefault(AV_RELATE_PE.DESCR);
      SetDefault(AV_RELATE_PE.ADDRESS1);
      SetDefault(AV_RELATE_PE.ADDRESS2);
      SetDefault(AV_RELATE_PE.ADDRESS3);
      SetDefault(AV_RELATE_PE.ADDRESS4);
      SetDefault(AV_RELATE_PE.CITY);
      SetDefault(AV_RELATE_PE.NUM1);
      SetDefault(AV_RELATE_PE.NUM2);
      SetDefault(AV_RELATE_PE.HOUSE_TYPE);
      SetDefault(AV_RELATE_PE.ADDR_FIELD1);
      SetDefault(AV_RELATE_PE.ADDR_FIELD2);
      SetDefault(AV_RELATE_PE.ADDR_FIELD3);
      SetDefault(AV_RELATE_PE.STATE);
      SetDefault(AV_RELATE_PE.COUNTY);
      SetDefault(AV_RELATE_PE.POSTAL);
      SetDefault(AV_RELATE_PE.COUNTRY);
      SetDefault(AV_RELATE_PE.NAME);
      SetDefault(AV_RELATE_PE.SEX);
      SetDefault(AV_RELATE_PE.SSN);
      SetDefault(AV_RELATE_PE.NAME_PREFIX);
      SetDefault(AV_RELATE_PE.NAME_SUFFIX);
      UnGray(AV_RELATE_PE.NAME);
      UnGray(AV_RELATE_PE.SEX);
      UnGray(AV_RELATE_PE.SSN);
      UnGray(AV_RELATE_PE.NAME_PREFIX);
      UnGray(AV_RELATE_PE.NAME_SUFFIX);
      UnGray(AV_RELATE_PE.ADDRESS1);
      UnGray(AV_RELATE_PE.ADDRESS2);
      UnGray(AV_RELATE_PE.ADDRESS3);
      UnGray(AV_RELATE_PE.ADDRESS4);
      UnGray(AV_RELATE_PE.CITY);
      UnGray(AV_RELATE_PE.NUM1);
      UnGray(AV_RELATE_PE.NUM2);
      UnGray(AV_RELATE_PE.HOUSE_TYPE);
      UnGray(AV_RELATE_PE.ADDR_FIELD1);
      UnGray(AV_RELATE_PE.ADDR_FIELD2);
      UnGray(AV_RELATE_PE.ADDR_FIELD3);
      UnGray(AV_RELATE_PE.COUNTY);
      UnGray(AV_RELATE_PE.POSTAL);
      UnGray(AV_RELATE_PE.COUNTRY);
      UnGray(AV_RELATE_PE.STATE);
      UnGray(SA_LBL_WRK.CITY_TOWN1_LBL);
      UnGray(SA_LBL_WRK.COUNTY_TOWN2_LBL);
      UnGray(SA_LBL_WRK.STATE_PROVINCE_LBL);
   End-If;
End-If;

PeopleCode (Record): AV_RELATE_PE.PE_RELATE_NBR.SavePostChange
Declare Function update_fields_ppl PeopleCode AV_RELATE_PE.EMPLID FieldChange;
Declare Function update_fields PeopleCode AV_RELATE_PE.EMPLID FieldChange;

/* 
If %PanelGroup = PANELGROUP.AV_RELATION_PE Or 
      %PanelGroup = PANELGROUP.AV_CNST_RELATION Or 
      %PanelGroup = PANELGROUP.AV_CNST_RELATION_W Then 
   If All(EXT_ORG_ID) Then 
      update_fields(); 
   End-If; 
End-If; 
If %PanelGroup = PANELGROUP.AV_RELATION_EP Then 
   If All(EMPLID) Then 
      update_fields_ppl(); 
   End-If; 
End-If; 
*/

If %PanelGroup = PanelGroup.AV_RELATION_PE Then
   If All(AV_RELATE_PE.EXT_ORG_ID) Then
      update_fields();
   End-If;
End-If;
If %PanelGroup = PanelGroup.AV_RELATION_EP Then
   If All(AV_RELATE_PE.EMPLID) Then
      update_fields_ppl();
   End-If;
End-If;

PeopleCode (Record): AV_RUNCTL_GCLUB.AV_GCLUB_PRCS.FieldChange
If %Component = Component.AV_RUN_AVPGCLUB Then
   Evaluate AV_RUNCTL_GCLUB.AV_GCLUB_PRCS
   When = "U"
      HideScroll(Record.AV_RUNCTL_GCINT);
      Hide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   When = "A"
      HideScroll(Record.AV_RUNCTL_GCINT);
      UnHide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   When = "S"
      UnhideScroll(Record.AV_RUNCTL_GCINT);
      UnHide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   End-Evaluate;
End-If;

PeopleCode (Record): AV_RUNCTL_GCLUB.AV_GCLUB_PRCS.RowInit
If %Component = Component.AV_RUN_AVPGCLUB Then
   Evaluate AV_RUNCTL_GCLUB.AV_GCLUB_PRCS
   When = "U"
      HideScroll(Record.AV_RUNCTL_GCINT);
      Hide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   When = "A"
      HideScroll(Record.AV_RUNCTL_GCINT);
      UnHide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   When = "S"
      UnhideScroll(Record.AV_RUNCTL_GCINT);
      UnHide(AV_RUNCTL_GCLUB.AV_INC_MAN_MGD_MEM);
      Break;
   End-Evaluate;
End-If;

PeopleCode (Record): CLASS_SRCH_WRK2.CLASS_SRCH_PB.FieldChange
Declare Function edit_catalog_no PeopleCode FUNCLIB_CS.CATALOG_NBR FieldFormula;
Declare Function RemoveAccent PeopleCode NAMEGBL_SBR.COUNTRY_NM_FORMAT SavePreChange;
Declare Function RemoveAccent PeopleCode FUNCLIB_CS.PREFERRED_NAME FieldFormula;
Component Record &SAVEWRK2;
Component string &MORECRITERIA, &NORECORDS, &EMPLID, &PAGE;
Component boolean &RESULTS_FOUND, &DONT_SHOW_NO_PRINT;
Component number &LAM_Class_Nbr;
Local Rowset &CLASS_SRCH_RSLT;
Local Record &RSLT_REC, &WRK2;
Local number &REQUIRED;
Local boolean &SELECT_INSTR, &SELECT_MTG_DAY, &SELECT_MTG_TIME;

/* 
 * Have enough criteria been entered? 
 */
If All(CLASS_SRCH_WRK2.SUBJECT) Then
   &REQUIRED = &REQUIRED + 1
End-If;
If All(CLASS_SRCH_WRK2.CATALOG_NBR) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If CLASS_SRCH_WRK2.OPEN_ONLY = "O" Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If CLASS_SRCH_WRK2.OEE_IND = "Y" Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.CRSE_ID) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.CLASS_NBR) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.DESCR) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.COMPONENT) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.INSTRUCTION_MODE) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.ACAD_CAREER) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.SESSION_CODE) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If (CLASS_SRCH_WRK2.MON = "Y" Or
         CLASS_SRCH_WRK2.TUES = "Y" Or
         CLASS_SRCH_WRK2.WED = "Y" Or
         CLASS_SRCH_WRK2.THURS = "Y" Or
         CLASS_SRCH_WRK2.FRI = "Y" Or
         CLASS_SRCH_WRK2.SAT = "Y" Or
         CLASS_SRCH_WRK2.SUN = "Y") Then
   &SELECT_MTG_DAY = True;
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.MEETING_TIME_START) Then
   &SELECT_MTG_TIME = True;
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.MEETING_TIME_END) Then
   &SELECT_MTG_TIME = True;
   &REQUIRED = &REQUIRED + 1;
End-If;

RemoveAccent(Upper(CLASS_SRCH_WRK2.LAST_NAME), &lastname);
CLASS_SRCH_WRK2.LAST_NAME = &lastname;
If All(CLASS_SRCH_WRK2.LAST_NAME) Then
   &SELECT_INSTR = True;
   &REQUIRED = &REQUIRED + 1;
End-If;
RemoveAccent(Upper(CLASS_SRCH_WRK2.FIRST_NAME), &firstname);
CLASS_SRCH_WRK2.FIRST_NAME = &firstname;
If All(CLASS_SRCH_WRK2.FIRST_NAME) Then
   &SELECT_INSTR = True;
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(&EMPLID) Then
   &SELECT_INSTR = True;
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.CAMPUS) Then
   &REQUIRED = &REQUIRED + 1;
End-If;
If All(CLASS_SRCH_WRK2.LOCATION) Then
   &REQUIRED = &REQUIRED + 1;
End-If;

/* Hard-coded limit */
&CRITERIALIMIT = 2;
If &REQUIRED < &CRITERIALIMIT Then
   /* Enter more criteria */
   DERIVED_SR.DESCR254 = &MORECRITERIA;
   Exit
End-If;

/* 
 * Construct where clause based on search criteria entered.
 */
&WHERE = " WHERE INSTITUTION = '" | CLASS_SRCH_WRK2.INSTITUTION | "' AND STRM = '" | CLASS_SRCH_WRK2.STRM | "' AND CLASS_STAT = 'A'";
If All(CLASS_SRCH_WRK2.SUBJECT) Then
   &WHERE = &WHERE | " AND SUBJECT = '" | CLASS_SRCH_WRK2.SUBJECT | "'";
End-If;
If All(CLASS_SRCH_WRK2.CATALOG_NBR) Then
   If CLASS_SRCH_WRK2.EXACT_MATCH1 = "E" Then
      edit_catalog_no(CLASS_SRCH_WRK2.CATALOG_NBR);
      &quoteStr = Quote(CLASS_SRCH_WRK2.CATALOG_NBR);
      rem &WHERE = &WHERE | " AND CATALOG_NBR = '" | CATALOG_NBR | "'";
      &WHERE = &WHERE | " AND CATALOG_NBR  = " | &quoteStr;
   Else
      &quoteStr = Quote("%" | CLASS_SRCH_WRK2.CATALOG_NBR | "%");
      rem &WHERE = &WHERE | " AND CATALOG_NBR LIKE '%" | CATALOG_NBR | "%'";
      &WHERE = &WHERE | " AND CATALOG_NBR LIKE " | &quoteStr
   End-If;
End-If;
If CLASS_SRCH_WRK2.OPEN_ONLY = "O" Then
   &WHERE = &WHERE | " AND ENRL_STAT = '" | CLASS_SRCH_WRK2.OPEN_ONLY | "'";
End-If;
If CLASS_SRCH_WRK2.OEE_IND = "Y" Then
   &WHERE = &WHERE | " AND SESSION_CODE = 'OEE'";
End-If;
If All(CLASS_SRCH_WRK2.CRSE_ID) Then
   &WHERE = &WHERE | " AND CRSE_ID = '" | CLASS_SRCH_WRK2.CRSE_ID | "'";
End-If;
If All(CLASS_SRCH_WRK2.CLASS_NBR) Then
   &WHERE = &WHERE | " AND CLASS_NBR = " | CLASS_SRCH_WRK2.CLASS_NBR;
End-If;
If All(CLASS_SRCH_WRK2.DESCR) Then
   rem &WHERE = &WHERE | " AND %UPPER(DESCR) LIKE '%" | Upper(DESCR) | "%'";
   &quoteStr = Quote("%" | Upper(CLASS_SRCH_WRK2.DESCR) | "%");
   &WHERE = &WHERE | " AND %UPPER(DESCR) LIKE " | &quoteStr;
End-If;
If All(CLASS_SRCH_WRK2.COMPONENT) Then
   &WHERE = &WHERE | " AND COMPONENT = '" | CLASS_SRCH_WRK2.COMPONENT | "'";
End-If;
If All(CLASS_SRCH_WRK2.INSTRUCTION_MODE) Then
   &WHERE = &WHERE | " AND INSTRUCTION_MODE = '" | CLASS_SRCH_WRK2.INSTRUCTION_MODE | "'";
End-If;
If All(CLASS_SRCH_WRK2.ACAD_CAREER) Then
   &WHERE = &WHERE | " AND ACAD_CAREER = '" | CLASS_SRCH_WRK2.ACAD_CAREER | "'";
End-If;
If All(CLASS_SRCH_WRK2.SESSION_CODE) Then
   &WHERE = &WHERE | " AND SESSION_CODE = '" | CLASS_SRCH_WRK2.SESSION_CODE | "'";
End-If;
If All(CLASS_SRCH_WRK2.CAMPUS) Then
   &WHERE = &WHERE | " AND CAMPUS = '" | CLASS_SRCH_WRK2.CAMPUS | "'";
End-If;
If All(CLASS_SRCH_WRK2.LOCATION) Then
   &WHERE = &WHERE | " AND LOCATION = '" | CLASS_SRCH_WRK2.LOCATION | "'";
End-If;
If &DONT_SHOW_NO_PRINT Then
   &WHERE = &WHERE | " AND SCHEDULE_PRINT = 'Y'";
End-If;

/* Meeting Pattern Information */
If &SELECT_MTG_DAY Or
      &SELECT_MTG_TIME Then
   &WHERE = &WHERE | " AND EXISTS(SELECT CRSE_ID FROM PS_CLASS_SRCH_B B WHERE PS_CLASS_SRCH_A.CRSE_ID = B.CRSE_ID AND PS_CLASS_SRCH_A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND PS_CLASS_SRCH_A.STRM = B.STRM AND PS_CLASS_SRCH_A.SESSION_CODE = B.SESSION_CODE AND PS_CLASS_SRCH_A.CLASS_SECTION = B.CLASS_SECTION";
   If &SELECT_MTG_DAY Then
      /* Days select option */
      Evaluate CLASS_SRCH_WRK2.INCLUDE_CLASS_DAYS
         /* Include options */
      When "I"
      When "J"
         &WHERE = &WHERE | " AND (";
         If CLASS_SRCH_WRK2.INCLUDE_CLASS_DAYS = "I" Then
            &CONJ = "AND";
         Else
            &CONJ = "OR";
         End-If;
         Break;
      When "E"
      When "F"
         /* Exclude options */
         &WHERE = &WHERE | " AND NOT (";
         If CLASS_SRCH_WRK2.INCLUDE_CLASS_DAYS = "E" Then
            &CONJ = "AND";
         Else
            &CONJ = "OR";
         End-If;
      End-Evaluate;
      /* Days */
      If CLASS_SRCH_WRK2.MON = "Y" Then
         &WHERE = &WHERE | " B.MON = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.TUES = "Y" Then
         &WHERE = &WHERE | " B.TUES = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.WED = "Y" Then
         &WHERE = &WHERE | " B.WED = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.THURS = "Y" Then
         &WHERE = &WHERE | " B.THURS = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.FRI = "Y" Then
         &WHERE = &WHERE | " B.FRI = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.SAT = "Y" Then
         &WHERE = &WHERE | " B.SAT = 'Y' " | &CONJ;
      End-If;
      If CLASS_SRCH_WRK2.SUN = "Y" Then
         &WHERE = &WHERE | " B.SUN = 'Y' " | &CONJ;
      End-If;
      &WHERE = Left(&WHERE, Len(&WHERE) - 3) | ")";
   End-If;
   If &SELECT_MTG_TIME Then
      If All(CLASS_SRCH_WRK2.MEETING_TIME_START) Then
         &WHERE = &WHERE | " AND B.MEETING_TIME_START = %TimeIn('" | CLASS_SRCH_WRK2.MEETING_TIME_START | "')";
      End-If;
      If All(CLASS_SRCH_WRK2.MEETING_TIME_END) Then
         &WHERE = &WHERE | " AND B.MEETING_TIME_END = %TimeIn('" | CLASS_SRCH_WRK2.MEETING_TIME_END | "')";
      End-If;
   End-If;
   &WHERE = &WHERE | ")";
End-If;

/* Class Instructor Information */
If &SELECT_INSTR Then
   &WHERE = &WHERE | " AND EXISTS(SELECT CRSE_ID FROM PS_CLASS_SRCH_C C WHERE PS_CLASS_SRCH_A.CRSE_ID = C.CRSE_ID AND PS_CLASS_SRCH_A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND PS_CLASS_SRCH_A.STRM = C.STRM AND PS_CLASS_SRCH_A.SESSION_CODE = C.SESSION_CODE AND PS_CLASS_SRCH_A.CLASS_SECTION = C.CLASS_SECTION";
   If All(CLASS_SRCH_WRK2.LAST_NAME) Then
      If CLASS_SRCH_WRK2.EXACT_MATCH2 = "E" Then
         &WHERE = &WHERE | " AND C.LAST_NAME_SRCH = '" | Upper(CLASS_SRCH_WRK2.LAST_NAME) | "'";
      Else
         &WHERE = &WHERE | " AND C.LAST_NAME_SRCH LIKE '%" | Upper(CLASS_SRCH_WRK2.LAST_NAME) | "%'";
      End-If;
   End-If;
   If All(CLASS_SRCH_WRK2.FIRST_NAME) Then
      If CLASS_SRCH_WRK2.EXACT_MATCH3 = "E" Then
         &WHERE = &WHERE | " AND C.FIRST_NAME_SRCH = '" | Upper(CLASS_SRCH_WRK2.FIRST_NAME) | "'";
      Else
         &WHERE = &WHERE | " AND C.FIRST_NAME_SRCH LIKE '%" | Upper(CLASS_SRCH_WRK2.FIRST_NAME) | "%'";
      End-If;
   End-If;
   If All(&EMPLID) Then
      &WHERE = &WHERE | " AND C.EMPLID = '" | &EMPLID | "'";
   End-If;
   &WHERE = &WHERE | ")";
End-If;

/* Customize where clause for a component */
Evaluate %Component
When Component.LAM_CLASS_ACTV /* Gradebook Assignments */
   /* Different pages require joins with different records, to select only where valid data exists */
   Evaluate &PAGE
   When "LAM_CLASS_ACTIVITY"
      &WHERE = &WHERE | " AND EXISTS(SELECT STRM FROM PS_LAM_CLASS_ACTV D WHERE PS_CLASS_SRCH_A.STRM = D.STRM AND PS_CLASS_SRCH_A.CLASS_NBR = D.CLASS_NBR) ";
      Break;
      
   When "LAM_CLASS_TYPE_PER"
      &WHERE = &WHERE | " AND EXISTS(SELECT STRM FROM PS_LAM_CLAS_TYP_PR D WHERE PS_CLASS_SRCH_A.STRM = D.STRM AND PS_CLASS_SRCH_A.CLASS_NBR = D.CLASS_NBR) ";
      Break;
      
   When "LAM_CLASS_GRD_SCL"
      &WHERE = &WHERE | " AND EXISTS(SELECT STRM FROM PS_LAM_CLS_H_SCL D WHERE PS_CLASS_SRCH_A.STRM = D.STRM AND PS_CLASS_SRCH_A.CLASS_NBR = D.CLASS_NBR) ";
      Break;
      
   End-Evaluate;
   
When Component.LAM_CLASS_GRADE /* Access Gradebook */
   &WHERE = &WHERE | " AND CLASS_NBR <> " | &LAM_Class_Nbr;
   
End-Evaluate;

/*
 *If searching for Open Only classes, modify &WHERE clause to search for classes which are not Combined OR        
 *classes which are combined but combined section enrollment capacity has not been reached
 */
If CLASS_SRCH_WRK2.OPEN_ONLY = "O" Then
   &WHERE = &WHERE | " AND COMBINED_SECTION= ' ' " | " OR (" | Right(&WHERE, Len(&WHERE) - 6) | " AND COMBINED_SECTION IN ('C','S') AND CLASS_NBR IN (SELECT E.CLASS_NBR FROM PS_SCTN_CMBND E, PS_SCTN_CMBND_TBL F WHERE F.INSTITUTION=E.INSTITUTION AND F.STRM = E.STRM AND F.SESSION_CODE = E.SESSION_CODE AND F.SCTN_COMBINED_ID = E.SCTN_COMBINED_ID AND (F.ENRL_CAP-F.ENRL_TOT) > 0 AND F.INSTITUTION = '" | CLASS_SRCH_WRK2.INSTITUTION | "' AND F.STRM = '" | CLASS_SRCH_WRK2.STRM | "'))";
End-If;

/* Order by clause */
&ORDERBY = " ORDER BY SUBJECT, CATALOG_NBR, CLASS_SECTION";

/* 
 * How many rows were selected? 
 */
&COUNTSELECT = "SELECT COUNT(*) FROM PS_CLASS_SRCH_A ";
&COUNTSTRING = &COUNTSELECT | &WHERE;
SQLExec(&COUNTSTRING, &RECSREAD);

/* Hard-coded limit warning */
&COUNTLIMIT = 50;
If &RECSREAD > &COUNTLIMIT Then
   &RETURN = WinMessage(MsgGetText(14601, 122, "Message not found.", &COUNTLIMIT), 1, "");
   If &RETURN = 2 Then
      Exit
   End-If;
End-If;

/* No records found */
If &RECSREAD = 0 Then
   /* No records found */
   DERIVED_SR.DESCR254 = &NORECORDS;
   Exit;
End-If;

/* Save the search criteria */
&WRK2 = GetRecord();
&SAVEWRK2 = CreateRecord(Record.CLASS_SRCH_WRK2);
&WRK2.CopyFieldsTo(&SAVEWRK2);

/* Populate the results buffer */
&CLASS_SRCH_RSLT = GetLevel0()(1).GetRowset(Scroll.CLASS_SRCH_RSLT);
&CLASS_SRCH_RSLT.Flush();
&CLASS_SRCH_RSLT.Select(Record.CLASS_SRCH_A, &WHERE | &ORDERBY);

/* Only one row selected, populate the detail buffer */
If TotalRowCount(Record.CLASS_SRCH_RSLT) = 1 Then
   /* Detail pick list, load key value */
   &RSLT_REC = &CLASS_SRCH_RSLT.GetRow(1).GetRecord(Record.CLASS_SRCH_RSLT);
   CLASS_SRCH_WRK2.CRSE_ID = &RSLT_REC.CRSE_ID.Value;
   CLASS_SRCH_WRK2.CRSE_OFFER_NBR = &RSLT_REC.CRSE_OFFER_NBR.Value;
   CLASS_SRCH_WRK2.STRM = &RSLT_REC.STRM.Value;
   CLASS_SRCH_WRK2.SESSION_CODE = &RSLT_REC.SESSION_CODE.Value;
   CLASS_SRCH_WRK2.CLASS_SECTION = &RSLT_REC.CLASS_SECTION.Value;
   &CLASS_SRCH_DETL = GetLevel0()(1).GetRowset(Scroll.CLASS_SRCH_DETL);
   &CLASS_SRCH_DETL.Flush();
   &CLASS_SRCH_DETL.Select(Record.CLASS_SRCH_DETL, "WHERE CRSE_ID = :1 AND CRSE_OFFER_NBR = :2 AND STRM = :3 AND SESSION_CODE = :4 AND CLASS_SECTION = :5", CLASS_SRCH_WRK2.CRSE_ID, CLASS_SRCH_WRK2.CRSE_OFFER_NBR, CLASS_SRCH_WRK2.STRM, CLASS_SRCH_WRK2.SESSION_CODE, CLASS_SRCH_WRK2.CLASS_SECTION);
   /* Go to detail page */
   CLASS_SRCH_WRK2.TARGET_PAGE_NAME = "CLASS_SRCH_DETL";
   EndModal(1);
Else
   /* Go to results page */
   &RESULTS_FOUND = True;
   CLASS_SRCH_WRK2.TARGET_PAGE_NAME = "CLASS_SRCH_RSLT";
   EndModal(1);
End-If;

PeopleCode (Record): DERIVED_AV.AV_RELATION_NAME.FieldDefault
If %PanelGroup = PanelGroup.AV_CNST_RELATION Or
      %PanelGroup = PanelGroup.AV_CNST_RELATION_W Or
      %PanelGroup = PanelGroup.AV_PRSN_BIO_DEMO Or
      %PanelGroup = PanelGroup.AV_PRSN_PROFILE_W Then
If %Component = Component.AV_CNST_RELATION Or
      %Component = Component.AV_CNST_RELATION_W Or
      %Component = Component.AV_PRSN_BIO_DEMO Or
      %Component = Component.AV_PRSN_PROFILE_W Then
   If All(AV_RELATION_VW.EMPLID_RELATED) Then
      If AV_RELATION_VW.SA_ID_TYPE = "P" Then
         DERIVED_AV.AV_RELATION_NAME = PERSONAL_DATA.NAME;
      Else
         DERIVED_AV.AV_RELATION_NAME = EXT_ORG_TBL.DESCR;
      End-If;
   Else
      If All(AV_RELATION_VW.EXT_ORG_ID) And
            AV_RELATION_VW.SA_ID_TYPE <> "P" Then
         DERIVED_AV.AV_RELATION_NAME = AV_EXT_ORG_2_VW.NAME;
      Else
         If All(AV_RELATION_VW.NAME) Then
            DERIVED_AV.AV_RELATION_NAME = AV_RELATION_VW.NAME;
      Else
         DERIVED_AV.AV_RELATION_NAME = AV_EXT_ORG_2_VW.NAME;
         End-If;
      End-If;
   End-If;
End-If;

PeopleCode (Record): DERIVED_AV_GP.GCLUB_MBR_FETCH.RowInit
Declare Function fiscal_year PeopleCode FUNCLIB_AV.CALENDAR_ID FieldFormula;

Function gclub_tot_amts
   &ROWCOUNT = ActiveRowCount(Scroll.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GC_ML_SUM_VW);
   &ROWCOUNT2 = ActiveRowCount(Scroll.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GC_ML_CNT_VW);
   &TOTAMT = 0;
   &TOTAMT2 = 0;
   For &I = 1 To &ROWCOUNT
      &TOTAMT = FetchValue(Scroll.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GC_ML_SUM_VW, &I, AV_GC_ML_SUM_VW.GCLUB_MBR_AMT) + &TOTAMT;
   End-For;
   For &J = 1 To &ROWCOUNT2
      &TOTAMT2 = FetchValue(Scroll.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GC_ML_CNT_VW, &J, AV_GC_ML_CNT_VW.GCLUB_MBR_CNT) + &TOTAMT2;
   End-For;
   DERIVED_AV_GP.TTL_GIFT_AMT = &TOTAMT;
   DERIVED_AV_GP.TOTAL_CNT = &TOTAMT2;
End-Function;

Function gclub_mbr_smry
   ScrollFlush(Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR);
   &GCLUB_LVL = FetchValue(AV_GCLUB_LVL.GCLUB_LVL, CurrentRowNumber());
   RowScrollSelect(2, Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR, Record.AV_GCLUB_MBR, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND FISCAL_YEAR = :4 AND GCLUB_MBR_STATUS = 'M'", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_TBL.GCLUB_CD, &GCLUB_LVL, DERIVED_AV_GP.AV_FYR_LONG2);
   RowScrollSelect(2, Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR, Record.AV_GCLUB_MBR, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND FISCAL_YEAR = :4 AND (GCLUB_MBR_STATUS = 'M' OR GCLUB_MBR_STATUS = 'X')", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_TBL.GCLUB_CD, &GCLUB_LVL, DERIVED_AV_GP.AV_FYR_LONG2);
   ScrollSelect(2, Record.AV_GCLUB_LVL, Record.AV_GC_ML_CNT_VW, Record.AV_GC_ML_CNT_VW, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND FISCAL_YEAR = :4", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_LVL.GCLUB_CD, AV_GCLUB_LVL.GCLUB_LVL, DERIVED_AV_GP.AV_FYR_LONG2, True);
   ScrollSelect(2, Record.AV_GCLUB_LVL, Record.AV_GC_ML_SUM_VW, Record.AV_GC_ML_SUM_VW, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND FISCAL_YEAR = :4", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_LVL.GCLUB_CD, AV_GCLUB_LVL.GCLUB_LVL, DERIVED_AV_GP.AV_FYR_LONG2, True);
   gclub_tot_amts();
End-Function;

Function gclub_mbr_smry_nr
   ScrollFlush(Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR);
   &GCLUB_LVL = FetchValue(AV_GCLUB_LVL.GCLUB_LVL, CurrentRowNumber());
   RowScrollSelect(2, Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR, Record.AV_GCLUB_MBR, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND GCLUB_MBR_STATUS = 'M'", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_TBL.GCLUB_CD, &GCLUB_LVL);
   RowScrollSelect(2, Record.AV_GCLUB_LVL, CurrentRowNumber(), Record.AV_GCLUB_MBR, Record.AV_GCLUB_MBR, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 AND (GCLUB_MBR_STATUS = 'M' OR GCLUB_MBR_STATUS = 'X')", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_TBL.GCLUB_CD, &GCLUB_LVL);
   ScrollSelect(2, Record.AV_GCLUB_LVL, Record.AV_GC_ML_CNT_VW, Record.AV_GC_ML_CNT_VW, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 ", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_LVL.GCLUB_CD, AV_GCLUB_LVL.GCLUB_LVL, True);
   ScrollSelect(2, Record.AV_GCLUB_LVL, Record.AV_GC_ML_SUM_VW, Record.AV_GC_ML_SUM_VW, "WHERE INSTITUTION = :1 AND GCLUB_CD = :2 AND GCLUB_LVL = :3 ", AV_GCLUB_LVL.INSTITUTION, AV_GCLUB_LVL.GCLUB_CD, AV_GCLUB_LVL.GCLUB_LVL, True);
   gclub_tot_amts();
End-Function;

If (AV_GCLUB_TBL.GCLUB_RESET = "Y") Then
   Gray(DERIVED_AV_GP.GCLUB_MBR_FETCH);
   &YEAR = fiscal_year(%Date);
   DERIVED_AV_GP.AV_FYR_LONG2 = &YEAR;
   gclub_mbr_smry();
Else
   Hide(DERIVED_AV_GP.GCLUB_MBR_FETCH);
   Hide(DERIVED_AV_GP.AV_FYR_LONG2);
   gclub_mbr_smry_nr();
End-If;

PeopleCode (Record): DERIVED_AV_PO.ADDRESS_BTN.FieldChange
Declare Function populate_fields_ppl PeopleCode AV_RELATE_PE.EMPLID FieldChange;
Declare Function populate_fields PeopleCode AV_RELATE_PE.EMPLID FieldChange;

Component Record &recRelationship;

If %PanelGroup = PanelGroup.AV_RELATION_PE Or
      %PanelGroup = PanelGroup.AV_RELATION_EP Then
   
   &recRelationship = CreateRecord(Record.AV_RELATE_PE);
   Record.AV_RELATE_PE.CopyFieldsTo(&recRelationship);
   
   If %PanelGroup = PanelGroup.AV_RELATION_PE Then
      If All(AV_RELATE_PE.EXT_ORG_ID) Then
         /*populate the &recRelationship record with the address details of the related organization.
	  This record will be used to display the organizations address details */
         populate_fields(&recRelationship);
      End-If;
   End-If;
   
   If %PanelGroup = PanelGroup.AV_RELATION_EP Then
      If All(AV_RELATE_PE.EMPLID) Then
         /*populate the &recRelationship record with the address details of the related person.
	  This record will be used to display the person's address details */
         populate_fields_ppl(&recRelationship);
      End-If;
   End-If;
   
   DoModal(Page.AV_PE_REL_ADDR_SEC, "", - 1, - 1);
   
End-If;

PeopleCode (Record): DERIVED_AV_PO.AV_RLTN_RTRV.RowInit
Local Rowset &OrgRs;

If %PanelGroup = PanelGroup.AV_CNST_RELATION Or
      %PanelGroup = PanelGroup.AV_CNST_RELATION_W Or
      %PanelGroup = PanelGroup.AV_PRSN_BIO_DEMO Or
      %PanelGroup = PanelGroup.AV_PRSN_PROFILE_W Then
   ScrollFlush(Record.AV_RELATION_VW);
   ScrollSelect(1, Record.AV_RELATION_VW, Record.AV_RELATION_VW, "WHERE EMPLID = :1", AV_CONTEXT_WRK.EMPLID, True);
   ScrollSelect(1, Record.AV_RELATION_VW, Record.AV_RELATE_PE_VW, "WHERE EMPLID = :1", AV_CONTEXT_WRK.EMPLID, True);
End-If;
If %PanelGroup = PanelGroup.AV_ORG_RELATION Or
      %PanelGroup = PanelGroup.AV_ORG_RELATION_W Then
   ScrollFlush(Record.AV_RELATE_EP_VW);
   ScrollSelect(1, Record.AV_RELATE_EP_VW, Record.AV_RELATE_EP_VW, "WHERE EXT_ORG_ID = :1", AV_CONTEXT_WRK.EXT_ORG_ID, True);
   ScrollSelect(1, Record.AV_RELATE_EP_VW, Record.AV_RELATE_O_VW, "WHERE EXT_ORG_ID = :1", AV_CONTEXT_WRK.EXT_ORG_ID, True);
End-If;

If %PanelGroup = PanelGroup.AV_ORG_PROFILE Or
      %PanelGroup = PanelGroup.AV_ORG_PROFILE_W Then
   ScrollFlush(Record.AV_RELATE_O_VW);
   ScrollFlush(Record.AV_RELATE_EP_VW);
   
   ScrollSelect(1, Record.AV_RELATE_EP_VW, Record.AV_RELATE_EP_VW, "WHERE EXT_ORG_ID = :1", AV_CONTEXT_WRK.EXT_ORG_ID, True);
   ScrollSelect(1, Record.AV_RELATE_EP_VW, Record.AV_RELATE_O_VW, "WHERE EXT_ORG_ID = :1", AV_CONTEXT_WRK.EXT_ORG_ID, True);
   
   &OrgRs = GetLevel0()(1).GetRowset(Scroll.AV_RELATE_EP_VW);
   
   /* Once the scroll AV_RELATE_EP_VW is fully populated, the related person/org ID is stored in field EXT_ORG_ID_RELATED. */
   
   For &i = 1 To &OrgRs.ActiveRowCount
      If &OrgRs(&i).AV_RELATE_EP_VW.SA_ID_TYPE.Value = "P" Then
         &OrgRs(&i).DERIVED_AV.AV_RELATIONSHIPS.Value = &OrgRs(&i).AV_PE_RLTN_TBL.EP_REL_DESCR.Value;
         &OrgRs(&i).DERIVED_AV.AV_RELATION_ID.Value = &OrgRs(&i).AV_RELATE_EP_VW.EXT_ORG_ID_RELATED.Value;
         &OrgRs(&i).DERIVED_AV.AV_RELATION_ROLE.Value = &OrgRs(&i).AV_CTYP_MIN_VW.DESCR.Value;
      Else
         &OrgRs(&i).DERIVED_AV.AV_RELATIONSHIPS.Value = &OrgRs(&i).AV_XL_O_REL_VW.XLATLONGNAME.Value;
         &OrgRs(&i).DERIVED_AV.AV_RELATION_ID.Value = &OrgRs(&i).AV_RELATE_EP_VW.EXT_ORG_ID_RELATED.Value;
         &OrgRs(&i).DERIVED_AV.AV_RELATION_ROLE.Value = &OrgRs(&i).AV_CTYP_MINE_VW.DESCR.Value;
      End-If;
      
      If All(&OrgRs(&i).AV_RELATE_EP_VW.EXT_ORG_ID_RELATED.Value) Then
         If &OrgRs(&i).AV_RELATE_EP_VW.SA_ID_TYPE.Value = "P" Then
            &OrgRs(&i).DERIVED_AV.AV_RELATION_NAME.Value = &OrgRs(&i).GetRecord(Record.PERSONAL_DATA).GetField(Field.NAME).Value;
         Else
            &OrgRs(&i).DERIVED_AV.AV_RELATION_NAME.Value = &OrgRs(&i).EXT_ORG_TBL.DESCR.Value;
            &OrgRs(&i).DERIVED_AV.AV_RELATION_NAME.Value = &OrgRs(&i).AV_RELATE_EP_VW.EXT_ORG_ID_RELATED.GetRelated(AV_EXT_ORG_2_VW.NAME).Value;
         End-If;
      Else
         If &OrgRs(&i).AV_RELATE_EP_VW.SA_ID_TYPE.Value = "P" Then
            &OrgRs(&i).DERIVED_AV.AV_RELATION_NAME.Value = &OrgRs(&i).GetRecord(Record.AV_RELATE_EP_VW).GetField(Field.NAME).Value;
         Else
            &OrgRs(&i).DERIVED_AV.AV_RELATION_NAME.Value = &OrgRs(&i).AV_RELATE_EP_VW.DESCR.Value;
         End-If;
      End-If;
   End-For;
End-If;

PeopleCode (Record): DERIVED_GRANTS.SFA_ASG_FAT_AL_PB.FieldChange
If %Page = Page.SFA_ASG_ELIG Then
   DoModal(Page.SFA_ASG_ELIGAL_SEC, "HERA Academic Level on FA Term", - 1, - 1);
End-If;

PeopleCode (Record): FUNCLIB_SR.GRADE_ROSTER_STAT.FieldFormula
Component Rowset &Level0, &Grade_Roster_Type, &Grade_Roster, &Grade_Rstr_Note;
Local Row &LEVEL1_ROW;

Declare Function GR_Type_Common PeopleCode FUNCLIB_SR.GRADE_ROSTER_CMPNT FieldFormula;
Declare Function GR_Sort PeopleCode FUNCLIB_SR.GRADE_ROSTER_CMPNT FieldFormula;
Declare Function GR_Display_Data PeopleCode FUNCLIB_SR.GRADE_ROSTER_CMPNT FieldFormula;
Declare Function GR_Level2_Common_Data PeopleCode FUNCLIB_SR.GRADE_ROSTER_CMPNT FieldFormula;
Declare Function GR_Note PeopleCode FUNCLIB_SR.GRADE_ROSTER_CMPNT FieldFormula;

/*   Setting of GR fields for empty Grade Roster Type or when Insert is requested   */
Function Initial_GR_Type_Setup(&Drvr, &I_In)
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADE_ROSTER_TYPE.Enabled = True;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.DESCR.Enabled = True;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Visible = False;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.APPROVAL_DATE.Visible = False;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = False;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.POSTING_DATE.Visible = False;
   
   If &Drvr = "A" Then
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.GRADING_STATUS.Visible = False;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = False;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Visible = False;
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = False;
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Visible = False;
   End-If;
   
   &j_count_In = 0;
   GR_Level2_Common_Data(&Drvr, &j_count_In, &I_In);
   
   &OEE_Sw = "N";
   If &Drvr = "A" Then
      If GRADE_RSTR_SRCH.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If;
   Else
      If SS_GRADE_RSTSRC.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If
   End-If;
   If &OEE_Sw = "Y" Then
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = True;
   Else
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = False;
   End-If;
   
End-Function;

/* ========================================================== */

/*   Posted Roster = make all fields unavailable for update   */
Function Posted_Roster(&Drvr, &I_In, &j_count_In)
   
   /* Hide the +/- buttons - only works if only 1 row and that row is posted */
   &Grade_Roster_Type.DeleteEnabled = False;
   &Grade_Roster_Type.InsertEnabled = False;
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADE_ROSTER_TYPE.Enabled = False;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.DESCR.Enabled = False;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Enabled = False;
   If All(&Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.APPROVAL_DATE.Value) Then
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.APPROVAL_DATE.Visible = True;
   Else
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.APPROVAL_DATE.Visible = False;
   End-If;
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = True;
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.POSTING_DATE.Visible = True;
   
   If &Drvr = "A" Then
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.GRADING_STATUS.Visible = True;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = False;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Visible = False;
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = False;
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Visible = False;
   End-If;
   
   /*  Sort Grade Roster Data  */
   If &j_count_In > 0 Then
      GR_Sort(&Drvr);
   End-If;
   
   /* Make the Grade Roster Data unavailable */
   
   GR_Level2_Common_Data(&Drvr, &j_count_In, &I_In);
   If &j_count_In > 0 Then
      For &j_func = 1 To &j_count_In
         /* Call common Data hide/unhide logic */
         GR_Display_Data(&Drvr, &j_count_In, &I_In, &j_func);
         &Grade_Roster(&j_func).GRADE_ROSTER.CRSE_GRADE_INPUT.Enabled = False;
         &Grade_Roster(&j_func).GRADE_ROSTER.RQMNT_DESIGNTN_GRD.Enabled = False;
         
         /* Make the Grade Roster Note unavailable */
         &Grade_Roster(&j_func).GRADE_ROSTER.TSCRPT_NOTE_ID.Enabled = False;
         &LEVEL1_ROW = &Grade_Roster(&j_func);
         &Grade_Rstr_Note = &LEVEL1_ROW.GetRowset(Scroll.GRADE_RSTR_NOTE);
         &Grade_Rstr_Note.DeleteEnabled = False;
         &Grade_Rstr_Note.InsertEnabled = False;
         For &k_func = 1 To &Grade_Rstr_Note.ActiveRowCount
            &Grade_Rstr_Note(&k_func).GRADE_RSTR_NOTE.TSCRPT_NOTE_SEQ.Enabled = False;
            &Grade_Rstr_Note(&k_func).GRADE_RSTR_NOTE.TSCRPT_NOTE254.Enabled = False;
         End-For;
         
      End-For;
   End-If;
   
End-Function;

/* ========================================================== */

/*   "Unposted" Final Roster   */
Function Final_Roster(&Drvr, &I_In, &j_count_In)
   
   /*  Handle common fields for Final and Midterm Roster at Level 1  */
   GR_Type_Common(&Drvr, &I_In);
   
   If &Drvr = "A" Then
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = True;
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.GRADING_STATUS.Visible = False;
   Else
      If &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Value = "ERR" Then
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = True;
      Else
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = False;
      End-If;
   End-If;
   
   If &Drvr = "A" Then
      If &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Value = "NRVW" Then
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = True;
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Enabled = True;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = True;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Enabled = True;
      Else
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = False;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = False;
      End-If;
      
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Visible = True;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Visible = True;

      If DERIVED_CS.GRADE_RSTR_ACCESS = "P" Then
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Enabled = True;
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Enabled = True;
      Else
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Enabled = False;
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Enabled = False;
      End-If;
   Else
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.DERIVED_LINK.Visible = True;
   End-If;
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.POSTING_DATE.Visible = False;
   
   &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.DSP_UNGRD_ONLY.Visible = True;
   &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SSR_DSP_UNGRD_LBL.Visible = True;
   
   &OEE_Sw = "N";
   If &Drvr = "A" Then
      If GRADE_RSTR_SRCH.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If;
   Else
      If SS_GRADE_RSTSRC.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If
   End-If;
   If &OEE_Sw = "Y" Then
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = True;
   Else
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = False;
   End-If;
   
   /*  Sort Grade Roster Data  */
   If &j_count_In > 0 Then
      GR_Sort(&Drvr);
   End-If;
   /* Handle the Grade Roster Data Fields */
   GR_Level2_Common_Data(&Drvr, &j_count_In, &I_In);
   If &j_count_In > 0 Then
      For &j_func = 1 To &j_count_In
         /* Call common Data hide/unhide logic */
         GR_Display_Data(&Drvr, &j_count_In, &I_In, &j_func);
         If &j_count_In > 0 Then
            &Grade_Roster(&j_func).GRADE_ROSTER.GRADE_ROSTER_STAT.Visible = True;
            If (All(&Grade_Roster(&j_func).STDNT_ENRL.CRSE_GRADE_OFF.Value)) Or
                  (&Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Value <> "NRVW") Then
               &Grade_Roster(&j_func).GRADE_ROSTER.CRSE_GRADE_INPUT.Enabled = False;
            Else
               &Grade_Roster(&j_func).GRADE_ROSTER.CRSE_GRADE_INPUT.Enabled = True;
            End-If;
            If (&Grade_Roster(&j_func).STDNT_ENRL.RQMNT_DESIGNTN_OPT.Value = "Y") And
                  (&Grade_Roster(&j_func).RQMNT_DESIG_TBL.SEPARATE_CRSE_GRD.Value = "Y") And
                  (None(&Grade_Roster(&j_func).STDNT_ENRL.RQMNT_DESIGNTN_GRD.Value)) And
                  (&Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Value = "NRVW") Then
               &Grade_Roster(&j_func).GRADE_ROSTER.RQMNT_DESIGNTN_GRD.Enabled = True;
            Else
               &Grade_Roster(&j_func).GRADE_ROSTER.RQMNT_DESIGNTN_GRD.Enabled = False;
            End-If;
            
            /* Handle the Grade Roster Note  */
            GR_Note(&Drvr, &I_In, &j_func);
         End-If;
      End-For;
   End-If;
End-Function;

/* ========================================================== */

/*   "Unposted" MidTerm Roster   */
Function MidTerm_Roster(&Drvr, &I_In, &j_count_In)
   
   /*  Handle common fields for Final and Midterm Roster at Level 1  */
   GR_Type_Common(&Drvr, &I_In);
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GRADING_STATUS.Visible = False;
   &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.GRADING_STATUS.Visible = False;
   
   If &Drvr = "A" Then
      If &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Value = "NRVW" Then
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = True;
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Enabled = True;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = True;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Enabled = True;
      Else
         &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.OVRD_GRADE_ROSTER.Visible = False;
         &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_CREATE_PB.Visible = False;
      End-If;
      
      &Grade_Roster_Type(&I_In).DERIVED_CS.GRD_RSTR_POST_PB.Visible = False;
      &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.PARTIAL_POST.Visible = False;
   Else
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.DERIVED_LINK.Visible = False;
   End-If;
   
   &Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.POSTING_DATE.Visible = False;
   
   &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.DSP_UNGRD_ONLY.Visible = True;
   &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SSR_DSP_UNGRD_LBL.Visible = True;
   
   &OEE_Sw = "N";
   If &Drvr = "A" Then
      If GRADE_RSTR_SRCH.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If;
   Else
      If SS_GRADE_RSTSRC.SESSION_CODE.Value = "OEE" Then
         &OEE_Sw = "Y";
      End-If
   End-If;
   If &OEE_Sw = "Y" Then
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = True;
   Else
      &Grade_Roster_Type(&I_In).DERIVED_SR_RSTR.SORT_OPTION_SA.Visible = False;
   End-If;
   
   /*  Sort Grade Roster Data  */
   If &j_count_In > 0 Then
      GR_Sort(&Drvr);
   End-If;
   /* Handle the Grade Roster Data Fields */
   GR_Level2_Common_Data(&Drvr, &j_count_In, &I_In);
   If &j_count_In > 0 Then
      For &j_func = 1 To &j_count_In
         &Grade_Roster(&j_func).GRADE_ROSTER.GRADE_ROSTER_STAT.Visible = False;
         /* Call common Data hide/unhide logic */
         GR_Display_Data(&Drvr, &j_count_In, &I_In, &j_func);
         If (&Grade_Roster_Type(&I_In).GRADE_RSTR_TYPE.GR_APPROVAL_STATUS.Value <> "NRVW") Then
            &Grade_Roster(&j_func).GRADE_ROSTER.CRSE_GRADE_INPUT.Enabled = False;
         Else
            &Grade_Roster(&j_func).GRADE_ROSTER.CRSE_GRADE_INPUT.Enabled = True;
         End-If;
         &Grade_Roster(&j_func).GRADE_ROSTER.RQMNT_DESIGNTN_GRD.Visible = False;
         
         /* Handle the Grade Roster Note  */
         GR_Note(&Drvr, &I_In, &j_func);
      End-For;
   End-If;
End-Function;

PeopleCode (Record): SFA_ASG_FATALVW.SFA_ASG_WI_USED.RowInit
If SFA_ASG_FATALVW.SFA_ASG_WI_USED = "Y" Then
   SFA_ASG_FATALVW.SFA_ASG_WI_USED.Visible = True;
   SFA_ASG_FATALVW.SFA_ASG_WI_CUM_BOT.Visible = True;
   SFA_ASG_FATALVW.SFA_ASG_WI_CUM_EOT.Visible = True;
   DERIVED_FA_LBLP.NOT_APPLICABLE_LBL.Visible = True;
Else
   SFA_ASG_FATALVW.SFA_ASG_WI_USED.Visible = False;
   SFA_ASG_FATALVW.SFA_ASG_WI_CUM_BOT.Visible = False;
   SFA_ASG_FATALVW.SFA_ASG_WI_CUM_EOT.Visible = False;
   DERIVED_FA_LBLP.NOT_APPLICABLE_LBL.Visible = False;
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_MTH.FieldChange
If %Component = Component.STDNT_FA_TERM Then
   If STDNT_FA_TERM.SFA_ASG_WI_MTH <> STDNT_FA_TERM.SFA_ASG_WI_MTH_CL Then
      STDNT_FA_TERM.SFA_ASG_WI_MTH_OVR = "Y";
      STDNT_FA_TERM.FA_STATS_CALC_REQ = "Y";
   Else
      STDNT_FA_TERM.SFA_ASG_WI_MTH_OVR = "N";
   End-If;
   If STDNT_FA_TERM.SFA_ASG_WI_MTH = "L" Then
      STDNT_FA_TERM.SFA_ASG_WI_TRM.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TCR.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR.Enabled = False;
      If All(STDNT_FA_TERM.SFA_ASG_WI_TRM) Or
            All(STDNT_FA_TERM.SFA_ASG_WI_TCR) Then
         MessageBox(0, "", 14400, 457, "Message 14400,457: Data Entered will not be use to determine HERA Level.");
      End-If;
   Else
      STDNT_FA_TERM.SFA_ASG_WI_TRM.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TCR.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR.Enabled = True;
   End-If;
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_MTH.RowInit
If %Component = Component.STDNT_FA_TERM Then
   If STDNT_FA_TERM.SFA_ASG_WI_MTH = "L" Then
      STDNT_FA_TERM.SFA_ASG_WI_TRM.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TCR.Enabled = False;
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR.Enabled = False;
   Else
      STDNT_FA_TERM.SFA_ASG_WI_TRM.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TCR.Enabled = True;
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR.Enabled = True;
   End-If;
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_MTH_CL.SaveEdit
If STDNT_FA_TERM.SFA_ASG_WI_MTH_OVR = "Y" Then
   STDNT_FA_TERM.FA_STATS_CALC_REQ = "Y";
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_TCR.FieldChange
If %Component = Component.STDNT_FA_TERM Then
   If STDNT_FA_TERM.SFA_ASG_WI_TCR <> STDNT_FA_TERM.SFA_ASG_WI_TCR_CL Then
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR = "Y";
   Else
      STDNT_FA_TERM.SFA_ASG_WI_TCR_OVR = "N";
   End-If;
   
   If STDNT_FA_TERM.SFA_ASG_WI_MTH = "L" Then
      MessageBox(0, "", 14400, 456, "Message 14400,456: Data Entered will not be use to determine HERA Level.");
   End-If;
   
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_TRM.FieldChange
If %Component = Component.STDNT_FA_TERM Then
   If STDNT_FA_TERM.SFA_ASG_WI_TRM <> STDNT_FA_TERM.SFA_ASG_WI_TRM_CL Then
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR = "Y";
   Else
      STDNT_FA_TERM.SFA_ASG_WI_TRM_OVR = "N";
   End-If;
   
   If STDNT_FA_TERM.SFA_ASG_WI_MTH = "L" Then
      Warning MsgGet(14400, 456, "Message 14400,456: Data Entered will not be use to determine HERA Level.");
   End-If;
   
End-If;

PeopleCode (Record): STDNT_FA_TERM.SFA_ASG_WI_USED.RowInit
If %Component = Component.STDNT_FA_TERM Then
   If STDNT_FA_TERM.SFA_ASG_WI_USED = "Y" Then
      STDNT_FA_TERM.SFA_ASG_WI_USED.Visible = True;
      STDNT_FA_TERM.SFA_ASG_WI_CUM_BOT.Visible = True;
      STDNT_FA_TERM.SFA_ASG_WI_CUM_EOT.Visible = True;
      DERIVED_FA_LBLP.NOT_APPLICABLE_LBL.Visible = True;
   Else
      STDNT_FA_TERM.SFA_ASG_WI_USED.Visible = False;
      STDNT_FA_TERM.SFA_ASG_WI_CUM_BOT.Visible = False;
      STDNT_FA_TERM.SFA_ASG_WI_CUM_EOT.Visible = False;
      DERIVED_FA_LBLP.NOT_APPLICABLE_LBL.Visible = False;
   End-If;
End-If;