EMPLIDMANDATE_END_DATEELECTION_TYPECE=Work Council
DP=Staff Representative
ESTABIDPrompt Table: ESTAB_EMPLOY_VW
MANDATES_FRA(SQL Table) |
Index Back |
|---|---|
Professional Mandates - FRAThis table is used to store the mandates of an employee. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | MANDATE_END_DATE |
Date(10) | DATE NOT NULL | Mandate End Date |
| 3 | ELECTION_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Mandate Type
CE=Work Council DP=Staff Representative |
| 4 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_EMPLOY_VW |
| 5 | MANDATE_BEGIN_DATE | Date(10) | DATE | Mandate Begin Date |
| 6 | HOURS_CREDIT_FRA | Number(3,0) | SMALLINT NOT NULL | Hours Credited |