XCC_CONTROL_BUDGETS_GT
This temporary table contains data that is used to create control budgets in bulk.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CONTROL_BUDGET_ID | NUMBER | 18 | Unique identifier of the control budget. | ||
NAME | VARCHAR2 | 100 | Yes | Unique identifier of the control budget. | |
DESCRIPTION | VARCHAR2 | 240 | Description of the control budget. | ||
START_PERIOD_NAME | VARCHAR2 | 15 | Period when the control budget starts being effective. | ||
END_PERIOD_NAME | VARCHAR2 | 15 | Period when the control budget stops being effective. | ||
CALENDAR_ID | NUMBER | 18 | Calendar identifier used for the control budget. | ||
SOURCE_BUDGET_SYSTEM_CODE | VARCHAR2 | 30 | Source budget type code of the control budget. | ||
FUNDS_RELEASE_TIMEFRAME | VARCHAR2 | 30 | Determines when the funds are made available for a particular period. Possible values are RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN. | ||
CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Control level code to determine funds available. | ||
TOLERANCE_AMOUNT | NUMBER | Fixed amount used as tolerance. | |||
TOLERANCE_PERCENT | NUMBER | Percentage of the budget amount that is used as tolerance. | |||
CURRENCY_CODE | VARCHAR2 | 15 | Currency assigned to the control budget. | ||
UOM_CODE | VARCHAR2 | 3 | Unit of measure assigned to the control budget. | ||
DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default rate type assigned to the control budget. | ||
LEDGER_ID | NUMBER | 18 | Primary ledger identifier defined in the GL and enabled for budgetary control. | ||
PROJECT_ID | NUMBER | 18 | Unique identifier of the accounting project. The default value is -98. | ||
BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Unique identifier of the key flexfield structure that is used to define columns for control budget accounts. | ||
BUDGET_MANAGER_ID | NUMBER | 18 | Unique identifier of the budget manager responsible for the control budget. | ||
BALANCE_INCREASES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether increases are allowed as adjustments to the initial loaded amounts for the budget account combination of the control budget. The default value is Y. | ||
BALANCE_DECREASES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether decreases are allowed as adjustments to the initial loaded amounts for the budget account combination of the control budget. The default value is Y. | ||
NEGATIVE_BALANCES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether the funds available balance can assume a negative value when adjusted to the initial loaded amounts for budget account combination of the control budget. The default value is N. | ||
PJC_CONTRACT_ID | NUMBER | 18 | Unique project accounting contract identifier for the award associated with the budget amount. The default value is -98. | ||
ALLOW_OVERRIDES_FLAG | VARCHAR2 | 1 | Indicates if overrides are allowed for this control budget. | ||
NO_OVERRIDES_NOTIFY_FLAG | VARCHAR2 | 1 | Indicates if the budget manager must be notified when no overrides are available. | ||
OVERRIDES_TAKEN_NOTIFY_FLAG | VARCHAR2 | 1 | Indicates if the budget manager must be notified when an override is taken. | ||
MAXIMUM_OVERRIDE_AMOUNT | NUMBER | Maximum override amount allowed for this control budget. Amount is in the budget currency. | |||
INTERNAL_BUDGET_TYPE_CODE | VARCHAR2 | 30 | Order of segments in the budget chart of accounts structure for project based control budgets. For example, PARF indicates a segment order of Project, Award, Top Resource, and Funding Source. | ||
FV_DISTRIBUTE_BUDGET_FLAG | VARCHAR2 | 1 | Indicates whether the Federal budget is enabled for budget distribution. Possible vallues are Y and N. | ||
FV_CONSUME_BUDGET_FLAG | VARCHAR2 | 1 | Indicates whether the Federal budget is enabled for consumption. Possible values are Y and N. | ||
MASTER_CONTROL_BUDGET_NAME | VARCHAR2 | 100 | Detail control budget name of the summary control budget. | ||
STATUS_CODE | VARCHAR2 | 30 | The processing status of the control budget. | ||
IMPORT_DATA_SET_ID | NUMBER | 18 | Yes | Unique identifier to call the control budget import process. | |
BUDGET_SEGMENT1 | VARCHAR2 | 30 | First budget segment of the control budget. | ||
BUDGET_SEGMENT2 | VARCHAR2 | 30 | Second budget segment of the control budget. | ||
BUDGET_SEGMENT3 | VARCHAR2 | 30 | Third budget segment of the control budget. | ||
BUDGET_SEGMENT4 | VARCHAR2 | 30 | Fourth budget segment of the control budget. | ||
BUDGET_SEGMENT5 | VARCHAR2 | 30 | Fifth budget segment of the control budget. | ||
BUDGET_SEGMENT6 | VARCHAR2 | 30 | Sixth budget segment of the control budget. | ||
BUDGET_SEGMENT7 | VARCHAR2 | 30 | Seventh budget segment of the control budget. | ||
BUDGET_SEGMENT8 | VARCHAR2 | 30 | Eighth budget segment of the control budget. | ||
BUDGET_SEGMENT9 | VARCHAR2 | 30 | Ninth budget segment of the control budget. | ||
BUDGET_SEGMENT10 | VARCHAR2 | 30 | Tenth budget segment of the control budget. | ||
BUDGET_SEGMENT11 | VARCHAR2 | 30 | Eleventh budget segment of the control budget. | ||
BUDGET_SEGMENT12 | VARCHAR2 | 30 | Twelfth budget segment of the control budget. | ||
BUDGET_SEGMENT13 | VARCHAR2 | 30 | Thirteenth budget segment of the control budget. | ||
BUDGET_SEGMENT14 | VARCHAR2 | 30 | Fourteenth budget segment of the control budget. | ||
BUDGET_SEGMENT15 | VARCHAR2 | 30 | Fifteenth budget segment of the control budget. | ||
BUDGET_SEGMENT16 | VARCHAR2 | 30 | Sixteenth budget segment of the control budget. | ||
BUDGET_SEGMENT17 | VARCHAR2 | 30 | Seventeenth budget segment of the control budget. | ||
BUDGET_SEGMENT18 | VARCHAR2 | 30 | Eighteenth budget segment of the control budget. | ||
BUDGET_SEGMENT19 | VARCHAR2 | 30 | Nineteenth budget segment of the control budget. | ||
BUDGET_SEGMENT20 | VARCHAR2 | 30 | Twentieth budget segment of the control budget. | ||
BUDGET_SEGMENT21 | VARCHAR2 | 30 | Twenty-first budget segment of the control budget. | ||
BUDGET_SEGMENT22 | VARCHAR2 | 30 | Twenty-second budget segment of the control budget. | ||
BUDGET_SEGMENT23 | VARCHAR2 | 30 | Twenty-third budget segment of the control budget. | ||
BUDGET_SEGMENT24 | VARCHAR2 | 30 | Twenty-fourth budget segment of the control budget. | ||
BUDGET_SEGMENT25 | VARCHAR2 | 30 | Twenty-fifth budget segment of the control budget. | ||
BUDGET_SEGMENT26 | VARCHAR2 | 30 | Twenty-sixth budget segment of the control budget. | ||
BUDGET_SEGMENT27 | VARCHAR2 | 30 | Twenty-seventh budget segment of the control budget. | ||
BUDGET_SEGMENT28 | VARCHAR2 | 30 | Twenty-eighth budget segment of the control budget. | ||
BUDGET_SEGMENT29 | VARCHAR2 | 30 | Twenty-ninth budget segment of the control budget. | ||
BUDGET_SEGMENT30 | VARCHAR2 | 30 | Thirtieth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE1 | VARCHAR2 | 30 | Indicates if the mapped segment of the control budget's first budget segment is one of these: COA segment,project DFF segment or project element. | ||
SOURCE_SEGMENT_TYPE2 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of second budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE3 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of third budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE4 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fourth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE5 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fifth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE6 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of sixth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE7 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of seventh budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE8 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eighth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE9 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of ninth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE10 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of tenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE11 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eleventh budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE12 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twelfth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE13 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of thirteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE14 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fourteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE15 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fifteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE16 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of sixteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE17 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of seventeenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE18 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eighteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE19 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of nineteenth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE20 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twentieth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE21 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-first budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE22 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-second budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE23 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-third budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE24 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-fourth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE25 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-fifth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE26 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-sixth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE27 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-seventh budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE28 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-eighth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE29 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-ninth budget segment of the control budget. | ||
SOURCE_SEGMENT_TYPE30 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of thirtieth budget segment of the control budget. | ||
TREE_STRUCTURE_CODE1 | VARCHAR2 | 30 | Unique tree structure code identifier for the first segment. | ||
TREE_STRUCTURE_CODE2 | VARCHAR2 | 30 | Unique tree structure code identifier for the second segment. | ||
TREE_STRUCTURE_CODE3 | VARCHAR2 | 30 | Unique tree structure code identifier for the third segment. | ||
TREE_STRUCTURE_CODE4 | VARCHAR2 | 30 | Unique tree structure code identifier for the fourth segment. | ||
TREE_STRUCTURE_CODE5 | VARCHAR2 | 30 | Unique tree structure code identifier for the fifth segment. | ||
TREE_STRUCTURE_CODE6 | VARCHAR2 | 30 | Unique tree structure code identifier for the sixth segment. | ||
TREE_STRUCTURE_CODE7 | VARCHAR2 | 30 | Unique tree structure code identifier for the seventh segment. | ||
TREE_STRUCTURE_CODE8 | VARCHAR2 | 30 | Unique tree structure code identifier for the eighth segment. | ||
TREE_STRUCTURE_CODE9 | VARCHAR2 | 30 | Unique tree structure code identifier for the ninth segment. | ||
TREE_STRUCTURE_CODE10 | VARCHAR2 | 30 | Unique tree structure code identifier for the tenth segment. | ||
TREE_STRUCTURE_CODE11 | VARCHAR2 | 30 | Unique tree structure code identifier for the eleventh segment. | ||
TREE_STRUCTURE_CODE12 | VARCHAR2 | 30 | Unique tree structure code identifier for the twelfth segment. | ||
TREE_STRUCTURE_CODE13 | VARCHAR2 | 30 | Unique tree structure code identifier for the thirteenth segment. | ||
TREE_STRUCTURE_CODE14 | VARCHAR2 | 30 | Unique tree structure code identifier for the fourteenth segment. | ||
TREE_STRUCTURE_CODE15 | VARCHAR2 | 30 | Unique tree structure code identifier for the fifteenth segment. | ||
TREE_STRUCTURE_CODE16 | VARCHAR2 | 30 | Unique tree structure code identifier for the sixteenth segment. | ||
TREE_STRUCTURE_CODE17 | VARCHAR2 | 30 | Unique tree structure code identifier for the seventeenth segment. | ||
TREE_STRUCTURE_CODE18 | VARCHAR2 | 30 | Unique tree structure code identifier for the eighteenth segment. | ||
TREE_STRUCTURE_CODE19 | VARCHAR2 | 30 | Unique tree structure code identifier for the nineteenth segment. | ||
TREE_STRUCTURE_CODE20 | VARCHAR2 | 30 | Unique tree structure code identifier for the twentieth segment. | ||
TREE_STRUCTURE_CODE21 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-first segment. | ||
TREE_STRUCTURE_CODE22 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-second segment. | ||
TREE_STRUCTURE_CODE23 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-third segment. | ||
TREE_STRUCTURE_CODE24 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-fourth segment. | ||
TREE_STRUCTURE_CODE25 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-fifth segment. | ||
TREE_STRUCTURE_CODE26 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-sixth segment. | ||
TREE_STRUCTURE_CODE27 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-seventh segment. | ||
TREE_STRUCTURE_CODE28 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-eighth segment. | ||
TREE_STRUCTURE_CODE29 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-ninth segment. | ||
TREE_STRUCTURE_CODE30 | VARCHAR2 | 30 | Unique tree structure code identifier for the thirtieth segment. | ||
TREE_CODE1 | VARCHAR2 | 30 | Unique tree code identifier for the first segment. | ||
TREE_CODE2 | VARCHAR2 | 30 | Unique tree code identifier for the second segment. | ||
TREE_CODE3 | VARCHAR2 | 30 | Unique tree code identifier for the third segment. | ||
TREE_CODE4 | VARCHAR2 | 30 | Unique tree code identifier for the fourth segment. | ||
TREE_CODE5 | VARCHAR2 | 30 | Unique tree code identifier for the fifth segment. | ||
TREE_CODE6 | VARCHAR2 | 30 | Unique tree code identifier for the sixth segment. | ||
TREE_CODE7 | VARCHAR2 | 30 | Unique tree code identifier for the seventh segment. | ||
TREE_CODE8 | VARCHAR2 | 30 | Unique tree code identifier for the eighth segment. | ||
TREE_CODE9 | VARCHAR2 | 30 | Unique tree code identifier for the ninth segment. | ||
TREE_CODE10 | VARCHAR2 | 30 | Unique tree code identifier for the tenth segment. | ||
TREE_CODE11 | VARCHAR2 | 30 | Unique tree code identifier for the eleventh segment. | ||
TREE_CODE12 | VARCHAR2 | 30 | Unique tree code identifier for the twelfth segment. | ||
TREE_CODE13 | VARCHAR2 | 30 | Unique tree code identifier for the thirteenth segment. | ||
TREE_CODE14 | VARCHAR2 | 30 | Unique tree code identifier for the fourteenth segment. | ||
TREE_CODE15 | VARCHAR2 | 30 | Unique tree code identifier for the fifteenth segment. | ||
TREE_CODE16 | VARCHAR2 | 30 | Unique tree code identifier for the sixteenth segment. | ||
TREE_CODE17 | VARCHAR2 | 30 | Unique tree code identifier for the seventeenth segment. | ||
TREE_CODE18 | VARCHAR2 | 30 | Unique tree code identifier for the eighteenth segment. | ||
TREE_CODE19 | VARCHAR2 | 30 | Unique tree code identifier for the nineteenth segment. | ||
TREE_CODE20 | VARCHAR2 | 30 | Unique tree code identifier for the twentieth segment. | ||
TREE_CODE21 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-first segment. | ||
TREE_CODE22 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-second segment. | ||
TREE_CODE23 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-third segment. | ||
TREE_CODE24 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-fourth segment. | ||
TREE_CODE25 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-fifth segment. | ||
TREE_CODE26 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-sixth segment. | ||
TREE_CODE27 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-seventh segment. | ||
TREE_CODE28 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-eighth segment. | ||
TREE_CODE29 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-ninth segment. | ||
TREE_CODE30 | VARCHAR2 | 30 | Unique tree code identifier for the thirtieth segment. | ||
TREE_VERSION_ID1 | VARCHAR2 | 32 | Unique tree version identifier for the first segment. | ||
TREE_VERSION_ID2 | VARCHAR2 | 32 | Unique tree version identifier for the second segment. | ||
TREE_VERSION_ID3 | VARCHAR2 | 32 | Unique tree version identifier for the third segment. | ||
TREE_VERSION_ID4 | VARCHAR2 | 32 | Unique tree version identifier for the fourth segment. | ||
TREE_VERSION_ID5 | VARCHAR2 | 32 | Unique tree version identifier for the fifth segment. | ||
TREE_VERSION_ID6 | VARCHAR2 | 32 | Unique tree version identifier for the sixth segment. | ||
TREE_VERSION_ID7 | VARCHAR2 | 32 | Unique tree version identifier for the seventh segment. | ||
TREE_VERSION_ID8 | VARCHAR2 | 32 | Unique tree version identifier for the eighth segment. | ||
TREE_VERSION_ID9 | VARCHAR2 | 32 | Unique tree version identifier for the ninth segment. | ||
TREE_VERSION_ID10 | VARCHAR2 | 32 | Unique tree version identifier for the tenth segment. | ||
TREE_VERSION_ID11 | VARCHAR2 | 32 | Unique tree version identifier for the eleventh segment. | ||
TREE_VERSION_ID12 | VARCHAR2 | 32 | Unique tree version identifier for the twelfth segment. | ||
TREE_VERSION_ID13 | VARCHAR2 | 32 | Unique tree version identifier for the thirteenth segment. | ||
TREE_VERSION_ID14 | VARCHAR2 | 32 | Unique tree version identifier for the fourteenth segment. | ||
TREE_VERSION_ID15 | VARCHAR2 | 32 | Unique tree version identifier for the fifteenth segment. | ||
TREE_VERSION_ID16 | VARCHAR2 | 32 | Unique tree version identifier for the sixteenth segment. | ||
TREE_VERSION_ID17 | VARCHAR2 | 32 | Unique tree version identifier for the seventeenth segment. | ||
TREE_VERSION_ID18 | VARCHAR2 | 32 | Unique tree version identifier for the eighteenth segment. | ||
TREE_VERSION_ID19 | VARCHAR2 | 32 | Unique tree version identifier for the nineteenth segment. | ||
TREE_VERSION_ID20 | VARCHAR2 | 32 | Unique tree version identifier for the twentieth segment. | ||
TREE_VERSION_ID21 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-first segment. | ||
TREE_VERSION_ID22 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-second segment. | ||
TREE_VERSION_ID23 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-third segment. | ||
TREE_VERSION_ID24 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-fourth segment. | ||
TREE_VERSION_ID25 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-fifth segment. | ||
TREE_VERSION_ID26 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-sixth segment. | ||
TREE_VERSION_ID27 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-seventh segment. | ||
TREE_VERSION_ID28 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-eighth segment. | ||
TREE_VERSION_ID29 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-ninth segment. | ||
TREE_VERSION_ID30 | VARCHAR2 | 32 | Unique tree version identifier for the thirtieth segment. | ||
TREE_LABEL_ID1 | VARCHAR2 | 32 | Unique tree label identifier for the first segment. | ||
TREE_LABEL_ID2 | VARCHAR2 | 32 | Unique tree label identifier for the second segment. | ||
TREE_LABEL_ID3 | VARCHAR2 | 32 | Unique tree label identifier for the third segment. | ||
TREE_LABEL_ID4 | VARCHAR2 | 32 | Unique tree label identifier for the fourth segment. | ||
TREE_LABEL_ID5 | VARCHAR2 | 32 | Unique tree label identifier for the fifth segment. | ||
TREE_LABEL_ID6 | VARCHAR2 | 32 | Unique tree label identifier for the sixth segment. | ||
TREE_LABEL_ID7 | VARCHAR2 | 32 | Unique tree label identifier for the seventh segment. | ||
TREE_LABEL_ID8 | VARCHAR2 | 32 | Unique tree label identifier for the eighth segment. | ||
TREE_LABEL_ID9 | VARCHAR2 | 32 | Unique tree label identifier for the ninth segment. | ||
TREE_LABEL_ID10 | VARCHAR2 | 32 | Unique tree label identifier for the tenth segment. | ||
TREE_LABEL_ID11 | VARCHAR2 | 32 | Unique tree label identifier for the eleventh segment. | ||
TREE_LABEL_ID12 | VARCHAR2 | 32 | Unique tree label identifier for the twelfth segment. | ||
TREE_LABEL_ID13 | VARCHAR2 | 32 | Unique tree label identifier for the thirteenth segment. | ||
TREE_LABEL_ID14 | VARCHAR2 | 32 | Unique tree label identifier for the fourteenth segment. | ||
TREE_LABEL_ID15 | VARCHAR2 | 32 | Unique tree label identifier for the fifteenth segment. | ||
TREE_LABEL_ID16 | VARCHAR2 | 32 | Unique tree label identifier for the sixteenth segment. | ||
TREE_LABEL_ID17 | VARCHAR2 | 32 | Unique tree label identifier for the seventeenth segment. | ||
TREE_LABEL_ID18 | VARCHAR2 | 32 | Unique tree label identifier for the eighteenth segment. | ||
TREE_LABEL_ID19 | VARCHAR2 | 32 | Unique tree label identifier for the nineteenth segment. | ||
TREE_LABEL_ID20 | VARCHAR2 | 32 | Unique tree label identifier for the twentieth segment. | ||
TREE_LABEL_ID21 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-first segment. | ||
TREE_LABEL_ID22 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-second segment. | ||
TREE_LABEL_ID23 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-third segment. | ||
TREE_LABEL_ID24 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-fourth segment. | ||
TREE_LABEL_ID25 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-fifth segment. | ||
TREE_LABEL_ID26 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-sixth segment. | ||
TREE_LABEL_ID27 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-seventh segment. | ||
TREE_LABEL_ID28 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-eighth segment. | ||
TREE_LABEL_ID29 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-ninth segment. | ||
TREE_LABEL_ID30 | VARCHAR2 | 32 | Unique tree label identifier for the thirtieth segment. | ||
OBJECT_ID | NUMBER | 18 | Yes | Unique object identifier for internal use by Project Portfolio Management and U.S. Federal Financials. | |
FV_TYPE_CODE | VARCHAR2 | 30 | Indicates the budgetary control processing type code of the control budget. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
XCC_CONTROL_BUDGETS_GT_N1 | Non Unique | OBJECT_ID |
XCC_CONTROL_BUDGETS_GT_U1 | Unique | NAME |