HR_LBR_ROSTDATA (SQL Table)	Index Back
HR - Roster Data. Maintains the effective dated record for Layoff/Recall Rosters. Multiple Effective dated Roster Data records can be created for a Roster.

HR_LBR_ROSTDATA

(SQL Table)

HR - Roster Data.

Maintains the effective dated record for Layoff/Recall Rosters. Multiple Effective dated Roster Data records can be created for a Roster.

Related Language Record: HR_LBR_ROST_LNG

Parent record: HR_LBR_ROSTER

# 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 NOT NULL 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
Default Value: TEMP
Prompt Table: HR_LAY_TYP_VW

5 LBR_ROST_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Mass Update to be used?
Y/N Table Edit
Default Value: N

6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: GB_GROUP_SEC_VW

7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

8 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
Prompt Table: EMPL_CTG_L1_VW

9 LBR_PROP_TERM_DT Date(10) DATE Proposed Termination Date

10 LBR_MULT_TERMDT Character(1) VARCHAR2(1) NOT NULL Multiple Term Dates?
Y/N Table Edit
Default Value: Y

11 LBR_ACTUAL_TERM_DT Date(10) DATE Actual Termination Date

12 DEF_REHIRE_DT Date(10) DATE Rehire Date

13 LBR_DEF_EE_STAT Character(11) VARCHAR2(11) NOT NULL Default Employee Roster Status
Prompt Table: HR_RCL_EEST_VW

14 LBR_CANDIDATE_NUM Number(6,0) INTEGER NOT NULL Nbr in Group to Consider
Default Value: 0

15 NOTIFIED_DT Date(10) DATE Date First Notified

16 LBR_EXP_REIN_DT Date(10) DATE Expected Reinstatement Date

17 LBR_LAY_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Layoff Roster ID
Prompt Table: %EDITTABLE2

18 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: %datetime

19 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.

#	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 NOT NULL	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 Default Value: TEMP Prompt Table: HR_LAY_TYP_VW
5	LBR_ROST_ACTIVITY	Character(1)	VARCHAR2(1) NOT NULL	Mass Update to be used? Y/N Table Edit Default Value: N
6	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_SEC_VW
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement Prompt Table: EMPL_CTG_L1_VW
9	LBR_PROP_TERM_DT	Date(10)	DATE	Proposed Termination Date
10	LBR_MULT_TERMDT	Character(1)	VARCHAR2(1) NOT NULL	Multiple Term Dates? Y/N Table Edit Default Value: Y
11	LBR_ACTUAL_TERM_DT	Date(10)	DATE	Actual Termination Date
12	DEF_REHIRE_DT	Date(10)	DATE	Rehire Date
13	LBR_DEF_EE_STAT	Character(11)	VARCHAR2(11) NOT NULL	Default Employee Roster Status Prompt Table: HR_RCL_EEST_VW
14	LBR_CANDIDATE_NUM	Number(6,0)	INTEGER NOT NULL	Nbr in Group to Consider Default Value: 0
15	NOTIFIED_DT	Date(10)	DATE	Date First Notified
16	LBR_EXP_REIN_DT	Date(10)	DATE	Expected Reinstatement Date
17	LBR_LAY_ROSTER_ID	Character(11)	VARCHAR2(11) NOT NULL	Layoff Roster ID Prompt Table: %EDITTABLE2
18	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: %datetime
19	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.