BUSINESS_UNITFISCAL_YEARACCT_FY_VW2(SQL View) |
Index Back |
|---|---|
Fiscal Year ViewThe ACCT_FY_VW2 selects each Fiscal Year defined by joining data from the following tables: PS_BUS_UNIT_TBL_HR, PS_GL_JRNL_TMPLT, PS_CAL_DETP_TBL, PS_SET_CNTRL_REC |
| SELECT DISTINCT BU.BUSINESS_UNIT , CA.FISCAL_YEAR FROM PS_BUS_UNIT_TBL_HR BU , PS_GL_JRNL_TMPLT GL , PS_CAL_DETP_TBL CA , PS_SET_CNTRL_REC SC WHERE GL.BUSINESS_UNIT_GL = BU.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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |