CBR_JOB_VW(SQL View) |
Index Back |
|---|---|
JOB View for COBRAThis is a partial view of the Job Data record used by COBRA Administration Panels. It has been created to screen out the peoplecode on Job Data from triggering. This view does not have to be kept in sync with the Job Data record since it only contains selected fields. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.BUSINESS_UNIT ,A.SETID_DEPT ,A.DEPTID ,A.SETID_LOCATION ,A.LOCATION ,A.COMPANY ,A.COBRA_ACTION ,A.PAY_SYSTEM_FLG ,A.BENEFIT_SYSTEM FROM PS_JOB A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |
| 6 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department Set ID
Default Value: OPR_DEF_TBL_HR.SETID |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 8 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 11 | COBRA_ACTION | Character(3) | VARCHAR2(3) NOT NULL | Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only. |
| 12 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 13 | BENEFIT_SYSTEM | Character(2) | VARCHAR2(2) NOT NULL |
A flag that indicates whether the benefits for an employee are administered under PeopleSoft Benefits Administration or PeopleSoft Base Benefits.
BA=Benefits Administration BN=Base Benefits OT=Not Managed in PeopleSoft |