DBA Data[Home] [Help] [Dependency Information]

TABLE: GMS.GMS_BC_PACKETS

Object Details
Object Name: GMS_BC_PACKETS
Object Type: TABLE
Owner: GMS
FND Design Data: TableGMS.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMS_BC_PACKETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBC_PACKET_ID
GMS_BC_PACKETS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnPROJECT_ID
ColumnAWARD_ID
ColumnTASK_ID
GMS_BC_PACKETS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnADJUSTED_DOCUMENT_HEADER_ID
GMS_BC_PACKETS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_TYPE
ColumnDOCUMENT_HEADER_ID
GMS_BC_PACKETS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS_CODE
GMS_BC_PACKETS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_EVENT_ID
GMS_BC_PACKETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
ColumnPACKET_ID
ColumnSTATUS_CODE
GMS_BC_PACKETS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_BC_PACKET_ID
GMS_BC_PACKETS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnDOCUMENT_HEADER_ID
ColumnDOCUMENT_DISTRIBUTION_ID
ColumnDOCUMENT_TYPE
GMS_BC_PACKETS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnSTATUS_CODE
ColumnEFFECT_ON_FUNDS_CODE
GMS_BC_PACKETS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
ColumnBUD_TASK_ID
GMS_BC_PACKETS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
GMS_BC_PACKETS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAWARD_ID
ColumnEXPENDITURE_TYPE
ColumnSTATUS_CODE
ColumnBURDEN_CALCULATION_SEQ
GMS_BC_PACKETS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

GMS.GMS_BC_PACKETS does not reference any database object

GMS.GMS_BC_PACKETS is referenced by following:

SchemaGMS
ViewGMS_BC_PACKETS#