HR_LAY_TEMP_VW(SQL View) |
Index Back |
---|---|
HR - Layoff Prompt Record.Prompt Record for Layoff to be used in Recall/Reinstatement Roster. |
SELECT A.LBR_ROSTER_ID , B.EFFDT , B.DESCR50 , B.LBR_ROSTER_TYPE , B.SETID , B.LABOR_AGREEMENT FROM PS_HR_LBR_ROSTER A , PS_HR_LBR_ROSTDATA B WHERE A.LBR_EVENT_TYPE = 'L' AND A.LBR_ROST_STATUS_CD <> '010' AND B.LBR_ROSTER_TYPE = 'TEMP' AND B.LBR_ROSTER_ID = A.LBR_ROSTER_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HR_LBR_ROSTDATA C WHERE C.LBR_ROSTER_ID = B.LBR_ROSTER_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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
4 | LBR_ROSTER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Roster Type
PERM=Permanent RECL=Recall REIN=Reinstatement TEMP=Temporary Prompt Table: HR_LAY_TYP_VW |
5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
6 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: EMPL_CTG_L1_VW |