Home Up Contents

 Univ EntRelRpt
Back Next

 

Home
Up

 

University Global Data Model

Entity/Relationship Business Rule Report

Subject Area: ACCOUNTING

Business Rule
Each ACCOUNT may be combined with an object code to create one or more ACCOUNT OBJECT
may be the guarantor of one or more ACCOUNT GUARANTOR
may be the responsible employee for one or more ACCOUNT CUSTODIAN
may guarantee deficits for one or more ACCOUNT GUARANTOR
may have interest credited from one or more ACCOUNT INTEREST ACCOUNT
may have interest credited to one or more ACCOUNT INTEREST ACCOUNT
must be one and only one REVENUE EXPENSE ACCOUNT or...
BALANCE SHEET ACCOUNT
must be a grant or contract identified by one and only one SPONSOR
must be an overhead rate defined in one and only one OVERHEAD RATE
must be categorized by one and only one NACUBO CLASS
must be related to one and only one ORGANIZATION
must define the account as being a general ledger or subsidary ledger in one and only one STATEMENT TYPE CODE
must have a fund-sub fund specified by one and only one SUB FUND
must have a letter of credit applied in one and only one LETTER OF CREDIT
must have a year-end processing code in one and only one YEAR END PROCESSING CODE
must have an account executive in one and only one PERSON
must have its deletion type defined in one and only one DELETE CODE
Each ACCOUNT BALANCE must be one and only one REVENUE EXPENSE LEDGER or...
BALANCE SHEET LEDGER
must be a balance for one and only one ACCOUNT OBJECT
must be a balance in one and only one ACCOUNTING PERIOD
Each ACCOUNT CUSTODIAN must be assigned to one and only one PERSON
must have a type specified by one and only one ACCOUNT CUSTODIAN TYPE
must have an employee defined as being responsible in one and only one ACCOUNT
Each ACCOUNT CUSTODIAN TYPE may specify a type for one or more ACCOUNT CUSTODIAN
Each ACCOUNT GUARANTOR must guarantee one and only one ACCOUNT
must guarantee deficit for one and only one ACCOUNT
Each ACCOUNT INTEREST ACCOUNT must be an account in one and only one ACCOUNT
must specify an account to accumulate interest for one and only one ACCOUNT
Each ACCOUNT OBJECT may account for gifts donated by one or more GIFT
may account for salary paid to one or more PAYROLL SALARY HISTORY
may account funds for one or more BUDGETED SALARY SUPPLEMENT
may be a balance for an account identified in one or more ACCOUNT BALANCE
may be an organization of one or more ORGANIZATION DEFAULT ACCOUNT
may be the financial aid charge account for one or more FINANCIAL AID AWARD PROGRAM
may categorize funds for one or more NON BUDGETED SALARY
may designate a true account object for one or more HOURLY PERSONNEL STATIC BUDGET
may have a budget build transaction specified by one or more BUDGET RECOMMEND TRANSACTION
may have an assignment in one or more ASSIGNMENT ACCOUNT DISTRIBUTION
may have assets charged against it in one or more FIXED ASSET COMPONENT
may have budget changes identified by one or more BUDGET CHANGE TRANSACTION
may have money pledged in one or more PLEDGE
may have purchases distributed for one or more PURCHASE ORDER ACCOUNT DISTRIBUTION
may have transactions recorded in one or more LEDGER TRANSACTION
may identify the account object for one or more BUDGETED AMOUNT FOR SALARY SUPPLEMENT
may specify an account-object for one or more INCOME AND NON PERSONAL SERVICES STATIC BUDGET
may track funds for one or more POSITION PERSONNEL STATIC BUDGET
must be comprised of one and only one ACCOUNT
must be comprised of sub accounts in one and only one OBJECT CODE
must have an award specified by one and only one PROJECT BUDGET
Each ACCOUNTING PERIOD may define the depreciation schedule for one or more DEPRECIATION SCHEDULE
may define the purchase period of an asset in one or more FIXED ASSET
may have balances for an account in one or more ACCOUNT BALANCE
may have transactions recorded in one or more LEDGER TRANSACTION
must be a period in one and only one FISCAL YEAR
Each ACCOUNTS PAYABLE JOURNAL must be classified as a 1099 category in one and only one 1099 CATEGORY
must be of one and only one LEDGER TRANSACTION
must have been created though a voucher in one and only one VOUCHER
must have its A21 code defined in one and only one A21 CODE
Each ACCOUNTS RECEIVABLE JOURNAL must be of one and only one LEDGER TRANSACTION
must record transactions for one and only one STUDENT
Each BALANCE SHEET ACCOUNT may be an x-reference account for one or more REVENUE EXPENSE ACCOUNT
must be grouped by one and only one DFSR CODE
must be of one and only one ACCOUNT
must have a method of allocating interest to it in one and only one INTEREST ALLOCATION CODE
Each BALANCE SHEET LEDGER must be of one and only one ACCOUNT BALANCE
Each BALANCE SHEET OBJECT TYPE must be of one and only one OBJECT TYPE
Each CHARGE TYPE may define the type of charges for one or more OBJECT CODE
Each DELETE CODE may define the deletion type of an account in one or more ACCOUNT
Each DFSR CODE may classify one or more BALANCE SHEET ACCOUNT
Each DONATION must be of one and only one LEDGER TRANSACTION
Each EMPLOYEE may approve one or more PURCHASE ORDER
may approve budget changes for one or more BUDGET CHANGE APPROVAL
may be a student university application for one or more STUDENT ACCEPTANCE ACTION
may be assigned to one or more ASSIGNMENT
may be assigned to fill an open position in a one or more BUDGET POSITION CHANGE
may be budgeted to earn one or more BUDGET SALARY RATE
may be compensated with one or more NON BUDGETED SALARY
may be originally assigned to fill one or more POSITION PERSONNEL STATIC BUDGET
may be paid a rate specified in one or more EMPLOYEE PAY RATE
may be the custodian for one or more EQUIPMENT
may be the evaluator for one or more STUDENT APPLICATION ACTION
may be the primary recruiter for one or more HIGH SCHOOL
may be the technical contact for one and only one ORGANIZATION
may create transactions in one or more LEDGER TRANSACTION
may enter PO in one or more PURCHASE ORDER
may have absences recorded in one or more EMPLOYEE ABSENCE
may have actions recorded in one or more EMPLOYEE ACTION
may have benefits identified in one or more EMPLOYEE BENEFIT
may have checks deposited directly into one or more EMPLOYEE DIRECT DEPOSIT ACCOUNT
may have date sensitive salary in one or more EMPLOYEE SALARY
may have earned one or more PAYROLL SALARY HISTORY
may have payroll transactions recorded in one or more PAYROLL JOURNAL
may have their leave in one or more EMPLOYEE LEAVE
may issue a purchase order defined in one or more PURCHASE ORDER
may make comments about one or more VENDOR COMMENT
may manage one or more ORGANIZATION
may record the payment of one or more STUDENT APPLICATION FEE
must be of one and only one PERSON
must be primarily employed by one and only one ORGANIZATION
must have one and only one EXEMPT CODE
must have a current status in one and only one EMPLOYMENT STATUS
must have their military reserve status identified by one and only one MILITARY RESERVE STATUS
Each FISCAL YEAR may define one or more ACCOUNTING PERIOD
may designate a fiscal year for one or more INCOME AND NON PERSONAL SERVICES STATIC BUDGET
may designate an accounting fiscal year for one or more HOURLY PERSONNEL STATIC BUDGET
may designate the fiscal year for one or more BUDGET PRICE LEVEL CATEGORY
may identify a fiscal year for one or more BUDGETED SALARY SUPPLEMENT
may identify the fiscal year for one or more BUDGETED AMOUNT FOR SALARY SUPPLEMENT
may identify the fiscal year for an employees one or more BUDGET SALARY RATE
may indicate a fiscal year for one or more POSITION PERSONNEL STATIC BUDGET
may specify a fiscal year for a batch in one or more BUDGET CHANGE BATCH
may specify the year of one or more BUDGET RECOMMEND TRANSACTION
may stipulate the fiscal year for one or more BUDGET PRICE LEVEL DETAIL
may witness the university president making one or more UNIVERSITY PRESIDENT BUDGET RECOMMENDATION
Each FUND may be a type of funding for one or more LETTER OF CREDIT
may contain multiple accounts in one or more FUND OBJECT TYPE
may define the type of funding for one or more SUB FUND
may have budget transfers restricted one and only one BUDGET TRANSFER RESTRICTION
may have statement types in one or more FUND STATEMENT TYPE
Each FUND OBJECT TYPE must define the valid object codes for one and only one FUND
must have an object type specified by one and only one OBJECT TYPE
Each FUND STATEMENT TYPE must define the statement types for one and only one FUND
must define the valid statement types for a fund by one and only one STATEMENT TYPE CODE
Each GENERAL JOURNAL must be of one and only one LEDGER TRANSACTION
Each INTEREST ALLOCATION CODE may define how an account has interest allocated in one or more BALANCE SHEET ACCOUNT
Each INTERNAL SERVICE CHARGE ADVICE must be of one and only one LEDGER TRANSACTION
Each INVENTORY TRANSACTION must be of one and only one LEDGER TRANSACTION
must record the inventory transactions for one and only one ITEM
Each LEDGER TRANSACTION must be one and only one PAYROLL JOURNAL or...
RENT RECEIVABLE JOURNAL or...
GENERAL JOURNAL or...
DONATION or...
INTERNAL SERVICE CHARGE ADVICE or...
INVENTORY TRANSACTION or...
FINANCIAL AID DISBURSEMENT JOURNAL or...
ACCOUNTS RECEIVABLE JOURNAL or...
TRANSFER JOURNAL or...
ACCOUNTS PAYABLE JOURNAL or...
TUITION RECEIVABLE JOURNAL
must be a transaction against one and only one ACCOUNT OBJECT
must be created by one and only one EMPLOYEE
must be recorded in one and only one ACCOUNTING PERIOD
must have its payment type defined in one and only one PAYMENT TYPE
Each LETTER OF CREDIT may be applied to one or more ACCOUNT
must be a funding type in one and only one FUND
must have its sponsor defined in one and only one SPONSOR
Each MAIL CODE may be the mailing location for one or more VENDOR MAIL CODE
may define the mail location for one or more VENDOR INVOICE MAIL CODE
may identify a mail code for one or more ORGANIZATION
may specify a mail code for one or more PERSON MAIL CODE
must be assigned to one and only one ROOM
Each NACUBO CLASS may be categorized by one or more ACCOUNT
must have its function defined in one and only one NACUBO FUNCTION
Each NACUBO FUNCTION may define the function for one or more NACUBO CLASS
Each OBJECT CODE may be assigned to one or more BUDGET OBJECT CODE CATEGORY
may be used as part of one or more ACCOUNT OBJECT
must be defined as being a type of account in one and only one OBJECT TYPE
must have its charge type identified in one and only one CHARGE TYPE
Each OBJECT TYPE may classify the type of sub account in one or more OBJECT CODE
may have an object type hierarchy defined in one or more OBJECT TYPE HIERARCHY
may have its hierarchy defined in one or more OBJECT TYPE HIERARCHY
may may be listed in one and only one BUDGET TRANSFER OBJECT TYPE CHANGE REQUIRE APPROVAL
may specify an object type for one or more FUND OBJECT TYPE
must be one and only one REVENUE EXPENSE OBJECT TYPE or...
BALANCE SHEET OBJECT TYPE
must have its statement type defined in one and only one STATEMENT TYPE CODE
Each OBJECT TYPE HIERARCHY must be the dependent object type of one and only one OBJECT TYPE
must define the hierarchy of one and only one OBJECT TYPE
Each OBJECT_CLASS may be a from class for one and only one BUDGET TRANSFER OBJECT CLASS CHANGE REQUIRE APPROVAL
may identifies a general classification for one or more REVENUE EXPENSE OBJECT TYPE
may ma be a to class for one and only one BUDGET TRANSFER OBJECT CLASS CHANGE REQUIRE APPROVAL
Each ORGANIZATION may award and control one or more FINANCIAL AID AWARD PROGRAM
may be a responsible organization for one or more UNIVERSITY STUDY DEGREE
may be housed in one or more ROOM DETAIL
may be responsible for one or more ORGANIZATION STRUCTURE
may be responsible for an asset in one or more FIXED ASSET
may be responsible to one or more ORGANIZATION STRUCTURE
may be the owner of a course in one or more MASTER COURSE
may have a mailing address specified by one or more ADDRESS
may have an account-object in one or more ORGANIZATION DEFAULT ACCOUNT
may have charges incurred in one or more ACCOUNT
may have its classes in one or more CLASS DIRECTORY
may have its course equivalents for their major in one or more MAJOR COURSE EQUIVALENT
may have its phone number defined in one or more PHONE NUMBER
may have subject areas assigned in one or more DEGREE SUBJECT
may indicate an organization for one or more BUILDING SCHEDULING PRIORITY
may issue one or more PURCHASE ORDER
may lease one or more EQUIPMENT
may owns one or more ROOM
may perform orientations in one or more STUDENT ORIENTATION
may place a hold on one or more STUDENT RECORD HOLD
may place a hold on a person in one or more UNIVERSITY HOLD PERSON
may primarily employee one or more EMPLOYEE
may receive visits from recruits in one or more DEPARTMENTAL VISIT
may schedules one or more ROOM DETAIL
may send correspondence to one or more STUDENT CORRESPONDENCE
may specify a sponsoring organization for one or more EVENT
must be managed by one and only one EMPLOYEE
must have a mail code identified by one and only one MAIL CODE
must have its techical contact defined by one and only one EMPLOYEE
must have its type defined in one and only one ORGANIZATION TYPE
Each ORGANIZATION STRUCTURE must be responsible for one and only one ORGANIZATION
must have a rollup type specified by one and only one ORGANIZATION STRUCTURE TYPE
must have responsibility for one and only one ORGANIZATION
Each ORGANIZATION STRUCTURE TYPE may specify a rollup type for one or more ORGANIZATION STRUCTURE
Each ORGANIZATION TYPE may categorize the organization type of one or more EXTERNAL ORGANIZATION
may describe the type of organization for one or more ORGANIZATION
Each OVERHEAD CLASS may be assigned one or more OVERHEAD RATE
Each OVERHEAD RATE may be a rate for one or more ACCOUNT
must be a overhead class in one and only one OVERHEAD CLASS
Each PAYROLL JOURNAL must be of one and only one LEDGER TRANSACTION
must define payroll transactions for one and only one EMPLOYEE
must have transaction dates in one and only one PAYROLL CALENDAR
must record transactions classified as one and only one EMPLOYEE PAY TYPE
Each PERSON may attend a meal defined in one or more MEAL ATTENDANCE
may be a citizen on one or more PERSON CITIZENSHIP
may be a mailing type for one or more PERSON MAILING
may be a member of one or more HONOR SOCIETY PERSON
may be a memorial recipient of one or more GIFT
may be a recruiting resource defined in one or more RECRUITING RESOURCE PERSON
may be a relative of one or more PERSON RELATIONSHIP
may be a social member of one or more SOCIAL ORGANIZATION PERSON
may be a student athlete identified in one or more STUDENT ATHLETE
may be a university hold code for one or more UNIVERSITY HOLD PERSON
may be an account custodian defined in one or more ACCOUNT CUSTODIAN
may be an account executive for one or more ACCOUNT
may be an agency administrator for one or more PRINCIPAL INVESTIGATOR
may be assigned as the advisor for one or more UNIVERSITY STUDY DEGREE
may be identified as the owner member of one or more CAMPUS REC MEMBER
may be issued a parking sticker in one or more PARKING STICKER
may be located in one or more ADDRESS
may be the primary contact for one or more RECRUIT EVENT SCHEDULE
may be the recipient of one or more BUDGETED SALARY SUPPLEMENT
may change one or more STUDENT GRADE CHANGE
may donate a gift identified in one or more GIFT
may earn a certificate defined in one or more PERSON CERTIFICATE
may evaluate the insurance requirements for one or more PERSON INSURANCE
may have a mail code specified by one or more PERSON MAIL CODE
may have a phone number in one or more PHONE NUMBER
may have a prior identification contained in one or more PERSON ID HISTORY
may have a type of degree defined by one or more PERSON DEGREE
may have admission test scores in227 one or more STUDENT ADMISSION TEST
may have an affiliation with one or more EXTERNAL ORGANIZATION PERSON
may have an electronic address in one or more ELECTRONIC MAIL ADDRESS
may have an interest in studying in a particular area defined in one or more PERSON AMERICAN TESTING INTEREST
may have history recorded in one or more PERSON ID HISTORY
may have skills defined in one or more SKILL INVENTORY
may have survey information in one or more MARTS & LUNDY SURVEY
may have their correspondence tracked in one or more STUDENT CORRESPONDENCE
may have their inoculations recorded in one or more STUDENT INOCULATION
may have their insurance information recorded in one or more PERSON INSURANCE
may have their relationship to another person identified in one or more PERSON RELATIONSHIP
may hold one or more LICENSE
may identified by one or more ACCESS ID
may pledge money in one or more PLEDGE
may specify a member owner for one or more CAMPUS REC MEMBERSHIP
may specify a person as an instructor by one or more INDIVIDUAL INSTRUCTION COURSE
may specify a person requesting event space by one or more EVENT
may submit financial aid requests on one or more STUDENT FINANCIAL AID APPLICATION
may teach classes assigned in one or more INSTRUCTOR ASSIGNMENT
must be one and only one EMPLOYEE or...
STUDENT RECRUIT or...
STUDENT APPLICANT or...
STUDENT or...
EMPLOYEE APPLICANT or...
DONOR
must be assigned a VISA code identified by one and only one VISA CODE
must be known as one or more PERSON NAME HISTORY
must have a salutation prefix specified by one and only one SALUTATION PREFIX
must have a veteran code specified by one and only one VETERAN CODE
must have an orphan classification in one and only one ORPHAN CODE
must have their ethnic origins defined in one and only one ETHNIC CODE
must have their marital status identified by one and only one MARITAL STATUS
must have their profession defined by one and only one PROFESSION TYPE
must have their sex defined in one and only one SEX CODE
must have their veteran chapter benefits defined in one and only one VETERAN CHAPTER CODE
Each PERSON MAIL CODE must have a mail code specified by one and only one MAIL CODE
must have their mail type defined in one and only one PERSON MAIL TYPE
must specify a mail code for one and only one PERSON
Each PERSON MAIL TYPE may have their mail code in one or more PERSON MAIL CODE
Each RENT RECEIVABLE JOURNAL must be of one and only one LEDGER TRANSACTION
Each REVENUE EXPENSE ACCOUNT must be an x-reference account for one and only one BALANCE SHEET ACCOUNT
must be of one and only one ACCOUNT
Each REVENUE EXPENSE LEDGER must be of one and only one ACCOUNT BALANCE
Each REVENUE EXPENSE OBJECT TYPE must be of one and only one OBJECT TYPE
must is classified as one and only one OBJECT_CLASS
Each SPONSOR may be the sponsor of a letter of credit in one or more LETTER OF CREDIT
may have charges incurred against one or more ACCOUNT
Each STATEMENT TYPE CODE may be valid for a set of funds in one or more FUND STATEMENT TYPE
may have its general ledger or subsidary ledger type defined in one or more ACCOUNT
may have its object type defined in one or more OBJECT TYPE
Each SUB FUND may have a budget transfer exception specified in one and only one BUDGET TRANSFER RESTRICTION EXCEPTION
may specify a fund-sub fund for one or more ACCOUNT
must have one and only one FUND
Each TRANSFER JOURNAL must be of one and only one LEDGER TRANSACTION
Each TUITION RECEIVABLE JOURNAL must be of one and only one LEDGER TRANSACTION
must be received in a term specified in one and only one TERM
Each YEAR END PROCESSING CODE may describe the type of processing to occur against one or more ACCOUNT
 

 

Back ] Home ] Up ] Next ]

Send mail to caseware@cwti.com with questions or comments about this web site.
Copyright © 2000 CASEware Technology Inc.
Last modified: June 13, 2007