Contracts Flashcards
Contract Table
Stores the primary info about a contract
Drggroup table
holds one record for each rate group for drugs in the working enviornment
Payterm table
Houses all payment discount terms that you can apply to a contract
standardfee table
Houses header information for fee tables
contcapcat tables
stores capitation carve outs for the contract
capitation tables
stores capitation table header information
Capterm Table
Defines the rates for the capitation portion of the contract
Cappool table
Stores the risk pool associated with a specific capitaiton table and capitation term
riskpool table
Stores all available risk pools in the working enviornment
ContractTerm Table
Stores the primary info about the term of the contract
Termservice table
Stores the service codes for the term of contract
Svccode table
Stores all service codes available in the working enviornment
Revcode table
Stores all revenue codes available in thw working enviornment
modifier table
stores all modifier codes available in the working eviornment
TermDiag table
Stores the diagnoses codes for the term of a contract
Diagcode table
Stores all diagnosis codes available in the working enviornment
* codegroupd field corresponds to the group description in the user interface
Proccode Table
Stores all procedure codes available in the working enviornment
TermProc table
Stores the procedure codes for the term of a contract
TermGroup table
Stores the service groups for the term of a contract
SVCCATEGORY table
stores all service categories available in the working enviornment
svcsubcategory table
stores all service sub-categories available in the working eviornment
svccatgrouphdr table
stores the service category group descriptions
