JOB_CNT_BEL_VW(SQL View) |
Index Back |
|---|---|
View on CONTRACT by EMPL_RCDView on CONTRACT DATA and WKF_CNT_TYPE by JOB Employment Rcd, used for Belgium in the Notification component. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.CONTRACT_NUM ,B.REG_REGION ,B.CONTRACT_BEGIN_DT ,C.CONTRACT_TYPE ,C.STATUTE_BEL ,C.SUBSTATUTE_BEL ,A.COMPANY ,A.STD_HOURS ,A.STD_HRS_FREQUENCY ,A.HOURLY_RT ,A.MONTHLY_RT ,A.ANNUAL_RT ,A.COMPRATE ,A.CURRENCY_CD ,A.COMP_FREQUENCY FROM PS_JOB A , PS_CONTRACT_DATA B , PS_WKF_CNT_TYPE C WHERE B.EMPLID = A.EMPLID AND B.CONTRACT_NUM = A.CONTRACT_NUM AND C.EMPLID = A.EMPLID AND C.CONTRACT_NUM = A.CONTRACT_NUM AND A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT) AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_WKF_CNT_TYPE C1 WHERE C1.EMPLID = C.EMPLID AND C1.CONTRACT_NUM = C.CONTRACT_NUM AND C1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 4 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 5 | CONTRACT_BEGIN_DT | Date(10) | DATE |
Contract Begin Date
Default Value: %Date |
| 6 | CONTRACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table: PERS_CNTRCT_TYP |
| 7 | STATUTE_BEL | Character(2) | VARCHAR2(2) NOT NULL |
Statute
Prompt Table: STATUTE_TBL_BEL |
| 8 | SUBSTATUTE_BEL | Character(2) | VARCHAR2(2) NOT NULL |
Substatute
00=Not Applicable 01=Regular Employee 02=Sales Representative 03=Executive Prompt Table: SUBSTAT_TBL_BEL |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 11 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 12 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 13 | MONTHLY_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Monthly Rate |
| 14 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 15 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly |