MIXED_COMM_ID_MEXEFFDTDefault Value: %date
EMPLIDPrompt Table: PERS_SRCH_GBL
STATUS_DATE_MEXDefault Value: %date
A=Active
I=Inactive
Default Value: A
0010=Employee
0020=Employer
Default Value: 0010
MIX_COM_REP_MEX(SQL Table) |
Index Back |
|---|---|
Mixed Committee RepresentativeMixed Committee Representative for Mexico |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MIXED_COMM_ID_MEX |
Character(12) | VARCHAR2(12) NOT NULL | Mixed Committee ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 4 | STATUS_DATE_MEX |
Date(10) | DATE NOT NULL |
Status Date Mexico
Default Value: %date |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 6 | REP_TYPE_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Representative Type Mexico.
0010=Employee 0020=Employer Default Value: 0010 |