HR_ROST_CANR_VW(SQL View) |
Index Back |
|---|---|
HR - Candidate List ViewRoster Candidate List View for Recall and Reinstatement. |
| SELECT R.LBR_ROSTER_ID ,RD.EFFDT ,A.EMPLID ,A.EMPL_RCD ,B.EFFSEQ ,R.LBR_EVENT_TYPE ,0 ,'N' ,%DateNull ,%DateNull ,' ' ,'N' ,'N' ,'N' ,RD.GB_GROUP_ID ,B.JOBCODE ,B.POSITION_NBR ,'N' ,B.LABOR_FACILITY_ID ,B.LOCATION ,B.DEPTID ,B.SHIFT ,B.FTE ,B.STD_HOURS ,B.EMPL_CLASS ,B.REG_TEMP ,B.FULL_PART_TIME ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,%DateNull ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,%DateTimeNull ,%OperatorId FROM PS_EMPLOYMENT A ,PS_JOB B , PS_HR_LBR_ROSTER R ,PS_HR_LBR_ROSTDATA RD ,PS_HR_ROST_GRP_RES G WHERE A.EMPLID = G.EMPLID AND A.EMPL_RCD = G.EMPL_RCD AND RD.GB_GROUP_ID = G.GB_GROUP_ID AND R.LBR_ROSTER_ID = RD.LBR_ROSTER_ID AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = G.JOB_EFFDT AND B.EFFSEQ = G.JOB_EFFSEQ AND B.EFFSEQ = ( SELECT MAX(D.EffSeq) FROM PS_JOB D WHERE D.EmplID = B.EmplID AND D.EMPL_RCD = B.EMPL_RCD AND D.EffDt = B.EffDt) AND B.EFFDT=( SELECT MAX(EFFDT) FROM PS_JOB J WHERE J.EMPLID=B.EMPLID AND J.EMPL_RCD=B.EMPL_RCD AND J.EFFDT<=%CurrentDateIn ) AND G.VERSIONGBQDM = ( SELECT MAX(G2.VERSIONGBQDM) FROM PS_HR_ROST_GRP_RES G2 WHERE G.GB_GROUP_ID = G2.GB_GROUP_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LBR_ROSTER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Roster ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | LBR_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
L=Layoff R=Recall |
| 7 | LBR_EMP_RANK | Number(6,0) | INTEGER NOT NULL | Employee Rank |
| 8 | LBR_TIE_APPLIED | Character(1) | VARCHAR2(1) NOT NULL |
TieBreaker Applied
Y/N Table Edit Default Value: N |
| 9 | REHIRE_DT | Date(10) | DATE | Rehire Date |
| 10 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 11 | LBR_EMP_ROST_STAT | Character(11) | VARCHAR2(11) NOT NULL |
Employee Roster Status
Prompt Table: HR_LBR_EEST_TBL |
| 12 | LOADED_TO_JOB | Character(1) | VARCHAR2(1) NOT NULL | Loaded to Job |
| 13 | LBR_LOADED_RCL_RGT | Character(1) | VARCHAR2(1) NOT NULL |
Loaded Recall Rights
Y/N Table Edit Default Value: N |
| 14 | COMPLETE_STS_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates a complete and successful status. |
| 15 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 16 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 17 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 18 | MANUAL_SW | Character(1) | VARCHAR2(1) NOT NULL | Manual Switch |
| 19 | LABOR_FACILITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Labor Facility ID |
| 20 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 21 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 22 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating |
| 23 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 24 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 25 | EMPL_CLASS | Character(3) | VARCHAR2(3) NOT NULL | Employee Classification |
| 26 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 27 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 28 | LBR_SNR_DT1_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date1 ID |
| 29 | LBR_SNR_DT1 | Date(10) | DATE | Seniority Date1 |
| 30 | LBR_SNR_DT2_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date2 ID |
| 31 | LBR_SNR_DT2 | Date(10) | DATE | Seniority Date2 |
| 32 | LBR_SNR_DT3_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date3 ID |
| 33 | LBR_SNR_DT3 | Date(10) | DATE | Seniority Date3 |
| 34 | LBR_SNR_DT4_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date4 ID |
| 35 | LBR_SNR_DT4 | Date(10) | DATE | Seniority Date4 |
| 36 | LBR_SNR_DT5_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date5 ID |
| 37 | LBR_SNR_DT5 | Date(10) | DATE | Seniority Date5 |
| 38 | LBR_SNR_DT6_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date6 ID |
| 39 | LBR_SNR_DT6 | Date(10) | DATE | Seniority Date6 |
| 40 | LBR_SNR_DT7_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date7 ID |
| 41 | LBR_SNR_DT7 | Date(10) | DATE | Seniority Date7 |
| 42 | LBR_SNR_DT8_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date8 ID |
| 43 | LBR_SNR_DT8 | Date(10) | DATE | Seniority Date8 |
| 44 | LBR_SNR_DT9_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date9 ID |
| 45 | LBR_SNR_DT9 | Date(10) | DATE | Seniority Date9 |
| 46 | LBR_SNR_DT10_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date10 ID |
| 47 | LBR_SNR_DT10 | Date(10) | DATE | Seniority Date10 |
| 48 | LBR_SNR_DT11_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date11 ID |
| 49 | LBR_SNR_DT11 | Date(10) | DATE | Seniority Date11 |
| 50 | LBR_SNR_DT12_ID | Character(11) | VARCHAR2(11) NOT NULL | Seniority Date12 ID |
| 51 | LBR_SNR_DT12 | Date(10) | DATE | Seniority Date12 |
| 52 | LBR_TIEBRK1_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID1 |
| 53 | LBR_TIEBRK1_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker1 Value |
| 54 | LBR_TIEBRK2_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID2 |
| 55 | LBR_TIEBRK2_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker2 Value |
| 56 | LBR_TIEBRK3_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID3 |
| 57 | LBR_TIEBRK3_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker3 Value |
| 58 | LBR_TIEBRK4_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID4 |
| 59 | LBR_TIEBRK4_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker4 Value |
| 60 | LBR_TIEBRK5_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID5 |
| 61 | LBR_TIEBRK5_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker5 Value |
| 62 | LBR_TIEBRK6_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID6 |
| 63 | LBR_TIEBRK6_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker6 Value |
| 64 | LBR_TIEBRK7_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID7 |
| 65 | LBR_TIEBRK7_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker7 Value |
| 66 | LBR_TIEBRK8_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID8 |
| 67 | LBR_TIEBRK8_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker8 Value |
| 68 | LBR_TIEBRK9_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID9 |
| 69 | LBR_TIEBRK9_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker9 Value |
| 70 | LBR_TIEBRK10_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID1 |
| 71 | LBR_TIEBRK10_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker10 Value |
| 72 | LBR_TIEBRK11_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID11 |
| 73 | LBR_TIEBRK11_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker11 Value |
| 74 | LBR_TIEBRK12_ID | Character(11) | VARCHAR2(11) NOT NULL | TieBreaker ID12 |
| 75 | LBR_TIEBRK12_VAL | Character(60) | VARCHAR2(60) NOT NULL | Tiebreaker12 Value |
| 76 | LASTUPDDTTM | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %date |
| 77 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |