BUSINESS_UNITFISCAL_YEARACCOUNTING_PERIODACCT_PERIOD_VW2(SQL View) |
Index Back |
|---|---|
Acct Period ViewThe ACCT_PERIOD_VW2 selects each Fiscal Year, Accounting Period combination 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 , CA.ACCOUNTING_PERIOD , CA.BEGIN_DT , CA.END_DT 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 |
| 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 |