SCC_DUR_AFL_OVR (SQL Table)	Index Back
Data Update Rules Affil Ovrd Stores the Data Update Rule Affiliation Overrides. These rules will be used to "override" the current rule if the Constituent has an active Affiliation for the Institution specified. Order must be specified - it will be used in cases where the consitutent has more than 1active affiliations.

SCC_DUR_AFL_OVR

(SQL Table)

Data Update Rules Affil Ovrd

Stores the Data Update Rule Affiliation Overrides. These rules will be used to "override" the current rule if the Constituent has an active Affiliation for the Institution specified. Order must be specified - it will be used in cases where the consitutent has more than 1active affiliations.

Parent record: SCC_DUR_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_DUR_ID Character(30) VARCHAR2(30) NOT NULL Data Update Rule
Prompt Table: SCC_DUR_HDR

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

3 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
Prompt Table: SCC_AFL_LVS_VW

4 SCC_DUR_ID_AFLOVRD Character(30) VARCHAR2(30) NOT NULL Affiliation Override Rule ID
Prompt Table: SCC_DUR_HDR

5 SCC_DUR_ORDER Number(4,0) SMALLINT NOT NULL Sort Order

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_DUR_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Update Rule Prompt Table: SCC_DUR_HDR
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
3	SCC_AFL_CODE	Character(10)	VARCHAR2(10) NOT NULL	Affiliations Code Prompt Table: SCC_AFL_LVS_VW
4	SCC_DUR_ID_AFLOVRD	Character(30)	VARCHAR2(30) NOT NULL	Affiliation Override Rule ID Prompt Table: SCC_DUR_HDR
5	SCC_DUR_ORDER	Number(4,0)	SMALLINT NOT NULL	Sort Order