EMPLIDDefault Value: PERSON.EMPLID
RECEIVEDTDefault Value: %date
N=No
Y=Yes
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
CAN_OEE_SURVEY(SQL Table) |
Index Back |
|---|---|
Can OEE Workforce SurveyThis is the Canadian Employment Equity Workforce survey record. Employees are entitled to fill out a survey when they are first employed, when they wish to change their previous responses, and every subsequent nine years. Therefore, historical data is required. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID |
| 2 | RECEIVEDT |
Date(10) | DATE NOT NULL |
Date Survey Received
Default Value: %date |
| 3 | COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Completed
N=No Y=Yes Y/N Table Edit Default Value: N |
| 4 | ABORIGINAL | Character(1) | VARCHAR2(1) NOT NULL |
Aboriginal
Y/N Table Edit Default Value: N |
| 5 | MINORITY | Character(1) | VARCHAR2(1) NOT NULL |
Minority
Y/N Table Edit Default Value: N |
| 6 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit Default Value: N |
| 7 | FEMALE | Character(1) | VARCHAR2(1) NOT NULL |
Female
Y/N Table Edit Default Value: N |