VIEW: MSC.MSC_ST_BIS_PERIODS#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_NAME PERIOD_NAME, START_DATE START_DATE, END_DATE END_DATE, PERIOD_TYPE PERIOD_TYPE, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM, QUARTER_NUM QUARTER_NUM, ENTERED_PERIOD_NAME ENTERED_PERIOD_NAME, ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG, DESCRIPTION DESCRIPTION, CONTEXT CONTEXT, YEAR_START_DATE YEAR_START_DATE, QUARTER_START_DATE QUARTER_START_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, SR_INSTANCE_ID SR_INSTANCE_ID from "MSC"."MSC_ST_BIS_PERIODS"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_NAME PERIOD_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, PERIOD_TYPE PERIOD_TYPE
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
, QUARTER_NUM QUARTER_NUM
, ENTERED_PERIOD_NAME ENTERED_PERIOD_NAME
, ADJUSTMENT_PERIOD_FLAG ADJUSTMENT_PERIOD_FLAG
, DESCRIPTION DESCRIPTION
, CONTEXT CONTEXT
, YEAR_START_DATE YEAR_START_DATE
, QUARTER_START_DATE QUARTER_START_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
FROM "MSC"."MSC_ST_BIS_PERIODS"