FPMPROMTAB02_VW (SQL View)	Index Back
Dates of promotion per grade This view retrieves the date of promotion for the groups of grades for which promotable employees have been identified. It is used in a run control panel. It is used in the French Public Sector functionalities.

FPMPROMTAB02_VW

(SQL View)

Dates of promotion per grade

This view retrieves the date of promotion for the groups of grades for which promotable employees have been identified. It is used in a run control panel. It is used in the French Public Sector functionalities.

SELECT A.FP_THRUDATE , A.FP_SETID_RANK , A.FP_RANK_START FROM PS_FPMPROMTABL_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FP_THRUDATE Date(10) DATE Starting Date

2 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL Set ID
Prompt Table: SETID_TBL

3 FP_RANK_START Character(6) VARCHAR2(6) NOT NULL Grade of Origin
Prompt Table: FPMPROMTABL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_THRUDATE	Date(10)	DATE	Starting Date
2	FP_SETID_RANK	Character(5)	VARCHAR2(5) NOT NULL	Set ID Prompt Table: SETID_TBL
3	FP_RANK_START	Character(6)	VARCHAR2(6) NOT NULL	Grade of Origin Prompt Table: FPMPROMTABL_TBL