GPTH_T_LOG_EMPL (SQL View)	Index Back
GPTH Tax Log Employees This Record used for GPTH Tax Log Employees

GPTH_T_LOG_EMPL

(SQL View)

GPTH Tax Log Employees

This Record used for GPTH Tax Log Employees

SELECT G.CAL_RUN_ID ,G.EMPLID ,NM.NAME_DISPLAY ,NM.LAST_NAME_SRCH ,NM.SECOND_LAST_SRCH ,NM.NAME_AC FROM PS_NAMES NM ,PS_GPTH_TX_G_T_LOG G WHERE G.EMPLID=NM.EMPLID AND G.CAL_RUN_ID=G.ORIG_CAL_RUN_ID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = NM.EMPLID AND B.NAME_TYPE = 'PRI' AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

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

4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

5 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name

6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
6	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name