CNT_TYP_ECD_BRA(SQL Table) | 
Index Back | 
|---|---|
Contr. Type Def. by Empl ClassLegal Contract Type Definition by Employee Class used in TRCT report for Brazil. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
SetID
 Prompt Table: SETID_TBL  | 
|
| 2 | Date(10) | DATE | 
Effective Date
 Default Value: %date  | 
|
| 3 | Character(3) | VARCHAR2(3) NOT NULL | 
Employee Classification
 Prompt Table: EMPL_CLASS_TBL  | 
|
| 4 | CONTRACT_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL | 
Legal Contract Type
 1=1-Indeterminate Period 2=2-Defined Period with clause 3=3-Defined Period w/out clause Default Value: 1  | 
| 5 | CONTRCT_DFLT_BRA | Character(1) | VARCHAR2(1) NOT NULL | 
Indeterminate contract type after end of determinate period. Only applicable for Determinate Contract Type.
 Y/N Table Edit Default Value: N  |