UPG_CONV_HR75(SQL Table) |
Index Back |
|---|---|
Conversion HR ParametersConversion HR Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 4 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table: SETID_TBL |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
| 7 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 8 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table: REG_REGION_TBL |
| 9 | REG_REGION_DUP | Character(5) | VARCHAR2(5) NOT NULL |
Clone from Regulatory Region
Prompt Table: REG_REGION_TBL |
| 10 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 12 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department Set ID
Prompt Table: SETID_TBL |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 14 | JOB_REQ_NBR | Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 15 | DEFAULT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Default Set ID
Prompt Table: SETID_TBL |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 17 | INDUSTRY | Character(4) | VARCHAR2(4) NOT NULL |
Industry
CORE=Core EDUC=Education FNSV=Financial Services GOVT=Government HLTH=Health Care RETL=Retail TRAN=Transportation UTIL=Utilities |
| 18 | INDUSTRY_SECTOR | Character(4) | VARCHAR2(4) NOT NULL |
Industry Sector
CORE=Core PBSC=Public Sector USFG=US Federal Government |
| 19 | JOB_REQ_NBR_OTH | Character(6) | VARCHAR2(6) NOT NULL | Job Requisition # |