HR_NAME_DAT_VW (SQL View)	Index Back
Self Service Name Change Search record used for Name change PIA approval component

HR_NAME_DAT_VW

(SQL View)

Self Service Name Change

Search record used for Name change PIA approval component

SELECT EMPLID , NAME_TYPE , ACTION_DT_SS , EFFSEQ , WF_STATUS , APPROVAL_REQUIRED FROM PS_HR_NAME_DAT WHERE APPROVAL_REQUIRED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Default Value: PRI
Prompt Table: NAME_TYPE_TBL

3 ACTION_DT_SS Date(10) DATE Termination Date

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

5 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved

6 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required
Y=Approval Required
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Default Value: PRI Prompt Table: NAME_TYPE_TBL
3	ACTION_DT_SS	Date(10)	DATE	Termination Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
6	APPROVAL_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page. N=No Approval Required Y=Approval Required Default Value: N