HR_LBR_ROSTER (SQL Table)	Index Back
HR - Roster. Defines the Layoff/Recall Rosters.

HR_LBR_ROSTER

(SQL Table)

HR - Roster.

Defines the Layoff/Recall Rosters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LBR_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Roster ID

2 LBR_ROST_STATUS_CD Character(3) VARCHAR2(3) NOT NULL Roster Status
010=010 - Open
020=020 - In Progress
030=030 - Awaiting Approval
040=040 - Approved
050=050 - Not Approved
060=060 - On Hold
070=070 - Final
090=090 - Cancelled
100=100 - Closed
Default Value: 010
Prompt Table: HR_ROST_STAT_VW

3 LBR_EVENT_TYPE Character(1) VARCHAR2(1) NOT NULL Labor event type
L=Layoff
R=Recall
Default Value: L

4 LBR_ROST_EXEC_FLG Character(1) VARCHAR2(1) NOT NULL Roster Executed
Y/N Table Edit
Default Value: N

5 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

6 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	LBR_ROST_STATUS_CD	Character(3)	VARCHAR2(3) NOT NULL	Roster Status 010=010 - Open 020=020 - In Progress 030=030 - Awaiting Approval 040=040 - Approved 050=050 - Not Approved 060=060 - On Hold 070=070 - Final 090=090 - Cancelled 100=100 - Closed Default Value: 010 Prompt Table: HR_ROST_STAT_VW
3	LBR_EVENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Labor event type L=Layoff R=Recall Default Value: L
4	LBR_ROST_EXEC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Roster Executed Y/N Table Edit Default Value: N
5	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
6	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.