HR_RCL_RIGHTS (SQL Table)	Index Back
HR - Recall Rights. This page maintains employees' Recall Rights at employee level.

HR_RCL_RIGHTS

(SQL Table)

HR - Recall Rights.

This page maintains employees' Recall Rights at employee level.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
Default Value: 0

5 LBR_RCL_EXPIRY_DT Date(10) DATE Recall Expiration Date

6 LBR_RECALL_REASON Character(10) VARCHAR2(10) NOT NULL Recall Reason
Prompt Table: HR_RCL_RSN_TBL

7 LBR_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Roster ID
Prompt Table: HR_LBR_ROSTER

8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N

9 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

10 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence Default Value: 0
5	LBR_RCL_EXPIRY_DT	Date(10)	DATE	Recall Expiration Date
6	LBR_RECALL_REASON	Character(10)	VARCHAR2(10) NOT NULL	Recall Reason Prompt Table: HR_RCL_RSN_TBL
7	LBR_ROSTER_ID	Character(11)	VARCHAR2(11) NOT NULL	Roster ID Prompt Table: HR_LBR_ROSTER
8	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
9	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
10	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.