ACCT_CD_TBL - Account Codes Table

This article provides information regarding the Account codes in the HRPRD data environment. 

Detail Information

Record.Fieldname Format Heading Text
ACCOUNT - Account Char10 Acct
ACCT_CD - Combination Code Char25 Combo Code
ACTIVITY_ID - Activity ID Char15 Activity
AFFILIATE - Affiliate Char5 Affl
AFFILIATE_INTRA1 - Fund Affiliate Char10 Fund Affil
AFFILIATE_INTRA2 - Operating Unit Affiliate Char10 Oper Unit Affil
ALTACCT - Alternate Account Char10 Alt Account
BUDGET_REF - Budget Reference Char8 Budget Ref
BUSINESS_UNIT_PC - Business Unit PC Char5 PC Bus Unit
CHARTFIELD1 - Chartfield 1 Char10 Chartfield1
CHARTFIELD2 - Chartfield 2 Char10 Chartfield2
CHARTFIELD3 - Chartfield 3 Char10 Chartfield3
CLASS_FLD - Class Field Char5 Class
DEPTID_CF - Department Char10 Dept ID
DESCR - Description Char30 Descr
DESCRSHORT - Short Description Char10 Short Desc
DIRECT_CHARGE - Direct Charge Char1 Direct
ENCUMB_ACCOUNT - Encumbrance Account Char10 Encum Acct
FDM_HASH - Hash function Char31 Hash
FUND_CODE - Fund Code Char5 Fund
OPERATING_UNIT - Operating Unit Char8 Operating Unit
PRE_ENCUMB_ACCOUNT - Pre-Encumbrance Account Char10 Pre Enc Ac
PRODUCT - Product Char6 Product
PROGRAM_CODE - Program Code Char5 Program
PROJECT_ID - Project Char15 Project
PRORATE_LIABILITY - Prorate Liability Indicator Char1 ProrateLib
RESOURCE_CATEGORY - Resource Category Char5 Category
RESOURCE_SUB_CAT - Resource Sub-Category Char5 RsrcSubCat
RESOURCE_TYPE - Resource Type Char5 RsrcType

Data Columns to be used as Keys

  • ACCT_CD - Combination Code
  • FDM_HASH - Hash function

Environment

  • HRPRD
Print Article