REQUEST TABLE
REQ_ID
REQ_REASON
REQUESTOR_PER_ID
REQUESTOR_ORG_FLAG
VERIFIER_PER_ID
STATUS
STATUS_DATE




DISCIPLINES
DISC_ID
DISC_TEXT


REQUEST_DISCIPLINES_MAP
ID
RD_MAP_REQ_ID references REQUEST REQ_ID
RD_MAP_DISC_ID references DISCIPLINES DISC_ID


ORGANIZATIONS
ORG_ID
NAME
ADDRESS
CITY
ZIP
STATE
COUNTRY


PERSONS
PER_ID
FIRST_NAME
MIDDLE_NAME
LAST_NAME
SALUTATION
POSITION
EMAIL
PHONE
PHONE_TYPE
City 
State
Country


ORG_PER_MAP
ID
OP_MAP_PER_ID
OP_MAP_ORG_ID

REQuest_Optional_Map
Req_Id
Opt_Id
Comment


Optional Information
OPT_ID
OPT_TEXT

INFORMATION_MEDIUM
MEDIUM_ID
MEDIUM_TEXT


STATUS_HISTORY_TABLE


COMMENTS
ID
REQ_ID
COMMENT
CREATED_BY
CREATED_DATE




























------------------------------------------------------------------------------




REQUEST TABLE

REQ_ID
REQ_REASON
REQUESTOR_FIRST_NAME
REQUESTOR_MIDDLE_NAME
REQUESTOR_LAST_NAME
REQUESTOR_SALUTATION
REQUESTOR_POSITION
REQUESTOR_EMAIL
REQUESTOR_PHONE
REQUESTOR_PHONE_TYPE
REQUESTOR_CITY
REQUESTOR_STATE
REQUESTOR_COUNTRY
REQUESTOR_ORG_FLAG





DISCIPLINES
DISC_ID
DISC_TEXT


REQUEST_DISCIPLINES_MAP
ID
RD_MAP_REQ_ID references REQUEST REQ_ID
RD_MAP_DISC_ID references DISCIPLINES DISC_ID


ORGANIZATIONS
NAME
ADDRESS
CITY
ZIP
STATE
COUNTRY


PERSONS
FIRST_NAME
MIDDLE_NAME
LAST_NAME
SALUTATION
POSITION
EMAIL
PHONE
PHONE_TYPE