GM_CONT_ETHNIC

(SQL Table)
Index Back

Gender and Minority

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

Prompt Table: GM_PROP_ID_VW

3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

Prompt Table: GM_PROPOSAL

4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR

Prompt Table: GM_PROP_PROJ

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

6 ETHNIC_TYPE Character(1) VARCHAR2(1) NOT NULL Ethnic Type
1=American Indian/Alaskan Native
2=Asian
3=Black or African American
4=Native Hawaiian or Pacific Is
5=White
6=More Than One Race
7=Unknown or not reported
A=Hispanic -Amer Indian/Alaskan
B=Hispanic -Asian
C=Hispanic -Black/African Americ
D=Hispanic -Hawaiian/Pacific Is
E=Hispanic -White
F=Hispanic -More Than One Race
G=Hispanic -Unknown/not Reported
7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
8 NBR_OF_SUBJECTS Number(4,0) SMALLINT NOT NULL No. Of Subjects
9 NEW_DATA Character(1) VARCHAR2(1) NOT NULL New Data

Y/N Table Edit

Default Value: N