BO_IDRA_ATTRIB_SEQDefault Value: %date
OLM_JOB_HIST2(SQL View) |
Index Back |
|---|---|
Profile Job History 1A view of JOB, which is one of the core records in the HR database. Used for CRM Profiles. View 1 of 3. Uses subrecord. |
| SELECT B.BO_ID , A.EMPL_RCD * 1000 + A.EFFSEQ , A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , %subrec(OLM_JOBHST2_SBR, A) , MATRICULA_NBR FROM PS_JOB A , PS_RD_PERSON B WHERE A.EMPLID = B.EMPLID AND A.EFFDT =( SELECT MAX (C.EFFDT ) FROM PS_JOB C WHERE A.EMPLID=C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND A.EFFSEQ = C.EFFSEQ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | RA_ATTRIB_SEQ |
Number(31,0) | DECIMAL(31) NOT NULL | Profile / attribute sequence numbers |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | RA_EMPL_RCD | Number(18,0) | DECIMAL(18) NOT NULL | Character field copy of EMPL_REC used by marketing profiles due to numeric limitations. |
| 5 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | RA_EFFSEQ | Number(18,0) | DECIMAL(18) NOT NULL | Character field copy of EFFSEQ used by marketing profiles due to numeric limitations. |
| 7 | TARIFF_GER | Character(2) | VARCHAR2(2) NOT NULL | Tariff |
| 8 | TARIFF_AREA_GER | Character(3) | VARCHAR2(3) NOT NULL | Tarif Area |
| 9 | PERFORM_GROUP_GER | Character(2) | VARCHAR2(2) NOT NULL | Performance Group |
| 10 | LABOR_TYPE_GER | Character(1) | VARCHAR2(1) NOT NULL | Labor Type |
| 11 | SPK_COMM_ID_GER | Character(9) | VARCHAR2(9) NOT NULL | Spokesman Committee ID |
| 12 | WRKS_CNCL_MEM_GER | Character(3) | VARCHAR2(3) NOT NULL | Works Council Member |
| 13 | HOURLY_RT_FRA | Character(3) | VARCHAR2(3) NOT NULL | Hours Type |
| 14 | ACCDNT_CD_FRA | Character(1) | VARCHAR2(1) NOT NULL | Work Accident Type Code |
| 15 | VALUE_1_FRA | Character(5) | VARCHAR2(5) NOT NULL | Value 1 |
| 16 | VALUE_2_FRA | Character(5) | VARCHAR2(5) NOT NULL | Value 2 |
| 17 | VALUE_3_FRA | Character(5) | VARCHAR2(5) NOT NULL | Value 3 |
| 18 | VALUE_4_FRA | Character(5) | VARCHAR2(5) NOT NULL | Value 4 |
| 19 | VALUE_5_FRA | Character(5) | VARCHAR2(5) NOT NULL | Value 5 |
| 20 | ACTION_ITA | Character(3) | VARCHAR2(3) NOT NULL | Turnover - Action |
| 21 | ACTION_REASON_ITA | Character(3) | VARCHAR2(3) NOT NULL | Turnover Action Reason |
| 22 | WRKS_CNCL_FUNCTION | Character(1) | VARCHAR2(1) NOT NULL | Works Council Function |
| 23 | INTERCTR_WRKS_CNCL | Character(1) | VARCHAR2(1) NOT NULL | InterCtr.Works Cnil Function |
| 24 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Pay Group |
| 25 | GP_DFLT_ELIG_GRP | Character(1) | VARCHAR2(1) NOT NULL | Use Pay Group Value |
| 26 | GP_ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | Eligibility Group |
| 27 | GP_DFLT_CURRTTYP | Character(1) | VARCHAR2(1) NOT NULL | Use Pay Group Value |
| 28 | GP_DFLT_EXRTDT | Character(1) | VARCHAR2(1) NOT NULL | Use Pay Group Value |
| 29 | GP_ASOF_DT_EXG_RT | Character(1) | VARCHAR2(1) NOT NULL | Use Rate As Of |
| 30 | BORDER_WALKER | Character(1) | VARCHAR2(1) NOT NULL | Indicating whether a worker is a cross Border Worker. |
| 31 | WRKS_CNCL_ROLE_CHE | Character(30) | VARCHAR2(30) NOT NULL | Work Council Role |
| 32 | WRKS_CNCL_ID_LCL | Character(9) | VARCHAR2(9) NOT NULL | Works Council ID |
| 33 | RA_MATRICULA_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Character version of MATRICULA_NBR Field - used by profiles. Profile number size must be 18 - if not then either create a number 18 or a character field to hold the value. Character field copy of MATRICULA_NBR used by marketing profiles due to numeric limitations. |