AWARD_FUNDING_PROPOSALS PK
AWARD_FUNDING_PROPOSAL_ID
FK1,I1 FK2,I1
AWARD_ID PROPOSAL_ID UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID ACTIVE
PROPOSAL PK
KRIM_PRNCPL_T AWARD_IDC_RATE PK
CLOSEOUT_REPORT_TYPE PK
CLOSEOUT_REPORT_CODE DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK FK1 FK2
PK
AWARD_EXEMPT_NUMBER_ID AWARD_SPECIAL_REVIEW_ID EXEMPTION_TYPE_CODE UPDATE_USER UPDATE_TIMESTAMP VER_NBR OBJ_ID
FK1
PK
EXPIRATION_DATE AWARD_ID VER_NBR OBJ_ID SPECIAL_REVIEW_NUMBER SPECIAL_REVIEW_CODE APPROVAL_TYPE_CODE PROTOCOL_NUMBER APPLICATION_DATE APPROVAL_DATE COMMENTS UPDATE_USER UPDATE_TIMESTAMP
PK
FK2,I1
AWARD_PAYMENT_SCHEDULE AWARD_PAYMENT_SCHEDULE_ID AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER DUE_DATE AMOUNT UPDATE_TIMESTAMP UPDATE_USER SUBMIT_DATE SUBMITTED_BY INVOICE_NUMBER STATUS_DESCRIPTION STATUS VER_NBR OBJ_ID
AWARD_ATTACHMENT PK FK3
FK2 AWARD_ATTACHMENT_TYPE PK
FK1
TYPE_CODE DESCRIPTION VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
ATTACHMENT_FILE PK
FILE_ID SEQUENCE_NUMBER FILE_NAME CONTENT_TYPE FILE_DATA VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
AWARD_ATTACHMENT_ID AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER TYPE_CODE DOCUMENT_ID FILE_ID DESCRIPTION VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
PK
PK
FK2 FK4 FK5
DOCUMENT_NUMBER VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
AWARD_APPROVED_EQUIPMENT PK
AWARD_APPROVED_EQUIPMENT_ID
FK1
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER ITEM VENDOR MODEL AMOUNT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FK1
FK1
AWARD_ID VER_NBR OBJ_ID SCIENCE_KEYWORD_CODE UPDATE_TIMESTAMP UPDATE_USER
AWARD_COMMENT PK
FK6
AWARD_COMMENT_ID AWARD_UNIT_CONTACTS
FK1
COMMENT_TYPE_CODE DESCRIPTION TEMPLATE_FLAG CHECKLIST_FLAG AWARD_COMMENT_SCREEN_FLAG UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER COMMENT_TYPE_CODE CHECKLIST_PRINT_FLAG COMMENTS UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
AWARD_UNIT_CONTACT_ID
FK2
FK1
FK3
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER PERSON_ID FULL_NAME UNIT_ADMINISTRATOR_TYPE_CODE UNIT_CONTACT_TYPE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID UNIT_ADMINISTRATOR_UNIT_NUMBER
PRNCPL_ID
FK5
AWARD_APPROVED_FOREIGN_TRAVEL PK
FK1 FK2
AWARD_ID FK4
CLOSEOUT_DATE TRANSACTION_TYPE_CODE NOTICE_DATE LEAD_UNIT_NUMBER ACTIVITY_TYPE_CODE AWARD_TYPE_CODE PRIME_SPONSOR_CODE CFDA_NUMBER METHOD_OF_PAYMENT_CODE DFAFS_NUMBER PRE_AWARD_AUTHORIZED_AMOUNT PRE_AWARD_EFFECTIVE_DATE PROCUREMENT_PRIORITY_CODE PROPOSAL_NUMBER SPECIAL_EB_RATE_OFF_CAMPUS SPECIAL_EB_RATE_ON_CAMPUS SUB_PLAN_FLAG TITLE VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER PRE_AWARD_IN_AUTHORIZED_AMOUNT ARCHIVE_LOCATION PRE_AWARD_INST_EFFECTIVE_DATE BASIS_OF_PAYMENT_CODE DOCUMENT_NUMBER AWARD_NUMBER SEQUENCE_NUMBER SPONSOR_CODE STATUS_CODE TEMPLATE_CODE ACCOUNT_NUMBER APPRVD_EQUIPMENT_INDICATOR APPRVD_FOREIGN_TRIP_INDICATOR APPRVD_SUBCONTRACT_INDICATOR AWARD_EFFECTIVE_DATE AWARD_EXECUTION_DATE BEGIN_DATE COST_SHARING_INDICATOR IDC_INDICATOR MODIFICATION_NUMBER NSF_CODE PAYMENT_SCHEDULE_INDICATOR SCIENCE_CODE_INDICATOR SPECIAL_REVIEW_INDICATOR SPONSOR_AWARD_NUMBER TRANSFER_SPONSOR_INDICATOR ACCOUNT_TYPE_CODE
VER_NBR ENTITY_ID PRNCPL_PSWD ACTV_IND LAST_UPDT_DT
FK4 FK3 FK2
AWARD
AWARD_DOCUMENT
AWARD_SCIENCE_KEYWORD_ID
FK2
FK1
AWARD_NUMBER SEQUENCE_NUMBER AWARD_ID APPLICABLE_IDC_RATE IDC_RATE_TYPE_CODE FISCAL_YEAR ON_CAMPUS_FLAG UNDERRECOVERY_OF_IDC SOURCE_ACCOUNT DESTINATION_ACCOUNT START_DATE END_DATE VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
ACCOUNT_TYPE_CODE
PK
FK2
COMMENT_TYPE PK
FK2
AWARD_SCIENCE_KEYWORD
SCIENCE_KEYWORD_CODE DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER CLOSEOUT_REPORT_CODE CLOSEOUT_REPORT_NAME DUE_DATE FINAL_SUBMISSION_DATE MULTIPLE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
VERIFICATION_DATE COST_SHARE_MET AWARD_ID COST_SHARE_PERCENTAGE COST_SHARE_TYPE_CODE COMMITMENT_AMOUNT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
SCIENCE_KEYWORD PK
FK1
AWARD_COST_SHARE_ID
FK1
FK1
AWARD_CLOSEOUT_ID
ACCOUNT_TYPE
AWARD_SPECIAL_REVIEW_ID
AWARD_COST_SHARE
PK
PK
AWARD_SPECIAL_REVIEW
AWARD_EXEMPT_NUMBER
FK1
AWARD_CLOSEOUT
PK
AWARD_IDC_RATE_ID
AWARD_APPR_FORN_TRAVEL_ID
PK
PK
AWARD_APPROVED_SUBAWARD_ID
FK2
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER ORGANIZATION_NAME AMOUNT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID ORGANIZATION_ID
ACTIVITY_TYPE_CODE
PK
AWARD_TRANSFERRING_SPONSOR_ID
FK2 FK1,I1
AWARD_ID SPONSOR_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
NSF_SEQUENCE_NUMBER
PK
AWARD_NOTEPAD PK
AWARD_NOTEPAD_ID
FK1
COMMENTS RESTRICTED_VIEW UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID CREATE_TIMESTAMP NOTE_TOPIC AWARD_ID
NSF_CODES
NSF_CODE DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_TYPE PK
AWARD_TYPE_CODE
AWARD_BASIS_OF_PAYMENT PK
DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
BASIS_OF_PAYMENT_CODE VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
UNIT_ADMINISTRATOR PK,FK1 PK PK,FK2
UNIT_ADMINISTRATOR_TYPE_CODE
UNIT_NUMBER PERSON_ID UNIT_ADMINISTRATOR_TYPE_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
UNIT PK
AWARD_PERS_UNIT_CRED_SPLITS PK
APU_CREDIT_SPLIT_ID
FK1,I1 FK2,I1
AWARD_PERSON_UNIT_ID INV_CREDIT_TYPE_CODE CREDIT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
AWARD_PERSON_UNIT_ID
FK1 FK2
AWARD_PERSON_ID UNIT_NUMBER LEAD_UNIT_FLAG UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
FK1
AWARD_PERSON_CREDIT_SPLIT_ID FK2
FK1,I1 FK2,I1
AWARD_PERSON_ID INV_CREDIT_TYPE_CODE CREDIT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
CUSTOM_ATTRIBUTE PK
FK1
PK
SPONSOR_TERM_TYPE_CODE VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
NAME LABEL DATA_TYPE_CODE DATA_LENGTH DEFAULT_VALUE LOOKUP_CLASS LOOKUP_RETURN GROUP_NAME UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
ORGANIZATION_NAME CONTACT_ADDRESS_ID ADDRESS CABLE_ADDRESS TELEX_NUMBER COUNTY CONGRESSIONAL_DISTRICT INCORPORATED_IN INCORPORATED_DATE NUMBER_OF_EMPLOYEES IRS_TAX_EXCEMPTION FEDRAL_EMPLOYER_ID MASS_TAX_EXCEMPT_NUM AGENCY_SYMBOL VENDOR_CODE COM_GOV_ENTITY_CODE MASS_EMPLOYEE_CLAIM DUNS_NUMBER DUNS_PLUS_FOUR_NUMBER DODAC_NUMBER CAGE_NUMBER HUMAN_SUB_ASSURANCE ANIMAL_WELFARE_ASSURANCE SCIENCE_MISCONDUCT_COMPL_DATE PHS_ACOUNT NSF_INSTITUTIONAL_CODE INDIRECT_COST_RATE_AGREEMENT COGNIZANT_AUDITOR ONR_RESIDENT_REP UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
PK
FK1 FK2 FK3
PK FK6
FK4 FK5 FK1 FK2 FK3
VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
VALID_AWARD_BASIS_PAYMENT_ID
PK
VALID_BASIS_METHOD_PMT_ID
FK1,I1 FK2,I1
AWARD_TYPE_CODE BASIS_OF_PAYMENT_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FK2,I1 FK1,I1
BASIS_OF_PAYMENT_CODE METHOD_OF_PAYMENT_CODE FREQUENCY_INDICATOR INV_INSTRUCTIONS_INDICATOR UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FK1
AWARD_REP_TERMS_RECNT_ID CONTACT_ID AWARD_REPORT_TERMS_ID CONTACT_TYPE_CODE ROLODEX_ID NUMBER_OF_COPIES VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
CONTACT_TYPE PK
CONTACT_TYPE_CODE
REPORT
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER REPORT_CLASS_CODE REPORT_CODE FREQUENCY_CODE FREQUENCY_BASE_CODE OSP_DISTRIBUTION_CODE DUE_DATE VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
PK
PK
REPORT_CODE VER_NBR OBJ_ID DESCRIPTION FINAL_REPORT_FLAG UPDATE_TIMESTAMP UPDATE_USER
PK
VALID_FREQUENCY_BASE_ID
FK1,I1 FK2,I1
FREQUENCY_CODE FREQUENCY_BASE_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
FK1
PK
AWARD_CUSTOM_DATA_ID
FK2
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER CUSTOM_ATTRIBUTE_ID VALUE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FK1
SPONSOR_TERM_ID VER_NBR OBJ_ID SPONSOR_TERM_TYPE_CODE DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
AWARD_SPONSOR_TERM PK
AWARD_SPONSOR_TERM_ID
FK2,I1
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER SPONSOR_TERM_ID UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FK1,I1
VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER GENERATE_REPORT_REQUIREMENTS
VALID_CLASS_REPORT_FREQ PK
VALID_CLASS_REPORT_FREQ_ID
FK2,I1 FK1,I1 FK3,I1
REPORT_CLASS_CODE REPORT_CODE FREQUENCY_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
FREQUENCY_CODE VER_NBR OBJ_ID DESCRIPTION NUMBER_OF_DAYS NUMBER_OF_MONTHS REPEAT_FLAG UPDATE_TIMESTAMP UPDATE_USER ADVANCE_NUMBER_OF_DAYS ADVANCE_NUMBER_OF_MONTHS
VERSION_HISTORY
AWARD_TRANSACTION_TYPE_CODE VERSION_HISTORY_ID SEQ_OWNER_CLASS_NAME SEQ_OWNER_VERSION_NAME_FIELD SEQ_OWNER_VERSION_NAME_VALUE SEQ_OWNER_SEQ_NUMBER VERSION_STATUS VERSION_DATE USER_ID UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_AMOUNT_INFO
ANTICIPATED_CHANGE_DIRECT ANTICIPATED_CHANGE_INDIRECT ANTICIPATED_TOTAL_DIRECT ANTICIPATED_TOTAL_INDIRECT OBLIGATED_TOTAL_DIRECT OBLIGATED_TOTAL_INDIRECT VER_NBR OBJ_ID TNM_DOCUMENT_NUMBER AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER ANTICIPATED_TOTAL_AMOUNT ANT_DISTRIBUTABLE_AMOUNT FINAL_EXPIRATION_DATE CURRENT_FUND_EFFECTIVE_DATE AMOUNT_OBLIGATED_TO_DATE OBLI_DISTRIBUTABLE_AMOUNT OBLIGATION_EXPIRATION_DATE TRANSACTION_ID ENTRY_TYPE EOM_PROCESS_FLAG UPDATE_TIMESTAMP UPDATE_USER ANTICIPATED_CHANGE OBLIGATED_CHANGE OBLIGATED_CHANGE_DIRECT OBLIGATED_CHANGE_INDIRECT ORIGINATING_AWARD_VERSION
REPORT_CLASS_CODE
PK
VALID_FREQUENCY_BASE
AWARD_AMOUNT_INFO_ID
FK6
FREQUENCY
AWARD_PERSON_ID
PK
LAST_NAME FIRST_NAME MIDDLE_NAME SUFFIX PREFIX TITLE ORGANIZATION ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 FAX_NUMBER EMAIL_ADDRESS CITY COUNTY STATE POSTAL_CODE COMMENTS PHONE_NUMBER COUNTRY_CODE SPONSOR_CODE OWNED_BY_UNIT SPONSOR_ADDRESS_FLAG DELETE_FLAG CREATE_USER UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
REPORT_CLASS
AWARD_REPORT_TERMS_ID
FREQUENCY_BASE_CODE
ROLODEX_ID
DOCUMENT_NUMBER CREATE_TIMESTAMP MAIL_DESCRIPTION PROPOSAL_SEQUENCE_STATUS FISCAL_MONTH FISCAL_YEAR LEAD_UNIT_NUMBER SPONSOR_PROPOSAL_NUMBER PROPOSAL_TYPE_CODE CURRENT_ACCOUNT_NUMBER TITLE SPONSOR_CODE ROLODEX_ID NOTICE_OF_OPPORTUNITY_CODE GRAD_STUD_HEADCOUNT GRAD_STUD_PERSON_MONTHS TYPE_OF_ACCOUNT ACTIVITY_TYPE_CODE REQUESTED_START_DATE_INITIAL REQUESTED_START_DATE_TOTAL REQUESTED_END_DATE_INITIAL REQUESTED_END_DATE_TOTAL TOTAL_DIRECT_COST_INITIAL TOTAL_DIRECT_COST_TOTAL TOTAL_INDIRECT_COST_INITIAL TOTAL_INDIRECT_COST_TOTAL NUMBER_OF_COPIES DEADLINE_DATE DEADLINE_TYPE MAIL_BY MAIL_TYPE MAIL_ACCOUNT_NUMBER SUBCONTRACT_FLAG COST_SHARING_INDICATOR IDC_RATE_INDICATOR SPECIAL_REVIEW_INDICATOR STATUS_CODE SCIENCE_CODE_INDICATOR NSF_CODE PRIME_SPONSOR_CODE INITIAL_CONTRACT_ADMIN IP_REVIEW_ACTIVITY_INDICATOR CURRENT_AWARD_NUMBER CFDA_NUMBER OPPORTUNITY UPDATE_TIMESTAMP UPDATE_USER AWARD_TYPE_CODE VER_NBR OBJ_ID
VER_NBR OBJ_ID DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER
DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER SHOW_IN_ACTION_SUMMARY VER_NBR OBJ_ID
KEY_PERSON_PROJECT_ROLE AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER PERSON_ID ROLODEX_ID FULL_NAME CONTACT_ROLE_CODE ACADEMIC_YEAR_EFFORT CALENDAR_YEAR_EFFORT SUMMER_EFFORT TOTAL_EFFORT FACULTY_FLAG UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
PK
AWARD_REPORT_TERMS
METHOD_OF_PAYMENT_CODE
PK
ROLODEX
AWARD_REP_TERMS_RECNT
AWARD_METHOD_OF_PAYMENT
PK
SPONSOR_TERM
FK1,I1
AWARD_ID AWARD_NUMBER SEQUENCE_NUMBER ROLODEX_ID FULL_NAME CONTACT_ROLE_CODE UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_TRANSACTION_TYPE
AWARD_CUSTOM_DATA
PK
FK2
FK1
VALID_BASIS_METHOD_PMT
UNIT_NUMBER
ID
SPONSOR_TERM_TYPE
AWARD_SPONSOR_CONTACT_ID
AWARD_PERSONS
AWARD_PERSON_CREDIT_SPLITS PK
ORGANIZATION_ID
UNIT_NAME ORGANIZATION_ID UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID PARENT_UNIT_NUMBER
AWARD_PERSON_UNITS
PK
PK
UNIT_ADMINISTRATOR_TYPE
DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID DEFAULT_GROUP_FLAG MULTIPLES_FLAG
AWARD_SPONSOR_CONTACTS
FREQUENCY_BASE
VALID_AWARD_BASIS_PAYMENT
PK
FK1
ORGANIZATION
FK1
DESCRIPTION UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
SPONSOR_NAME ACRONYM SPONSOR_TYPE_CODE DUN_AND_BRADSTREET_NUMBER DUNS_PLUS_FOUR_NUMBER DODAC_NUMBER CAGE_NUMBER POSTAL_CODE STATE COUNTRY_CODE ROLODEX_ID AUDIT_REPORT_SENT_FOR_FY OWNED_BY_UNIT CREATE_USER UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_TRANSFERRING_SPONSOR
PK
ACTIVITY_TYPE
SPONSOR_CODE
FK2
AWARD_APPROVED_SUBAWARDS
FK1
FK1
SPONSOR
AWARD_NUMBER SEQUENCE_NUMBER PERSON_ID ROLODEX_ID TRAVELER_NAME DESTINATION START_DATE END_DATE AMOUNT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID AWARD_ID
PROPOSAL_ID
AWARD_AMOUNT_TRANSACTION PK
AWARD_AMOUNT_TRANSACTION_ID
FK2,I1 FK1
TRANSACTION_ID TRANSACTION_TYPE_CODE NOTICE_DATE COMMENTS UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
AWARD_AMT_FNA_DISTRIBUTION PK,I1
AWARD_AMT_FNA_DISTRIBUTION_ID
FK1
AWARD_ID AMOUNT_SEQUENCE_NUMBER START_DATE END_DATE DIRECT_COST INDIRECT_COST UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID AWARD_AMOUNT_INFO_ID
PENDING_TRANSACTIONS PK
TRANSACTION_ID
FK1
DOCUMENT_NUMBER SOURCE_AWARD_NUMBER DESTINATION_AWARD_NUMBER OBLIGATED_AMOUNT ANTICIPATED_AMOUNT COMMENTS UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID
TIME_AND_MONEY_DOCUMENT PK
DOCUMENT_NUMBER AWARD_NUMBER VER_NBR OBJ_ID UPDATE_TIMESTAMP UPDATE_USER
AWARD_HIERARCHY
TRANSACTION_DETAILS PK
FK1
TRANSACTION_DETAIL_ID AWARD_NUMBER SEQUENCE_NUMBER TRANSACTION_ID TNM_DOCUMENT_NUMBER COMMENTS SOURCE_AWARD_NUMBER DESTINATION_AWARD_NUMBER OBLIGATED_AMOUNT ANTICIPATED_AMOUNT UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID TRANSACTION_DETAIL_TYPE
PK
AWARD_HIERARCHY_ID ROOT_AWARD_NUMBER PARENT_AWARD_NUMBER ORIGINATING_AWARD_NUMBER UPDATE_TIMESTAMP UPDATE_USER VER_NBR OBJ_ID