PAY_CALSRCH_NLD (SQL View)	Index Back
Pay Calendar Search Vw (NLD) Pay Calendar Search View used for Interface Data (NLD)

PAY_CALSRCH_NLD

(SQL View)

Pay Calendar Search Vw (NLD)

Pay Calendar Search View used for Interface Data (NLD)

SELECT PAY_END_DT, COMPANY, PAYGROUP, PAY_BEGIN_DT, PAY_END_DT FROM PS_PAY_CALENDR_NLD WHERE PAY_CALC_RUN = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

4 PAY_BEGIN_DT Date(10) DATE Pay Period Begin Date

5 PAY_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
4	PAY_BEGIN_DT	Date(10)	DATE	Pay Period Begin Date
5	PAY_END_DT	Date(10)	DATE	Pay Period End Date