HR_TRN_APPR_VW (SQL View)	Index Back
Training Enrollment Apprvl Vw This view contains all training requests that are currently active along with the ID if the person responsible for completing the current (pending) step of approval.

HR_TRN_APPR_VW

(SQL View)

Training Enrollment Apprvl Vw

This view contains all training requests that are currently active along with the ID if the person responsible for completing the current (pending) step of approval.

SELECT A.EMPLID , A.COURSE , A.SESSION_NBR , A.ACTION_DT_SS , PD.NAME , A.HR_WF_STATUS , B.ROLEUSER FROM PS_HR_ENROLL_DAT A , PS_PERSON_NAME PD , PS_HR_ENROLL_STA B WHERE A.EMPLID=B.EMPLID AND A.COURSE = B.COURSE AND A.SESSION_NBR = B.SESSION_NBR AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.EMPLID = PD.EMPLID AND B.HR_WF_ACTION = ' ' AND B.TRANS_DT IS NULL AND B.CURRENT_STEP > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

3 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

4 ACTION_DT_SS Date(10) DATE NOT NULL Termination Date

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 HR_WF_STATUS Character(30) VARCHAR2(30) NOT NULL Status

7 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code
3	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr
4	ACTION_DT_SS	Date(10)	DATE NOT NULL	Termination Date
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	HR_WF_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Status
7	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User