FMLA_JOB_VW(SQL View) |
Index Back |
|---|---|
Vw-Job data used by FMLAThis view of Job data is used by the FMLA module as the source for a hidden work scroll. The view assists in retrieving information about an employee's complete Job history for use in determining eligibility for FMLA protected leave. |
| SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.STD_HOURS ,F.FREQUENCY_TYPE ,F.FREQ_ANNUAL_FACTOR ,J.EMPL_STATUS FROM PS_JOB J , PS_FREQUENCY_TBL F WHERE J.EFFSEQ= ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID=J.EMPLID AND EFFDT=J.EFFDT) AND J.PER_ORG='EMP' AND F.FREQUENCY_ID=J.STD_HRS_FREQUENCY AND F.EFFDT= ( SELECT MAX(EFFDT) FROM PS_FREQUENCY_TBL WHERE FREQUENCY_ID=F.FREQUENCY_ID AND EFFDT<=J.EFFDT) |
| # | 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 | JOB_EFFDT |
Date(10) | DATE | Job Effective Date |
| 4 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 5 | FREQUENCY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the type of a frequency ID.
A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 6 | FREQ_ANNUAL_FACTOR | Number(12,7) | DECIMAL(11,7) NOT NULL | Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year. |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |