ACCT_PERIOD_VW (SQL View)	Index Back
Acct Period View The ACCT_PERIOD_VW selects each Fiscal Year, Accounting Period combination defined by joining data from the following tables: PS_PAY_CHECK, PS_BUS_UNIT_TBL_HR, PS_GL_JRNL_TMPLT, PS_CAL_DETP_TBL, PS_SET_CNTRL_REC

ACCT_PERIOD_VW

(SQL View)

Acct Period View

The ACCT_PERIOD_VW selects each Fiscal Year, Accounting Period combination defined by joining data from the following tables: PS_PAY_CHECK, PS_BUS_UNIT_TBL_HR, PS_GL_JRNL_TMPLT, PS_CAL_DETP_TBL, PS_SET_CNTRL_REC

SELECT DISTINCT PC.COMPANY ,CA.FISCAL_YEAR ,CA.ACCOUNTING_PERIOD ,CA.BEGIN_DT ,CA.END_DT FROM PS_PAY_CHECK PC , PS_BUS_UNIT_TBL_HR BU , PS_GL_JRNL_TMPLT GL , PS_CAL_DETP_TBL CA , PS_SET_CNTRL_REC SC WHERE PC.BUSINESS_UNIT = BU.BUSINESS_UNIT AND BU.BUSINESS_UNIT_GL = GL.BUSINESS_UNIT_GL AND SC.SETCNTRLVALUE = GL.BUSINESS_UNIT_GL AND SC.REC_GROUP_ID = 'FS_02' AND SC.RECNAME = 'CAL_DETP_TBL' AND CA.SETID = SC.SETID AND CA.CALENDAR_ID = GL.CALENDAR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

3 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period

4 BEGIN_DT Date(10) DATE Begin Date

5 END_DT Date(10) DATE end date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
3	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Accounting Period
4	BEGIN_DT	Date(10)	DATE	Begin Date
5	END_DT	Date(10)	DATE	end date