STANDARD-OCCUPATION-CLASS

DWH Archive Name: B__STNDRD_OCCUP_CLASS

Defines the Standard Occupation Classification codes used for higher education reporting (IPEDS, ADHE, CUPA, etc.).

Data Element Definitions for STANDARD-OCCUPATION-CLASS (U-81)

Type & Level		Field Name & Attributes	Format & Length		Comp Opt	Index	Field Definition
Primary Identifier
	1	SOC-CD DB=FA CS=HR	A	7.0	N	U	The Standard Occupation Classification code used for higher education reporting (IPEDs, ADHE, CUPA, etc.). In most situations it relates directly to the University's OCC-CD. In other cases the value will remain blank on the Occupation table meaning the value must be defined by Position. These exception conditions are defined on the Position-SOC-Exception file.
Descriptive Information
	1	SOC-SHORT-DESC DB=FB CS=HR	A	30.0	N		A short description (30 characters) for a Standard Occupation Classification Code. This value is used primarily on 3270 screens where space is not available to display the long description.
	1	SOC-LONG-DESC DB=FC CS=HR	A	60.0	N		A long description of a Standard Occupation Classfication code. This value is used primarily in batch reporting.
Other Attributes
	1	SOC-CATEGORY DB=FD CS=HR	A	2.0	N		A category associated with a Standard Occupation Classification. This value is used to group and order SOC Codes for reporting as needed by the University.
	1	SOC-GA-CD DB=FF CS=HR	A	1.0	N		A code used to identify the Standard Occupation Classifications which are allowed to be associated with a Graduate Assistant (GA). Possible values are: Y = Allowed for GAs or N = Not allowed for GAs (stored on the data base as blank).
Alternate index
SP	1	CATEGORY-SOC-KEY DB=F1 CS=*	A	9.0	N	D	The super-descriptor composed of SOC-Category and SOC-Cd. This index is used to control maintenance of Categories (to know they can be deleted when the last reference to that Category has been removed).
System Maintained Values
	1	SOC-SHORT-DESC-UC DB=FE CS=*	A	30.0	N	D	The system maintained upper case version of the SOC-Short-Desc, used for searching and ordering SOC Codes.
PE	1	AUDIT-GROUP DB=AC CS=* HD=__AUDIT_GRP					DWH Archive Name: B__STNDRD_OCCUP_CLASS__AUDIT_GRP The periodic repeating group used to record audit information. Occurrences represent the following activity: 1 = Initial creation or 2 = Last update.
	2	TIME-OF-UPDATE DB=AD CS=UA HD=Date/Updated PE=AUDIT-GROUP	T		N		Date and time that a record or associated item was last updated on the data base.
	2	UPDATED-BY-USER DB=AE CS=UA HD=Updated/ By PE=AUDIT-GROUP	A	8.0	N		The Natural user ID (USER-ID) of the last user to update a record or associated item.
	1	TIME-STAMP DB=AA CS=UA HD=Time Stamp	B	8.0	F		This field is used to uniquely identify each update to a record. Each time a record is updated, this field should be assigned the value of the Natural function *TIMESTMP. Programs should check to see if this field has changed from the time they first read a record until the time they read the record with hold. This will determine if someone else has altered the record.