FRS Metadata
Table Name: FRS_AFFILIATION_HISTORY
Description: Changes that occur over time to the Affiliation record which defines the relationships between a facility site and an organization and/or an individual person.
Columns:
- AFFILIATION_TYPE
- AFFILIATION_UIN
- CONTACT_UIN
- CREATE_DATE
- END_DATE
- LAST_REPORTED_DATE
- MAIL_UIN
- OPERATION
- ORG_UIN
- PGM_SYS_ACRNM
- PGM_SYS_ID
- PUBLIC_IND
- REGISTRY_ID
- SENSITIVE_IND
- SOURCE_OF_DATA
- START_DATE
- SUP_INTEREST_ID
- TRANSACTION_DATE
- TRANSACTION_USER_ID
- UPDATE_DATE
- USER_ID