GPBR_H08_TMP(SQL Table) |
Index Back |
---|---|
Homolognet Temporary Table 08Homolognet Temporary Table 08 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
3 | TERMINATION_DT | Date(10) | DATE | Termination Date |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
8 | DATE_YEAR_VAL | Number(4,0) | SMALLINT NOT NULL | Date Year Value |
9 | DATE_MONTH_VAL | Number(2,0) | SMALLINT NOT NULL | Date Month Value |
10 | GPBR_SALARY_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Salary Type for GP Brazil
01=Calendar Days 02=30 days Monthly Basis |
11 | GPBR_FIX_SAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Fixed Salary Type |
12 | CONT_SAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |