[Home] [Help] [Dependency Information]
Object Name: | GMS_BC_PACKETS |
---|---|
Object Type: | TABLE |
Owner: | GMS |
FND Design Data: | GMS.GMS_BC_PACKETS |
Subobject Name: | |
Status: | VALID |
GMS_BC_PACKETS is Oracle Grants Accounting's main table for the budgetary control feature. This table stores the budgetary control packets that need to be approved before creating journal entries. A budgetary control packet contains information about a set of transactions to be approved before entering it into the system. The funds check program evaluates these packets and updates the RESULT_CODE column in GMS_BC_PACKETS with a lookup code signifying the result of the funds check. Once a packet passes its funds check and the balances are updated in GMS_BALANCES, the packet is removed from GMS_BC_PACKETS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMS_BC_PACKETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BC_PACKET_ID |
GMS_BC_PACKETS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKET_ID
PROJECT_ID AWARD_ID TASK_ID |
GMS_BC_PACKETS_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKET_ID
ADJUSTED_DOCUMENT_HEADER_ID |
GMS_BC_PACKETS_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DOCUMENT_TYPE
DOCUMENT_HEADER_ID |
GMS_BC_PACKETS_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUS_CODE |
GMS_BC_PACKETS_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_EVENT_ID |
GMS_BC_PACKETS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUDGET_VERSION_ID
PACKET_ID STATUS_CODE |
GMS_BC_PACKETS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_BC_PACKET_ID |
GMS_BC_PACKETS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKET_ID
DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID DOCUMENT_TYPE |
GMS_BC_PACKETS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKET_ID
EFFECT_ON_FUNDS_CODE STATUS_CODE |
GMS_BC_PACKETS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKET_ID
BUD_TASK_ID |
GMS_BC_PACKETS_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
TASK_ID |
GMS_BC_PACKETS_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
AWARD_ID
EXPENDITURE_TYPE STATUS_CODE BURDEN_CALCULATION_SEQ |
GMS_BC_PACKETS_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKET_ID | NUMBER | (15) | Yes | Budgetary control packet defining column |
PROJECT_ID | NUMBER | (15) | Yes | Project defining column |
AWARD_ID | NUMBER | (15) | Yes | Award defining column |
TASK_ID | NUMBER | (15) | Yes | Task defining column |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure type defining column |
EXPENDITURE_ITEM_DATE | DATE | Yes | Expenditure item date for the expenditure | |
ACTUAL_FLAG | VARCHAR2 | (1) | Yes | Balance type. Valid values are A indicates Actual, B indicates Budget, or E indicates Encumbrance. |
STATUS_CODE | VARCHAR2 | (1) | Yes | Funds check or reservation status |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Accounting books defining column |
JE_CATEGORY_NAME | VARCHAR2 | (30) | Yes | Journal entry category name |
JE_SOURCE_NAME | VARCHAR2 | (30) | Yes | Journal entry source name |
TRANSFERED_FLAG | VARCHAR2 | (1) | Yes | Not currently used |
DOCUMENT_TYPE | VARCHAR2 | (3) | Yes | Document type defining column. Possible values are REQ, PO, Payables, or Project Accounting. |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Organization-incurred expenditure | |
PERIOD_NAME | VARCHAR2 | (15) | Accounting period | |
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
DOCUMENT_HEADER_ID | NUMBER | (15) | Document header defining column | |
DOCUMENT_DISTRIBUTION_ID | NUMBER | (15) | Document distribution defining column | |
TOP_TASK_ID | NUMBER | (15) | Top task defining column | |
PARENT_RESOURCE_ID | NUMBER | (15) | Parent task defining column | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version | |
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Resource list member defining column | |
ACCOUNT_TYPE | VARCHAR2 | (1) | Oracle Public Sector General Ledger account type | |
ENTERED_DR | NUMBER | Transaction debit amount in entered currency | ||
ENTERED_CR | NUMBER | Transaction credit amount in entered currency | ||
TOLERANCE_AMOUNT | NUMBER | Allowable amount to exceed funding budget | ||
TOLERANCE_PERCENTAGE | NUMBER | Percentage of funding budget that can be increased | ||
OVERRIDE_AMOUNT | NUMBER | Maximum transaction amount that can be used to override a funds check | ||
EFFECT_ON_FUNDS_CODE | VARCHAR2 | (1) | Increasing or decreasing effect of a transaction on funds available | |
RESULT_CODE | VARCHAR2 | (3) | Result of funds check or reservation | |
GL_BC_PACKETS_ROWID | VARCHAR2 | (30) | GL_BC_PACKETS row identifier defining column | |
AWARD_BUDGET_POSTED | NUMBER | Award budget posted | ||
AWARD_BUDGET_APPROVED | NUMBER | Award budget approved | ||
AWARD_BUDGET_PENDING | NUMBER | Award budget pending | ||
AWARD_ENC_POSTED | NUMBER | Award encumbrance posted | ||
AWARD_ENC_APPROVED | NUMBER | Award encumbrance approved | ||
AWARD_ENC_PENDING | NUMBER | Award encumbrance pending | ||
AWARD_ACTUAL_POSTED | NUMBER | Award actuals posted | ||
AWARD_ACTUAL_APPROVED | NUMBER | Award actuals approved | ||
AWARD_ACTUAL_PENDING | NUMBER | Award actuals pending | ||
AWARD_RESULT_CODE | VARCHAR2 | (3) | Result code of funds check at award level | |
TASK_BUDGET_POSTED | NUMBER | Task budget posted | ||
TASK_BUDGET_APPROVED | NUMBER | Task budget approved | ||
TASK_BUDGET_PENDING | NUMBER | Task budget pending | ||
TASK_ENC_POSTED | NUMBER | Task encumbrances posted | ||
TASK_ENC_APPROVED | NUMBER | Task encumbrances approved | ||
TASK_ENC_PENDING | NUMBER | Task encumbrances pending | ||
TASK_ACTUAL_POSTED | NUMBER | Task actuals posted | ||
TASK_ACTUAL_APPROVED | NUMBER | Task actuals approved | ||
TASK_ACTUAL_PENDING | NUMBER | Task actuals pending | ||
TASK_RESULT_CODE | VARCHAR2 | (3) | Result code of funds check at task level | |
RES_GRP_BUDGET_POSTED | NUMBER | Resource group budget posted | ||
RES_GRP_BUDGET_APPROVED | NUMBER | Resource group budget approved | ||
RES_GRP_BUDGET_PENDING | NUMBER | Resource group budget pending | ||
RES_GRP_ENC_POSTED | NUMBER | Resource group encumbrances posted | ||
RES_GRP_ENC_APPROVED | NUMBER | Resource group encumbrances approved | ||
RES_GRP_ENC_PENDING | NUMBER | Resource group encumbrances pending | ||
RES_GRP_ACTUAL_POSTED | NUMBER | Resource group actuals posted | ||
RES_GRP_ACTUAL_APPROVED | NUMBER | Resource group actuals approved | ||
RES_GRP_ACTUAL_PENDING | NUMBER | Resource group actuals pending | ||
RES_GRP_RESULT_CODE | VARCHAR2 | (3) | Result code of funds checker at resource group level | |
RES_BUDGET_POSTED | NUMBER | Resource budget posted | ||
RES_BUDGET_APPROVED | NUMBER | Resource budget approved | ||
RES_BUDGET_PENDING | NUMBER | Resource budget pending | ||
RES_ENC_POSTED | NUMBER | Resource encumbrances posted | ||
RES_ENC_APPROVED | NUMBER | Resource encumbrances approved | ||
RES_ENC_PENDING | NUMBER | Resource encumbrances pending | ||
RES_ACTUAL_POSTED | NUMBER | Resource actuals posted | ||
RES_ACTUAL_APPROVED | NUMBER | Resource actuals approved | ||
RES_ACTUAL_PENDING | NUMBER | Resource actuals pending | ||
RES_RESULT_CODE | VARCHAR2 | (3) | Result code of funds check at resource level | |
STATUS_FLAG | VARCHAR2 | (2) | Not currently used | |
RES_BUDGET_BAL | NUMBER | Resource level budget balance after funds check | ||
RES_GRP_BUDGET_BAL | NUMBER | Resource group level budget balance after funds check | ||
TASK_BUDGET_BAL | NUMBER | Task level budget balance after funds check | ||
TOP_TASK_BUDGET_BAL | NUMBER | Top task level budget balance after funds check | ||
AWARD_BUDGET_BAL | NUMBER | Award level budget balance after funds check | ||
GL_ROW_NUMBER | NUMBER | GL_BC_PACKETS row sequence number | ||
BC_PACKET_ID | NUMBER | Bugetary control records unique identifier | ||
PARENT_BC_PACKET_ID | NUMBER | Raw budgetary control record, which the burdened budgetary control record is associated with | ||
BURDENABLE_RAW_COST | NUMBER | Amount of raw cost that is burdenable. Portion of raw cost that does not exceed maximum indirect base. | ||
BUD_RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Resource list member identifier for the record | |
BUD_TASK_ID | NUMBER | (15) | Budgeted task identifier for the record | |
FUNDING_PATTERN_ID | NUMBER | (15) | Funding pattern identifier for the record | |
FUNDING_SEQUENCE | NUMBER | (15) | Sequence number within the funding pattern for the record | |
FP_STATUS | VARCHAR2 | (1) | Status of the funding pattern | |
R_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Funds control level code at resource level | |
RG_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Funds control level code at resource group level | |
T_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Funds control level code at task level | |
TT_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Funds control level code at top task level | |
A_FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Funds control level code at award level | |
TOP_TASK_BUDGET_POSTED | NUMBER | Posted budget balance at top task | ||
TOP_TASK_BUDGET_APPROVED | NUMBER | Budget balance at top task after approved transactions are posted | ||
TOP_TASK_BUDGET_PENDING | NUMBER | budget balance at top task after pending transactions | ||
TOP_TASK_ENC_POSTED | NUMBER | Encumbrance amount already posted at top task level | ||
TOP_TASK_ENC_APPROVED | NUMBER | Encumbrance amount approved but not posted at top task level | ||
TOP_TASK_ENC_PENDING | NUMBER | Encumbrance amount pending for approval at top task level | ||
TOP_TASK_ACTUAL_POSTED | NUMBER | Actual transaction amount already posted at top task level | ||
TOP_TASK_ACTUAL_APPROVED | NUMBER | Actual transaction amount already approved but not posted at top task level | ||
TOP_TASK_ACTUAL_PENDING | NUMBER | Actual transaction amount pending approval at top task level | ||
TOP_TASK_RESULT_CODE | VARCHAR2 | (3) | Funds check result code at top task level | |
REQUEST_ID | NUMBER | (15) | Standard Who column | |
BALANCE_POSTED_FLAG | VARCHAR2 | (1) | Flag indicating the transaction updated in Grants Accounting balance | |
BURDEN_POSTED_FLAG | VARCHAR2 | (1) | Flag indicating the burden posted to balances and summary tables | |
BURDENED_COST | NUMBER | (22) | Burdened Cost | |
FUNDS_CHECK_SEQ | NUMBER | (15) | Funds check sequence | |
AMOUNT_TYPE | VARCHAR2 | (4) | Amount Type of Award | |
BOUNDARY_CODE | VARCHAR2 | (2) | Boundary code of Award | |
BUDGET_PERIOD_START_DATE | DATE | Budget Period start date based on Amount type, boudary code & time phased code | ||
BUDGET_PERIOD_END_DATE | DATE | Budget Period end date based on Amount type, boundary code & time phased code | ||
CATEGORIZATION_CODE | VARCHAR2 | (30) | Categorization code of budget Entry Method of project | |
PARENT_TASK_ID | NUMBER | (15) | Parent Task id of Task | |
RESOURCE_LIST_ID | NUMBER | (15) | Resource List id of Transaction | |
TIME_PHASED_TYPE_CODE | VARCHAR2 | (1) | Time phase type code of budget Entry Method | |
BUDGETED_AT_RESOURCE_LEVEL | VARCHAR2 | (1) | Whether budgeted at Resource or Resource Group Level | |
FC_ERROR_MESSAGE | VARCHAR2 | (2000) | Error Message | |
IND_COMPILED_SET_ID | NUMBER | (15) | Indirect Compiled set Id | |
PERSON_ID | NUMBER | (9) | Person Id | |
JOB_ID | NUMBER | (15) | Job Id | |
VENDOR_ID | NUMBER | (15) | Vendor Id | |
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Expenditure Category | |
REVENUE_CATEGORY | VARCHAR2 | (30) | Revenue Category | |
ADJUSTED_DOCUMENT_HEADER_ID | NUMBER | (15) | The identifier of the transaction adjusted by this transaction. | |
AWARD_SET_ID | NUMBER | (15) | System generated number for a distribution set | |
TRANSACTION_SOURCE | VARCHAR2 | (30) | Implementation-defined classification of a transaction loaded into PA from an external system | |
BURDEN_ADJUSTMENT_FLAG | VARCHAR2 | (1) | Indicate this record is a burden adjustment. | |
BURDEN_ADJ_BC_PACKET_ID | NUMBER | bc_packet_id of the original record for which this burden adjustment has been created to maximize burden | ||
BURDEN_CALCULATION_SEQ | NUMBER | Indicates the sequence in which record were picked for burden calculation. | ||
TXN_INTERFACE_ID | NUMBER | (15) | System-generated number that identifies all the transactions processed by a given transaction import process request | |
SESSION_ID | NUMBER | (38) | Identifier of the user session | |
SERIAL_ID | NUMBER | (38) | Identifier of the serial number of the session | |
SOURCE_EVENT_ID | NUMBER | (15) | Identifier of the source event |
Cut, paste (and edit) the following text to query this object:
SELECT PACKET_ID
, PROJECT_ID
, AWARD_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ACTUAL_FLAG
, STATUS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID
, JE_CATEGORY_NAME
, JE_SOURCE_NAME
, TRANSFERED_FLAG
, DOCUMENT_TYPE
, EXPENDITURE_ORGANIZATION_ID
, PERIOD_NAME
, PERIOD_YEAR
, PERIOD_NUM
, DOCUMENT_HEADER_ID
, DOCUMENT_DISTRIBUTION_ID
, TOP_TASK_ID
, PARENT_RESOURCE_ID
, BUDGET_VERSION_ID
, RESOURCE_LIST_MEMBER_ID
, ACCOUNT_TYPE
, ENTERED_DR
, ENTERED_CR
, TOLERANCE_AMOUNT
, TOLERANCE_PERCENTAGE
, OVERRIDE_AMOUNT
, EFFECT_ON_FUNDS_CODE
, RESULT_CODE
, GL_BC_PACKETS_ROWID
, AWARD_BUDGET_POSTED
, AWARD_BUDGET_APPROVED
, AWARD_BUDGET_PENDING
, AWARD_ENC_POSTED
, AWARD_ENC_APPROVED
, AWARD_ENC_PENDING
, AWARD_ACTUAL_POSTED
, AWARD_ACTUAL_APPROVED
, AWARD_ACTUAL_PENDING
, AWARD_RESULT_CODE
, TASK_BUDGET_POSTED
, TASK_BUDGET_APPROVED
, TASK_BUDGET_PENDING
, TASK_ENC_POSTED
, TASK_ENC_APPROVED
, TASK_ENC_PENDING
, TASK_ACTUAL_POSTED
, TASK_ACTUAL_APPROVED
, TASK_ACTUAL_PENDING
, TASK_RESULT_CODE
, RES_GRP_BUDGET_POSTED
, RES_GRP_BUDGET_APPROVED
, RES_GRP_BUDGET_PENDING
, RES_GRP_ENC_POSTED
, RES_GRP_ENC_APPROVED
, RES_GRP_ENC_PENDING
, RES_GRP_ACTUAL_POSTED
, RES_GRP_ACTUAL_APPROVED
, RES_GRP_ACTUAL_PENDING
, RES_GRP_RESULT_CODE
, RES_BUDGET_POSTED
, RES_BUDGET_APPROVED
, RES_BUDGET_PENDING
, RES_ENC_POSTED
, RES_ENC_APPROVED
, RES_ENC_PENDING
, RES_ACTUAL_POSTED
, RES_ACTUAL_APPROVED
, RES_ACTUAL_PENDING
, RES_RESULT_CODE
, STATUS_FLAG
, RES_BUDGET_BAL
, RES_GRP_BUDGET_BAL
, TASK_BUDGET_BAL
, TOP_TASK_BUDGET_BAL
, AWARD_BUDGET_BAL
, GL_ROW_NUMBER
, BC_PACKET_ID
, PARENT_BC_PACKET_ID
, BURDENABLE_RAW_COST
, BUD_RESOURCE_LIST_MEMBER_ID
, BUD_TASK_ID
, FUNDING_PATTERN_ID
, FUNDING_SEQUENCE
, FP_STATUS
, R_FUNDS_CONTROL_LEVEL_CODE
, RG_FUNDS_CONTROL_LEVEL_CODE
, T_FUNDS_CONTROL_LEVEL_CODE
, TT_FUNDS_CONTROL_LEVEL_CODE
, A_FUNDS_CONTROL_LEVEL_CODE
, TOP_TASK_BUDGET_POSTED
, TOP_TASK_BUDGET_APPROVED
, TOP_TASK_BUDGET_PENDING
, TOP_TASK_ENC_POSTED
, TOP_TASK_ENC_APPROVED
, TOP_TASK_ENC_PENDING
, TOP_TASK_ACTUAL_POSTED
, TOP_TASK_ACTUAL_APPROVED
, TOP_TASK_ACTUAL_PENDING
, TOP_TASK_RESULT_CODE
, REQUEST_ID
, BALANCE_POSTED_FLAG
, BURDEN_POSTED_FLAG
, BURDENED_COST
, FUNDS_CHECK_SEQ
, AMOUNT_TYPE
, BOUNDARY_CODE
, BUDGET_PERIOD_START_DATE
, BUDGET_PERIOD_END_DATE
, CATEGORIZATION_CODE
, PARENT_TASK_ID
, RESOURCE_LIST_ID
, TIME_PHASED_TYPE_CODE
, BUDGETED_AT_RESOURCE_LEVEL
, FC_ERROR_MESSAGE
, IND_COMPILED_SET_ID
, PERSON_ID
, JOB_ID
, VENDOR_ID
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, ADJUSTED_DOCUMENT_HEADER_ID
, AWARD_SET_ID
, TRANSACTION_SOURCE
, BURDEN_ADJUSTMENT_FLAG
, BURDEN_ADJ_BC_PACKET_ID
, BURDEN_CALCULATION_SEQ
, TXN_INTERFACE_ID
, SESSION_ID
, SERIAL_ID
, SOURCE_EVENT_ID
FROM GMS.GMS_BC_PACKETS;
GMS.GMS_BC_PACKETS does not reference any database object
GMS.GMS_BC_PACKETS is referenced by following:
|
|
|