UNION_CDPrompt Table: UNION_TBL
EFFDTDefault Value: %date
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
UNION_TBL_BRA(SQL Table) |
Index Back |
|---|---|
Union Table for BrazilUnion Table for Brazil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNION_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Union Code
Prompt Table: UNION_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | UNION_TYPE_BRA | Character(20) | VARCHAR2(20) NOT NULL | Union Type, or Category for HR Brazil |
| 4 | MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
| 5 | UNION_CNPJ_BRA | Character(14) | VARCHAR2(14) NOT NULL | Union CNPJ, this is the ID that all the companies/establishments in Brazil have. |
| 6 | UNION_CODE_BRA | Character(20) | VARCHAR2(20) NOT NULL | Brazil Union Code |
| 7 | DAYCD_BRA | Character(2) | VARCHAR2(2) NOT NULL | Day - Collective Agreement |