Page Name

Description:

Identifies the person by female or male classification.

Coding Instructions:

Code 'X' (Not Reported) is invalid for employees.

Correspondence students (01267 = 0) will not be included in the Critical/Tolerance editing of value 'X' (Not Reported) on the SIF.

These submissions do not require a PERSON_DEMO table record unless a change is being made to a particular demographic element. SUDS will attempt to match the PERSON_ID submitted on all tables of these submissions to PERSON_DEMO information previoiusly submitted according to the following scheme:
HTD --> SIF
CPC --> SIF
LAP --> SIF then ADM
TEF --> SIF
SFA --> SIF
SIFD --> SIF
RET --> SIF

Load programs on PERSON_DEMO table will NULL value of 'not reported'.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

10-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Admissions (ADM)	PERSON_DEMO (DEMO)	GENDER	41	2203	1	Admissions
Admissions (ADM)	PERSON_DEMO (DEMO)	GENDER_NEW	41	2203	1	Admissions
Admissions (ADM)	PERSON_ID_CHGS (IDC)	GENDER	41	43	48	Admissions
Admissions (ADM)	PERSON_ID_CHGS (IDC)	GENDER_NEW	41	43	48	Admissions
College Prep (CP)	PERSON_DEMO (DEMO)	GENDER	41	2203	1	College Prep
College Prep (CP)	PERSON_DEMO (DEMO)	GENDER_NEW	41	2203	1	College Prep
College Prep (CP)	PERSON_ID_CHGS (IDC)	GENDER	41	43	48	College Prep
College Prep (CP)	PERSON_ID_CHGS (IDC)	GENDER_NEW	41	43	48	College Prep
College Prep Completions (CPC)	PERSON_DEMO (DEMO)	GENDER	41	2203	1	College Prep Completions
College Prep Completions (CPC)	PERSON_DEMO (DEMO)	GENDER_NEW	41	2203	1	College Prep Completions

1 - 10

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'F	F	Female
'M	M	Male

Download

1 - 3

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
ADM	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
ADM	PERSON_DEMO	0007	Missing	8	Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
ADM	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
ADM	PERSON_DEMO	5807	Tolerance exceeded for missing value	9	Critical Error: may cause submission to be rejected
ADM	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
ADM	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
EMPL	EMPLOYEE_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
HTD	PERSON_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
HTD	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
HTD	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
HTD	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
IRD	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
IRD	WORKLOAD_PERSON_FUNDING	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_PERSON_FUNDING	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
IRD	WORKLOAD_PERSON_FUNDING	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
RET	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
RET	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
RET	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
RET	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
SCD	EMPLOYEE_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
SFA	PERSON_DEMO	0008	Missing or Invalid Value	9	Critical Error: may cause submission to be rejected
SFA	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
SFA	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
SFA	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
SIF	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
SIF	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
SIF	PERSON_DEMO	5268	Missing for non-correspondence student	8	Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
SIF	PERSON_DEMO	5806	Tolerance exceeded for Diagnostic Code 5268 - missing value for non-correspondence student	9	Critical Error: may cause submission to be rejected
SIF	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
SIF	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
SIFD	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
SIFD	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
SIFD	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
SIFP	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
SIFP	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
SIFP	PERSON_DEMO	5268	Missing for non-correspondence student	8	Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
SIFP	PERSON_DEMO	5806	Tolerance exceeded for Diagnostic Code 5268 - missing value for non-correspondence student	9	Critical Error: may cause submission to be rejected
SIFP	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
SIFP	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error
TEI	PERSON_DEMO	0005	Invalid Value	9	Critical Error: may cause submission to be rejected
TEI	PERSON_DEMO	0007	Missing	8	Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
TEI	PERSON_DEMO	4048	Frequency of Values for PERSON_DEMO.GENDER	0	Frequency Distribution: not an indication of an error
TEI	PERSON_DEMO	6069	GENDER is nulled if = 'X'	1	Generated or Modified during SUDS Edit Process
TEI	PERSON_ID_CHGS	4042	Frequency of Values for PERSON_ID_CHGS.GENDER	0	Frequency Distribution: not an indication of an error

1 - 46

Physical Description:

VARCHAR2(1)

Short Name:

GENDER

Column Name:

GENDER

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Gender - 01048

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: