ACBRDNBLRX

This file contains burden bill rate information from the Burden Bill Rate (BR04.1). It includes the burdon code, type, pool number, effective date, rate and a fixed or ceiling flag for an activity. Burdens are additional costs that are assigned to transactions such as fringe, and G&A expenses. Burden transactions are created as separate activity transactions when AC190 (Activity Posting) is run. Burdens can be thought of as line level allocations required for Gov't Contracting and Grant Management industries. Specifically, this table maintains the billing rates for burden transactions.
UPDATED BY
AC190 AC197 AC198 AC300 AC62.1 BR04.1
BR204

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRX-ACTIVITY
Element: Activity
Alpha 15
The activity associated with the burden rate being established in Burden Bill Rates (BR04.1). The activity is created on Activity (AC10.1).
BR04.1
BRX-BURDEN-CD
Element: Burden Cd
Alpha 5
The burden code identifies the burden cost being calculated. The Burden Code is maintained on Burden Codes (AC60.1) and associated to an activity in Burden Bill Rates (BR04.1).
BR04.1
BRX-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date the burden code pool number rate will be in effect. The effective date is maintained in Burden Bill Rate (BR04.1) by pool number for an activity and burden code.
BR04.1
BRX-POOL-NBR
Element: Pool Nbr
Numeric 3
The pool number associated with the burden code maintained in Pool Driver Values (AC62.1).
BR04.1
BRX-BILL-BRDN-RATE
Element: Bill Brdn Rate
Signed 13.4
The rate associated with the pool number and effective date for a activity and burden code. The rate is maintained in Burden Bill Rates (BR04.1).
BR04.1
BRX-CEILING-FL
Element: Ceiling Fl
Alpha 1
The Ceiling Flag determines if the rate is a fixed rate or a ceiling rate. The flag is maintained in Burden Bill Rates (BR04.1). The values are: F = Fixed Bill Rate C = Ceiling If the value is Ceiling, the burden routine will use the lower of the cost rate defined on Burden Pool Rates(AC63.1) or the rate defined on Burden Bill Rates (BR04.1). If the value is Fixed, the burden routine will use the rate defined on Burden Bill Rates (BR04.1).
BR04.1
BRX-BURDEN-TYPE
Element: Burden Type
Alpha 1
Burden type specifies the type of calculation that is used to determine the total cost associated with a specific burden. The type is maintained on Burden Bill Rates (BR04.1) The values are: B = Billing R = Revenue
BR04.1


ACBRDNBLRX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRXSET1 ACTIVITY
BURDEN-CD
BURDEN-TYPE
POOL-NBR
EFFECTIVE-DATE
AC300 BR04.1
BR204
BRXSET2 ACTIVITY
BURDEN-CD
BURDEN-TYPE
POOL-NBR
EFFECTIVE-DATE*
AC190 AC197
AC198
BRXSET3 BURDEN-CD
BURDEN-TYPE
POOL-NBR
ACTIVITY
EFFECTIVE-DATE
AC62.1


ACBRDNBLRX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
BRX-ACTIVITY->ACV-ACTIVITY
Acbrdnblrt ACBRDNBLRT Required
BRX-ACTIVITY->BRT-ACTIVITY
BRX-BURDEN-CD->BRT-BURDEN-CD
BRX-BURDEN-TYPE->BRT-BURDEN-TYPE
Acbrdnhdr ACBRDNHDR Required
BRX-BURDEN-CD->BRH-BURDEN-CD
Acbrdnpool ACBRDNPOOL Required
BRX-BURDEN-CD->BPL-BURDEN-CD
BRX-POOL-NBR->BPL-POOL-NBR


File created: Thu Jun 09 11:10:48 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.