HR_JOB_POS_TMP (SQL Table)	Index Back
Position Data Temp Table Temp Table built to fetch current EFFDT rows from Position Data. This will be used in Component search for Job Data.

HR_JOB_POS_TMP

(SQL Table)

Position Data Temp Table

Temp Table built to fetch current EFFDT rows from Position Data. This will be used in Component search for Job Data.

Related Language Record: HR_JOB_POS_TMPL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: 0

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Default Value: 0
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	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.