MIXED_COMM_ID_MEXEFFDTYEAR_MEXSEQUENCE_NBR0010=Objective
0020=Function
0030=Mechanism
0040=Other
Default Value: 0010
MIX_COM_OBJ_MEX(SQL Table) |
Index Back |
|---|---|
Mixed Committee ObjectiveContain the Objectives for The mixed Committee 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 |
| 3 | YEAR_MEX |
Character(4) | VARCHAR2(4) NOT NULL | Objective Date Mexico |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | OBJECTIVE_TYPE_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Objective Type Mexico
0010=Objective 0020=Function 0030=Mechanism 0040=Other Default Value: 0010 |
| 6 | OBJECTIVE_MEX | Character(30) | VARCHAR2(30) NOT NULL | Mixed Committee Objective Mexico |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |