COMPANYFISCAL_YEARACCT_FY_VW(SQL View) |
Index Back |
|---|---|
Fiscal Year ViewThe ACCT_FY_VW selects each Fiscal Year 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 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 |