HR_EE_ROST_CMNT (SQL Table)	Index Back
HR - Comments. Used to record free-form comments about a candidate.

HR_EE_ROST_CMNT

(SQL Table)

HR - Comments.

Used to record free-form comments about a candidate.

# 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 Record

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

7 COMMENT_DT Date(10) DATE Comment Date
Default Value: %date

8 COMMENTS Long Character CLOB Comment

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.

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	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 Record
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	COMMENT_DT	Date(10)	DATE	Comment Date Default Value: %date
8	COMMENTS	Long Character	CLOB	Comment
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.
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.