[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_WORKSHEETS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_WORKSHEETS
|
| Subobject Name: | |
| Status: | VALID |
PSB_WORKSHEETS stores the basic worksheet information. A worksheet can
be global or local. Global worksheets are created using the worksheet
creation process. Local worksheets are created from the global
worksheet for the various budget groups in the budget group hierarchy.
The information required to create a global worksheet includes budget
group, budget calendar, and options to extract information from
Oracle Public Sector General Ledger. In addition, it also requires the
parameter sets, constraint sets, and allocation rule sets to be used
to create the worksheet.
Local worksheets require only the budget group for which they were
created.
All worksheets contain basic status information such as the current
stage of the worksheet, freeze status, or submission status.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_WORKSHEETS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 WORKSHEET_ID
|
| PSB_WORKSHEETS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| PSB_WORKSHEETS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUDGET_GROUP_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WORKSHEET_ID | NUMBER | (20) | Yes | Worksheet unique identifier |
| BUDGET_GROUP_ID | NUMBER | (20) | Yes | Budget group unique identifier. Budget group for which the worksheet is created. |
| BUDGET_CALENDAR_ID | NUMBER | (20) | Yes | Budget calendar unique identifier. Calendar for which the worksheet is created. |
| WORKSHEET_TYPE | VARCHAR2 | (1) | Yes | Worksheet type is O (distributed worksheet) or F (non-distributed worksheet) |
| NAME | VARCHAR2 | (80) | Yes | Worksheet name |
| DESCRIPTION | VARCHAR2 | (2000) | Worksheet description | |
| WS_CREATION_COMPLETE | VARCHAR2 | (1) | Indicates if the worksheet creation process is complete | |
| STAGE_SET_ID | NUMBER | (15) | Yes | Stage set unique identifier |
| CURRENT_STAGE_SEQ | NUMBER | (15) | Yes | Current Stage Sequence for the worksheet |
| GLOBAL_WORKSHEET_ID | NUMBER | (15) | Worksheet unique identifier for the global worksheet from which this local worksheet is created | |
| GLOBAL_WORKSHEET_FLAG | VARCHAR2 | (1) | Indicates if this is a global worksheet | |
| GLOBAL_WORKSHEET_OPTION | VARCHAR2 | (1) | Option is R (Replace the Global Worksheet) or A (Add to the Global Worksheet). For future use. | |
| LOCAL_COPY_FLAG | VARCHAR2 | (1) | Indicates if this worksheet is a local copy of a distributed worksheet | |
| COPY_OF_WORKSHEET_ID | NUMBER | (20) | Worksheet unique identifier for the source worksheet from which the local copy is created | |
| FREEZE_FLAG | VARCHAR2 | (1) | Indicates if this worksheet is frozen | |
| BUDGET_BY_POSITION | VARCHAR2 | (1) | Indicates if position costs should be computed for each individual position in this worksheet | |
| USE_REVISED_ELEMENT_RATES | VARCHAR2 | (1) | No longer used | |
| NUM_PROPOSED_YEARS | NUMBER | Number of years for which budget estimates have to be created. This number cannot be greater than the number of proposed years in the calendar. This number can be overridden at the budget group level. | ||
| NUM_YEARS_TO_ALLOCATE | NUMBER | Number of years for which the yearly budget estimates have to be allocated to periods within the year | ||
| ROUNDING_FACTOR | NUMBER | Rounding factor to be used for amounts | ||
| BUDGET_VERSION_ID | NUMBER | (20) | No longer used | |
| GL_CUTOFF_PERIOD | DATE | Cutoff date for extraction of actual and encumbrance balances from General Ledger for the current budget year | ||
| GL_BUDGET_SET_ID | NUMBER | (20) | General Ledger budget set identifier | |
| INCLUDE_STAT_BALANCE | VARCHAR2 | (1) | Indicates if statistical amounts should be extracted from General Ledger | |
| INCLUDE_TRANSLATED_BALANCE | VARCHAR2 | (1) | Indicates if translated balances for transactions in non-functional currency should be extracted from General Ledger | |
| INCLUDE_ADJUSTMENT_PERIODS | VARCHAR2 | (1) | Indicates if balances should be extracted from adjustment periods in General Ledger | |
| DATA_EXTRACT_ID | NUMBER | (20) | Data extract unique identifier. Data extract that is used for position related information. | |
| PARAMETER_SET_ID | NUMBER | (20) | Parameter set unique identifier used for creating this worksheet | |
| CONSTRAINT_SET_ID | NUMBER | (20) | Constraint set unique identifier used for validating this worksheet | |
| ALLOCRULE_SET_ID | NUMBER | (15) | Allocation rule set unique identifier used for allocating the yearly amounts in this worksheet | |
| DATE_SUBMITTED | DATE | Date when worksheet is submitted for approval | ||
| SUBMITTED_BY | NUMBER | (15) | Unique identifier of user submitting worksheet for approval | |
| CREATE_NON_POS_LINE_ITEMS | VARCHAR2 | (1) | Indicates if non-position line items should be created for the worksheet | |
| APPLY_ELEMENT_PARAMETERS | VARCHAR2 | (1) | Indicates if element parameters should be applied for creating position budget in the worksheet | |
| APPLY_POSITION_PARAMETERS | VARCHAR2 | (1) | Indicates if position parameters should be applied for creating position budget in the worksheet | |
| CREATE_POSITIONS | VARCHAR2 | (1) | Indicates if position budget should be created for the worksheet | |
| CREATE_SUMMARY_TOTALS | VARCHAR2 | (1) | Indicates if rollup totals should be computed for the worksheet | |
| APPLY_CONSTRAINTS | VARCHAR2 | (1) | Indicates if constraints in the constraint set should be applied to the worksheet | |
| FLEX_MAPPING_SET_ID | NUMBER | (15) | Flexfield mapping set identifier for mapping accounts during worksheet creation | |
| INCLUDE_GL_COMMIT_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger commitment encumbrance balances should be extracted during worksheet creation | |
| INCLUDE_GL_OBLIG_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger obligation encumbrance balances should be extracted during worksheet creation | |
| INCLUDE_GL_OTHER_BALANCE | VARCHAR2 | (1) | Indicates if General Ledger other encumbrance balances should be extracted during worksheet creation | |
| INCLUDE_CBC_COMMIT_BALANCE | VARCHAR2 | (1) | Indicates if commitment balances should be extracted from Commitment Budgetary Control system during worksheet creation | |
| INCLUDE_CBC_OBLIG_BALANCE | VARCHAR2 | (1) | Indicates if actual balances should be extracted from Commitment Budgetary Control system during worksheet creation | |
| INCLUDE_CBC_BUDGET_BALANCE | VARCHAR2 | (1) | Indicates if budget balances should be extracted from Commitment Budgetary Control system during worksheet creation | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield Context | |
| FEDERAL_WS_FLAG | VARCHAR2 | (1) | Federal Worksheet Flag | |
| INCLUDE_GL_FORWARD_BALANCE | VARCHAR2 | (1) | Include GL Forward Balance. 'Y' indicates that worksheet will bring carry forward balances in GL into PSB for Budget and Encumbrances |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_ID
, BUDGET_GROUP_ID
, BUDGET_CALENDAR_ID
, WORKSHEET_TYPE
, NAME
, DESCRIPTION
, WS_CREATION_COMPLETE
, STAGE_SET_ID
, CURRENT_STAGE_SEQ
, GLOBAL_WORKSHEET_ID
, GLOBAL_WORKSHEET_FLAG
, GLOBAL_WORKSHEET_OPTION
, LOCAL_COPY_FLAG
, COPY_OF_WORKSHEET_ID
, FREEZE_FLAG
, BUDGET_BY_POSITION
, USE_REVISED_ELEMENT_RATES
, NUM_PROPOSED_YEARS
, NUM_YEARS_TO_ALLOCATE
, ROUNDING_FACTOR
, BUDGET_VERSION_ID
, GL_CUTOFF_PERIOD
, GL_BUDGET_SET_ID
, INCLUDE_STAT_BALANCE
, INCLUDE_TRANSLATED_BALANCE
, INCLUDE_ADJUSTMENT_PERIODS
, DATA_EXTRACT_ID
, PARAMETER_SET_ID
, CONSTRAINT_SET_ID
, ALLOCRULE_SET_ID
, DATE_SUBMITTED
, SUBMITTED_BY
, CREATE_NON_POS_LINE_ITEMS
, APPLY_ELEMENT_PARAMETERS
, APPLY_POSITION_PARAMETERS
, CREATE_POSITIONS
, CREATE_SUMMARY_TOTALS
, APPLY_CONSTRAINTS
, FLEX_MAPPING_SET_ID
, INCLUDE_GL_COMMIT_BALANCE
, INCLUDE_GL_OBLIG_BALANCE
, INCLUDE_GL_OTHER_BALANCE
, INCLUDE_CBC_COMMIT_BALANCE
, INCLUDE_CBC_OBLIG_BALANCE
, INCLUDE_CBC_BUDGET_BALANCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, FEDERAL_WS_FLAG
, INCLUDE_GL_FORWARD_BALANCE
FROM PSB.PSB_WORKSHEETS;
PSB.PSB_WORKSHEETS does not reference any database object
PSB.PSB_WORKSHEETS is referenced by following:
APPS
PSB_WORKSHEETS
|
|
|
|