CNAO_XML_REGPRD(SQL View) |
Index Back |
|---|
| SELECT DISTINCT PM.OPRID ,PM.RUN_CNTL_ID , BL.business_unit ,DC.fiscal_year ,DC.accounting_period ,DC.begin_dt ,DC.end_dt FROM ps_cal_detp_tbl DC ,PS_BU_LED_GRP_TBL BL ,PS_SET_CNTRL_REC SC1 ,PS_SET_CNTRL_REC SC2 ,PS_CNAO_XMLG_PARM PM ,PS_LED_GRP_LED_TBL LG WHERE PM.BUSINESS_UNIT=BL.BUSINESS_UNIT AND PM.FISCAL_YEAR=DC.FISCAL_YEAR AND BL.calendar_id=DC.calendar_id AND BL.business_unit=SC1.setcntrlvalue AND SC1.RECNAME='CAL_DETP_TBL' AND SC1.setid=DC.setid AND PM.business_unit=SC2.setcntrlvalue AND SC2.RECNAME='LED_GRP_LED_TBL' AND SC2.SETID=LG.SETID AND LG.LEDGER=PM.LEDGER AND LG.LEDGER_GROUP=BL.LEDGER_GROUP AND DC.ACCOUNTING_PERIOD <=PM.PERIOD_TO AND DC.ACCOUNTING_PERIOD>=PM.PERIOD_FROM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | End Date |