LM_Database_ERD.pdf
PDF 63 KB Posted
- Attached to
- Electronic Case Management
- Solicitation number
- MSPB-15-RFI
- Issued by
-
Merit Systems Protection Board
About this file
LM Database ERD
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFI_Questions_and_Answers.docx | DOCX document | |
| eAppeal_server_Chart.vsd | VSD drawing | |
| Electronic_Case_File_Processing_RFI_2014_.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
(1,1)
ADDRESS
ADDRESS_KEY
ADDED_BY
CITY
COUNTY
DATE_ADDED
DATE_UPDATED
ENTITY_KEY
LINKED_FLAG
MAIL_STOP
MAILING_FLAG
OFFICE_KEY
PARENT_ADDRESS_KEY
STATE
STREET
UPDATED_BY
ZIP_CODE
MSPB_OFFICE_KEY
ACTIVE_INACTIVE_FLAG
ADDRESS_TYPE_KEY (FK)
COUNTRY (FK)
ADDRESSTYPE
ADDRESS_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
APPEALCASETYPE
APPEAL_CASE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
TITLE_TYPE
UPDATED_BY
APPEAL_TYPE_KEY (FK)
CASE_TYPE_KEY (FK)
APPEALCASEWBTYPE
ADDED_BY
APPEAL_CASE_WB_KEY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
APPEAL_TYPE_KEY (FK)
CASE_TYPE_KEY (FK)
WB_TYPE_KEY (FK)
APPEALTYPE
APPEAL_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
JURISDICTION
DISABLED_DATE
CALENDAR
CALENDAR_KEY
ADDED_BY
DATE_ADDED
DATE_REMINDER
DATE_SCHEDULED
DATE_UPDATED
ENTITY_KEY
GROUP_KEY
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
PRIORITY
TIME_SPENT
NOTE
CALENDAR_STATUS_KEY
LOCATION
DATE_BEGIN
DATE_END
EVENT_UNID
HEARING_LOCATION_KEY
CALENDAR_SUB_TYPE_KEY
FILE_LOC
CALENDAR_DATE
CASE_KEY (FK)
CALENDAR_TYPE_KEY (FK)
GEOGRAPHIC_LOCATION_KEY (FK)
PARENT_CALENDAR_KEY (FK)
CALENDARSTATUS
ADDED_BY
CALENDAR_STATUS_KEY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
CALENDARSUBTYPE
CALENDAR_SUB_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CODE
CONTROL
DESCRIPTION
DISABLED
DISABLED_DATE
CALENDAR_TYPE_KEY (FK)
CALENDARTYPE
CALENDAR_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
FORUM_FLAG
UPDATED_BY
DISABLED_DATE
LMGROUP_KEY
CALENDARTYPESTATUS
CALENDAR_TYPE_STATUS_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CALENDAR_STATUS_KEY
CALENDAR_TYPE_KEY (FK)
CASEENTITYTYPE
CASE_ENTITY_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
PRIMARY_ROLE_FLAG
CASENOTE
CASE_NOTE_KEY
ADDED_BY
DATE_ADDED
DATE_NOTE
DATE_UPDATED
GROUP_KEY
MEMO
NOTE
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
CASE_KEY (FK)
CASE_NOTE_TYPE_KEY (FK)
CASENOTETYPE
CASE_NOTE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
CASESTATUS
CASE_STATUS_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
CASETYPE
CASE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DESC_ABR
DISABLED_DATE
CITY
ADDED_BY
CITY
DATE_ADDED
DATE_UPDATED
STATE
UPDATED_BY
COUNTRY (FK)
CLOSINGCATEGORY
CLOSING_CAT_KEY
ADDED_BY
CONTROL
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CLOSE_CAT1
CLOSE_CAT2
CLOSE_CAT3
CONTROL1
CLOSING_TYPE_KEY (FK)
CLOSINGTYPE
CLOSING_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DESCR_ABRV
CLOSE_ACTIVITY
DISABLED_DATE
CLOSINGTYPEOFFICE
CLOSING_OFFICE_KEY
OFFICE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CLOSING_TYPE_KEY (FK)
CONSOLIDATION
CONSOL_KEY
ADDED_BY
BOARD_CASE_TITLE
CONSOL_DATE
CONSOL_END
DATE_ADDED
DATE_DELETED
DATE_UPDATED
DOCKET_NBR
GROUP_KEY
OWNER_KEY
PERMISSIONS
STATUS
TIME_STAMP
UPDATED_BY
NOTE
CASE_KEY (FK)
CONSOL_REASON_KEY (FK)
CONSOLIDATIONMEMBER
CONSOL_MEMBER_KEY
ADDED_BY
CONSOL_DATE
CONSOL_END
DATE_ADDED
DATE_DELETED
DATE_UPDATED
GROUP_KEY
LEAD
OWNER_KEY
PERMISSIONS
STATUS
TIME_STAMP
UPDATED_BY
NOTE
CASE_KEY (FK)
CONSOL_KEY (FK)
CONSOLIDATIONREASON
CONSOL_REASON_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
COUNTY
ADDED_BY
COUNTY
DATE_ADDED
DATE_UPDATED
STATE
UPDATED_BY
COUNTRY (FK)
COURT
CASE_COURT_KEY
ADDED_BY
CASE_KEY
DATE_ADDED
DATE_UPDATED
FILE_DATE
GROUP_KEY
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
COURT_DOCKET_NUMBER
FEDERAL_CASE_TITLE
NOTE
COURT_TYPE_KEY (FK)
LIT_CASE_TYPE_KEY (FK)
COURTTYPE
COURT_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
DOCUMENTSENDTYPE
DOC_TYPE_SEND_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
DOCUMENTTYPE
DOC_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
TYPE
D_TICKLER_DAYS
D_TICKLER_TEXT
CASE_STATUS_MUST_BE
DISABLED_DATE
NEW_CASE_STATUS_KEY
NEW_CASE_TYPE_KEY
TITLE_REQUIRED_FLAG
NEW_WB_TYPE
NEW_ACTION_TYPE
JURISDICTION_MUST_BE
CASE_TYPE_MUST_BE
CASE_STATUS_KEY (FK)
CASE_TYPE_KEY (FK)
OFFICE_KEY (FK)
TRANSFER_REASON_KEY (FK)
TRANSFER_STATUS_KEY (FK)
DOCUMENTTYPEOFFICE
DOC_TYPE_OFFICE_KEY
OFFICE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
VERSION
DOC_TYPE_KEY (FK)
DOCUMENT_RECEIVED
DOC_RECV_KEY
ADDED_BY
DATE_ADDED
DATE_DOC_POSTMARK
DATE_UPDATED
GROUP_KEY
OWNER_KEY
PERMISSIONS
TICKLER_DATE
TICKLER_NOTE
TIME_STAMP
UPDATED_BY
DATE_DOC_RECEIVED
COMMENTS
DOC_TITLE
CASE_KEY (FK)
DOC_TYPE_KEY (FK)
SENDER_TYPE_KEY (FK)
EADDRESS
EADDRESS_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
EADDRESS
ENTITY_KEY
NOTE
SORT_ORDER
UPDATED_BY
EADDRESS_TYPE_KEY (FK)
EADDRESSTYPE
EADDRESS_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
ENTITY
ENTITY_KEY
ACTIVE_INACTIVE_FLAG
ADDED_BY
AGENCY_KEY
DATE_ADDED
DATE_UPDATED
FIRST_NAME
GROUP_KEY
LAST_NAME
MIDDLE_NAME
NAME
OWNER_KEY
PERMISSIONS
PERSON_COMPANY_FLAG
PREFIX
SUFFIX
TIME_STAMP
UPDATED_BY
SSN
DOB_DATE
CODE
TEAM_CODE
ENTITY_TYPE_KEY (FK)
PARENT_ENTITY_KEY (FK)
PARENT_OFFICE_KEY (FK)
TITLE (FK)
CASE_ENTITY_TYPE_KEY (FK)
ENTITYENTITY
ENTITY_ENTITY_KEY
NOTE
DATE_ADDED
ADDED_BY
DATE_UPDATED
UPDATED_BY
RELATED_ENTITY_KEY (FK)
ENTITY_ENTITY_TYPE_KEY (FK)
ENTITY_KEY (FK)
ENTITYENTITYTYPE
ENTITY_ENTITY_TYPE_KEY
ENTITY_PAIR_KEY
DATE_ADDED
ADDED_BY
DATE_UPDATED
UPDATED_BY
DESCRIPTION
CODE
DISABLED
CONTROL
DISABLED_DATE
RELATED_ENTITY_TYPE_KEY (FK)
ENTITY_TYPE_KEY (FK)
ENTITYNOTE
ENTITY_NOTE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
NOTE
NOTE_DATE
UPDATED_BY
ENTITY_KEY (FK)
ENTITY_NOTE_TYPE_KEY (FK)
ENTITYNOTETYPE
ENTITY_NOTE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
ENTITY_TYPE_KEY
GEOGRAPHICLOCATION
GEOGRAPHIC_LOCATION_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
STATE_COUNTRY_CODE
CITY_PROVINCE_CODE
CITY_PROVINCE_NAME
STATE_COUNTRY_NAME
ISSUE
CASE_ISSUE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
GROUP_KEY
ISSUE_NOTE
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
IA_PFR
CASE_KEY (FK)
ISSUE_TYPE_KEY (FK)
ISSUE_STATUS_KEY (FK)
ISSUESTATUS
ISSUE_STATUS_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
ISSUETYPE
ISSUE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
LITIGATIONCASETYPE
LIT_CASE_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CODE
CONTROL
DESCRIPTION
DISABLED
DISABLED_DATE
LMGROUP
LMGROUP_KEY
CODE
DESCRIPTION
DISABLED
CONTROL
DATE_ADDED
ADDED_BY
DATE_UPDATED
UPDATED_BY
VERSION
LM_GLOBAL_KEY
DISABLED_DATE
LMGROUPOFFICE
LMGROUP_OFFICE_KEY
OFFICE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
LMGROUP_KEY (FK)
MSPBOFFICELMGROUP
MSPBOFFICE_LMGROUP_KEY
OFFICE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
LMGROUP_KEY (FK)
NAMEFORMAT
NAME_FORMAT_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
FORMAT_STRING
NAMEPREFIX
PREFIX
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
NAMESUFFIX
SUFFIX
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
OFFICE
OFFICE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
OFFICE_NAME
PRIMARY_FLAG
REGION_KEY
DISABLED_DATE
MSPBADDNEW
TOTAL_STAFF
ATTY_STAFF
ENTITY_KEY (FK)
OFFICECASETYPE
OFFICE_CASE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CASE_TYPE_KEY (FK)
OFFICE_KEY (FK)
OFFICETRANSFERREASON
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
MSPB_OFFICE_KEY (FK)
TRANSFER_REASON_KEY (FK)
ORDERTYPE
ORDER_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CODE
CONTROL
DESCRIPTION
DISABLED
DISABLED_DATE
PERSONNEL
PERSONNEL_KEY
DATE_UPDATED
UPDATED_BY
DATE_ADDED
ADDED_BY
LOGIN_NAME
LOGIN_EXPIRES
DATE_LAST_LOGIN
FAILED_ATTEMPTS
PASSWORD
DATE_PASSWD_CHANGED
PERMISSIONS_MASK
OBJECT_KEY
OFFICE_KEY
ENTITY_KEY
DISABLED
LM_GLOBAL_KEY
VERSION
PERSONNELALIAS
PERSONNEL_ALIAS_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
LMGROUP_KEY (FK)
PERSONNEL_KEY (FK)
PHONE
PHONE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
ENTITY_KEY
EXTENSION
LINKED_FLAG
NOTE
OFFICE_KEY
PARENT_PHONE_KEY
PHONE_NUMBER
SORT_ORDER
UPDATED_BY
PHONE_TYPE_KEY (FK)
PHONETYPE
PHONE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
REPORTTYPE
REPORT_CODE
REPORT_DESC
REPORT_NAME
REPORT_OWNER
REPORT_TYPE
REPORT_SCHED
REPORT_FORMAT
REPORT_PROGRAM
REPORT_KEY
REPORT_LOCATION
EMAIL_SCHEDULE
EMAIL_SUBJECT
EMAIL_BODYTEXT
EXPORT_FILE_NAME
ROLEENTITYTYPE
ROLE_ENTITY_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
ENTITY_TYPE_KEY (FK)
CASE_ENTITY_TYPE_KEY (FK)
ROLEOFFICE
ROLE_OFFICE_KEY
OFFICE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CASE_ENTITY_TYPE_KEY (FK)
SENDERTYPE
SENDER_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CODE
CONTROL
DESCRIPTION
DISABLED
DISABLED_DATE
TITLE
TITLE
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
TRANSFER
TRANSFER_KEY
ADDED_BY
COMMENTS
DATE_ADDED
DATE_UPDATED
GROUP_KEY
OWNER_KEY
PERMISSIONS
PRIMARY_TRANSFER_KEY
RECEIVE_DATE
REQUEST_DATE
SEND_DATE
STATUS
TIME_STAMP
UPDATED_BY
VOLUME
CASE_KEY (FK)
RECEIVE_OFFICE_KEY (FK)
REQUEST_OFFICE_KEY (FK)
SEND_OFFICE_KEY (FK)
TRANSFER_REASON_KEY (FK)
TRANSFER_STATUS_KEY (FK)
TRANSFER_TYPE_KEY (FK)
ORDER_TYPE_KEY (FK)
TRANSFERREASON
TRANSFER_REASON_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
ADJUD_OFFICE_CHANGED
DISABLED_DATE
AFFECTED_TIME
ORDER_FLAG
TRANSFERREASONORDER
REASON_ORDER_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
ORDER_TYPE_KEY (FK)
TRANSFER_REASON_KEY (FK)
TRANSFERSTATUS
TRANSFER_STATUS_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
TRANSFERTYPE
TRANSFER_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
VOTE
VOTE_KEY
ADDED_BY
CASE_KEY
COMMENTS
DATE_ADDED
DATE_UPDATED
DATE_VOTE
GROUP_KEY
MEMBER
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
ENTITY_KEY
VOTE_TYPE_KEY (FK)
MEMBER_OFFICE_KEY (FK)
VOTETYPE
VOTE_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
WHISTLEBLOWERTYPE
WB_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
ZIPCODE
ADDED_BY
AREA_CODE
CITY
COUNTY
DATE_ADDED
DATE_UPDATED
SEQUENCE_NUMBER
STATE
UPDATED_BY
ZIP_CODE
COUNTRY (FK)
TRANSFERREASONINFO
TRANSFER_REASON_INFO_KEY
DEST_OFFICE_KEY
CURR_OFFICE_KEY
JURISDICTION
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CASE_STATUS_KEY (FK)
CASE_TYPE_KEY (FK)
TRANSFER_REASON_KEY (FK)
ENTITYTYPE
ENTITY_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
PERSON_COMPANY_FLAG
UPDATED_BY
VENDOR_FLAG
DISABLED_DATE
CASE_ENTITY_TYPE_KEY
NAME_FORMAT_KEY (FK)
CASE
CASE_KEY
HOLD_FLAG
ADDED_BY
BOARD_CASE_TITLE
CASE_NBR
DATE_ADDED
DATE_IA_CLOSED
DATE_IA_POSTMARK
DATE_IA_RCVD
DATE_PFR_CLOSED
DATE_PFR_POSTMARK
DATE_UPDATED
DOCKET_NBR
FINALITY_DATE
GROUP_KEY
OPM_NUMBER
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
ADJUD_OFFICE_KEY
CURR_OFFICE_START_DATE
DATE_PFR_RCVD
JURISDICTION
NRC_LOCATION
SHORT_DOCKET_NBR
AGENCY_KEY
SUBAGENCY_KEY
CURR_OFFICE_KEY
BOX_NBR
ACCESSION_NBR
DATE_DESTROYED
DATE_SCHED_DESTR
FILE_LOC
CURR_LOC
TARGET_DATE
ACTION_TYPE_KEY (FK)
APPEAL_TYPE_KEY (FK)
APPELLANT_KEY (FK)
CASE_FAMILY_KEY (FK)
CASE_ID_OFFICE (FK)
CASE_STATUS_KEY (FK)
CASE_TYPE_KEY (FK)
GEOGRAPHIC_LOCATION_KEY (FK)
WB_TYPE_KEY (FK)
CASE_CREATOR_KEY (FK)
RO_REPR_TYPE_KEY (FK)
HQ_REPR_TYPE_KEY (FK)
DOCUMENT_SEND
DOC_SEND_KEY
ADDED_BY
DATE_ADDED
DATE_DOC_SEND
DATE_UPDATED
DOC_SEND_TYPE_KEY
GROUP_KEY
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
COMMENTS
CASE_KEY (FK)
SENDER_TYPE_KEY (FK)
CASEENTITY
CASE_ENTITY_KEY
ADDED_BY
CONTROL_CASE_FLAG
DATE_ADDED
DATE_UPDATED
EFFECTIVE_DATE
END_DATE
GROUP_KEY
NOTE
OWNER_KEY
PERMISSIONS
TIME_STAMP
UPDATED_BY
REL_ENTITY_KEY
ADDRESS_KEY
PRIMARY_FLAG
OFFICE_KEY
CASE_ENTITY_TYPE_KEY (FK)
CASE_KEY (FK)
ENTITY_KEY (FK)
TRANSFERRECEIPT
TRANSFER_RECEIPT_KEY
RECEIVED_OFFICE_KEY
ADJUD_OFFICE_FLAG
TARGET_DAYS
JURISDICTION
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CASE_STATUS_KEY (FK)
CASE_TYPE_KEY (FK)
TRANSFER_REASON_KEY (FK)
REPRESENTATIONTYPE
REPRESENTATION_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DESC_ABR
DISABLED_DATE
CLOSING
CASE_CLOSING_KEY
ADDED_BY
ATT_FEE_PAID
CLOSING_DATE
DATE_ADDED
DATE_UPDATED
GROUP_KEY
INTERIM_RELIEF
NOTE
OWNER_KEY
PERMISSIONS
PUBLIC_INTEREST
TIME_STAMP
UPDATED_BY
IA_PFR
DISCR_CHECK
BENCH_DECISION_FLAG
CASE_KEY (FK)
CLOSING_TYPE_KEY (FK)
CLOSINGCASETYPE
CLOSING_CASE_TYPE_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
CASE_TYPE_KEY (FK)
CLOSING_TYPE_KEY (FK)
ACTIONTYPE
ACTION_TYPE_KEY
ADDED_BY
CODE
CONTROL
DATE_ADDED
DATE_UPDATED
DESCRIPTION
DISABLED
UPDATED_BY
DISABLED_DATE
APPEALACTIONTYPE
APPEAL_ACTION_KEY
ADDED_BY
DATE_ADDED
DATE_UPDATED
UPDATED_BY
ACTION_TYPE_KEY (FK)
APPEAL_TYPE_KEY (FK)
COUNTRY
COUNTRY
ADDED_BY
COUNTRY_CODE2
DATE_ADDED
DATE_UPDATED
DISABLED
LONG_NAME
PHONE_CODE
SHORT_NAME
UPDATED_BY
STATE
STATE
COUNTRY (FK)
ADDED_BY
DATE_ADDED
DATE_UPDATED
STATE_NAME
UPDATED_BY
File details come from the government source that posted it. Updated .