Jobvite Data Exchange

Design NameJobviteDataWarehouseERD
Version Date18.05.2020 11:01:06
Version Comment
Model NameJobvite_QA_DataWarehouse

SubViews
SubViewDescriptionNotesObject
Jobvite Data Exchange
PUBLIC.AGENCY_JOB
PUBLIC.AGENCY_USER
PUBLIC.APPLICATION
PUBLIC.APPROVER
PUBLIC.CAMPAIGN_CONTACT
PUBLIC.CANDIDATE_WORKFLOW
PUBLIC.COMPANY_USER
PUBLIC.COMPLIANCE
PUBLIC.CONTACT
PUBLIC.CONTACT_STATUS_HISTORY
PUBLIC.EDUCATION
PUBLIC.ENGAGE_USER
PUBLIC.ENGAGE_USER_ACTIVITY
PUBLIC.ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN
PUBLIC.ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE
PUBLIC.ENGAGE_USER_ACTIVITY_CONTACT
PUBLIC.GDPR_APPLICATION
PUBLIC.GDPR_CONTACT
PUBLIC.GDPR_ONBOARDING_ENTITY
PUBLIC.INTERVIEW
PUBLIC.INTERVIEW_EVALUATION
PUBLIC.JOB
PUBLIC.JOB_JOBVITE_ACTIVITY
PUBLIC.JOB_OPEN_HISTORY
PUBLIC.JOB_OWNER
PUBLIC.OFCCP_SEARCH
PUBLIC.ONBOARDING_NEW_HIRE
PUBLIC.ONBOARDING_PORTAL
PUBLIC.ONBOARDING_PROCESS
PUBLIC.ONBOARDING_PROCESS_TEMPLATE
PUBLIC.ONBOARDING_TASK
PUBLIC.ONBOARDING_TASK_TEMPLATE
PUBLIC.SCREENING_FORM
PUBLIC.SCREENING_FORM_QUESTION
PUBLIC.USER_JOBVITE_ACTIVITY
PUBLIC.VIDEO_FORM_EVALUATION
PUBLIC.VIDEO_FORM_EVALUATION_QUESTION
PUBLIC.VIDEO_FORM_RESPONSE
PUBLIC.VIDEO_FORM_RESPONSE_QUESTION
PUBLIC.VIDEO_QUESTION
PUBLIC.VIDEO_QUESTION_FORM_MAP
PUBLIC.WORK_HISTORY

 

Table NamePUBLIC.AGENCY_JOB
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1AGENCY_JOB_IDPYBIGINTLT
2JOB_IDFYBIGINT (38) LT
3USER_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5AGENCY_JOB_SENT_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1AGENCY_JOB_IDAgency Job ID

2JOB_IDJob ID
3USER_IDUser ID (User who sent Agency Job) (COMPANY_USER.company_user_id)

4COMPANY_IDCompany ID (Company associated with Job ID)
5AGENCY_JOB_SENT_DATEAgency Job Sent Date

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
AGENCY_JOB_PKPKAGENCY_JOB_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
AGENCY_JOB_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
AGENCY_JOB_JOB_FKJOBYYJOB_IDJOB_ID
AGENCY_JOB_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.AGENCY_USER
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1AGENCY_USER_IDPFYBIGINTLT
2AGENCY_INVITATION_COMPANY_IDBIGINTLT
3AGENCY_FIRST_NAMEVARCHAR (100) LT
4AGENCY_LAST_NAMEVARCHAR (100) LT
5AGENCY_FULL_NAMEVARCHAR (210) LT
6AGENCY_EMAILVARCHAR (100) LT
7AGENCY_CREATEDTimestampLT
8AGENCY_MODIFIEDTimestampLT
9AGENCY_INVITATION_STATUSVARCHAR (100) LT
10AGENCY_INVITATION_SENT_DATETimestampLT
11AGENCY_INVITATION_ACCEPTED_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1AGENCY_USER_IDAgency User ID (COMPANY_USER.company_user_id)

2AGENCY_INVITATION_COMPANY_IDCompany ID who sent Agency Invitation
3AGENCY_FIRST_NAMEAgency User first name
4AGENCY_LAST_NAMEAgency User last name
5AGENCY_FULL_NAMEAgency User full name
6AGENCY_EMAILAgency user email address
7AGENCY_CREATEDAgency created date
8AGENCY_MODIFIEDAgency last updated date
9AGENCY_INVITATION_STATUSAgency invitation status
10AGENCY_INVITATION_SENT_DATEAgency invitation sent date
11AGENCY_INVITATION_ACCEPTED_DATEAgency invitation accepted date

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
AGENCY_USER_PKPKAGENCY_USER_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
AGENCY_USER_COMPANY_USER_FKCOMPANY_USERYYAGENCY_USER_IDUSER_ID

 

Table NamePUBLIC.APPLICATION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns59
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APP_IDPYBIGINTLT
2JOB_IDFYBIGINT (38) LT
3COMPANY_IDFYBIGINT (38) LT
4APP_USER_IDFYBIGINTLT
5APP_SENT_DATETimestampLT
6APP_HIRE_DATETimestampLT
7APP_SOURCETYPEVARCHAR (50) LT
8APP_SOURCEVARCHAR (50) LT
9APP_MODIFIEDTimestampLT
10APP_START_DATETimestampLT
11APP_CANDIDATE_IDYBIGINTLT
12APP_FIRST_NAMEVARCHAR (100) LT
13APP_LAST_NAMEVARCHAR (100) LT
14APP_FULL_NAMEVARCHAR (225) LT
15APP_EMAILVARCHAR (100) LT
16APP_ADDRESSVARCHAR (100) LT
17APP_ADDRESS2VARCHAR (100) LT
18APP_CITYVARCHAR (50) LT
19APP_STATEVARCHAR (50) LT
20APP_POSTAL_CODEVARCHAR (50) LT
21APP_COUNTRYVARCHAR (50) LT
22APP_DISPOSITION_NAMEVARCHAR (100) LT
23APP_PHONEVARCHAR (25) LT
24APP_VETERAN_STATUSVARCHAR (50) LT
25APP_GENDERVARCHAR (50) LT
26APP_RACEVARCHAR (50) LT
27APP_WORK_STATUSVARCHAR (50) LT
28APP_TITLEVARCHAR (100) LT
29APP_WORKFLOW_STATE_IDBIGINTLT
30APP_WORKFLOW_STATE_NAMEVARCHAR (150) LT
31APP_WORKFLOW_STATE_DATETimestampLT
32APP_COMPANYVARCHAR (100) LT
33APP_COLLECTION_NAMEVARCHAR (50) LT
34APP_WORKFLOW_STATE_PREV_DATETimestampLT
35APP_WORKFLOW_STATE_PREV_NAMEVARCHAR (100) LT
36APP_WORKFLOW_STATE_IN_DAYSBIGINTLT
37APP_TOTAL_DAYS_TO_HIREBIGINTLT
38APP_DELETEDBooleanLT
39APP_JOBVITE_CHANNELVARCHAR (50) LT
40APP_ENTERED_BY_USERIDBIGINTLT
41APP_WORK_PHONEVARCHAR (25) LT
42APP_CELL_PHONEVARCHAR (25) LT
43APP_WORKFLOW_STATE_POSITIONBIGINTLT
44APP_USER_ID_FROM_CANDIDATE_LOOKUPBIGINTLT
45APP_EIDVARCHAR (50) LT
46APP_HIRE_LOCATION_NAMEVARCHAR (150) LT
47APP_PREFERRED_LOCATION_LISTVARCHAR (65535) LT
48APP_CANDIDATE_EIDVARCHAR (50) LT
49APP_COMMENTSVARCHAR (65535) LT
50APP_OFFER_ACCEPTED_DATETimestampLT
51APP_JOB_ALERTS_ACTIVEBooleanLT
52APP_STATUS_LEVELBIGINTLT
53APP_GDPR_CONSENT_STATUSVARCHAR (100) LT
54APP_GDPR_CONSENT_DATETimestampLT
55APP_GDPR_CONSENT_LAST_REQUESTED_DATETimestampLT
56APP_GDPR_CONSENT_LOC_LANVARCHAR (100) LT
57APP_GDPR_DELETION_DATETimestampLT
58APP_GDPR_CONSENT_LINKVARCHAR (255) LT
59APP_GDPR_FORGOTTENBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1APP_IDApplicant ID

2JOB_IDJob ID
3COMPANY_IDApplication Company ID
4APP_USER_IDApplicant User ID (COMPANY_USER.company_user_ID)

5APP_SENT_DATEApplication sent date

6APP_HIRE_DATEApplication hire date
7APP_SOURCETYPEApplicant source type
8APP_SOURCEApplication source
9APP_MODIFIEDApplication last modified date
10APP_START_DATEApplication start date
11APP_CANDIDATE_IDApplicant Candidate ID
12APP_FIRST_NAMEApplicant first name
13APP_LAST_NAMEApplicant last name
14APP_FULL_NAMEApplicant full name
15APP_EMAILApplicant email address
16APP_ADDRESSApplicant address
17APP_ADDRESS2Applicant address line 2
18APP_CITYApplicant city
19APP_STATEApplicant state
20APP_POSTAL_CODEApplicant postal code
21APP_COUNTRYApplicant country
22APP_DISPOSITION_NAMEApplication disposition name
23APP_PHONEApplicant phone number
24APP_VETERAN_STATUSApplicant veteran status
25APP_GENDERApplicant gender
26APP_RACEApplicant race
27APP_WORK_STATUSApplicant work status
28APP_TITLECandidate's current job title

29APP_WORKFLOW_STATE_IDApplication current workflow state ID

30APP_WORKFLOW_STATE_NAMEApplication current workflow state name
31APP_WORKFLOW_STATE_DATEApplication current workflow state start date

32APP_COMPANYApplication company
33APP_COLLECTION_NAMEApplication Collection name
34APP_WORKFLOW_STATE_PREV_DATEApplication previous workflow state start date

35APP_WORKFLOW_STATE_PREV_NAMEApplication previous workflow state name

36APP_WORKFLOW_STATE_IN_DAYSApplication current workflow duration in days (application current workflow state start date to today)

37APP_TOTAL_DAYS_TO_HIREApplication total days to hire (application sent date to hire date)

38APP_DELETEDApplication deleted ()
39APP_JOBVITE_CHANNELApplication jobvite origination type (email, Facebook, phone, etc.)

40APP_ENTERED_BY_USERIDApplication Entered by UserID
41APP_WORK_PHONEApplicant work phone
42APP_CELL_PHONEApplicant cell phone
43APP_WORKFLOW_STATE_POSITIONApplication workflow state position
44APP_USER_ID_FROM_CANDIDATE_LOOKUPApplication User ID from Candidate lookup

45APP_EIDApplicant Encrypted ID
46APP_HIRE_LOCATION_NAMEApplication Hire location name
47APP_PREFERRED_LOCATION_LISTApplication preferred location list

48APP_CANDIDATE_EIDApplicant Candidate Encrypted ID
49APP_COMMENTSApplication internal comments

50APP_OFFER_ACCEPTED_DATEApplication offer accepted date
51APP_JOB_ALERTS_ACTIVEApplicant job alerts active ()
52APP_STATUS_LEVELApplication status level ID
53APP_GDPR_CONSENT_STATUSApplication GDPR consent status
54APP_GDPR_CONSENT_DATEApplication GDPR consent date
55APP_GDPR_CONSENT_LAST_REQUESTED_DATEApplication GDPR consent last requested date
56APP_GDPR_CONSENT_LOC_LANApplication GDPR consent location language
57APP_GDPR_DELETION_DATEApplication GDPR deletion date
58APP_GDPR_CONSENT_LINKApplication GDPR consent link
59APP_GDPR_FORGOTTENApplication GDPR record forgotten ()

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
APPLICATION_PKPKAPP_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
APPLICATION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
APPLICATION_JOB_FKJOBYYJOB_IDJOB_ID
APPLICATION_COMPANY_USER_FKCOMPANY_USERYYAPP_USER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
APP_LOCATION_APPLICATION_FKAPP_LOCATIONYYAPP_IDAPP_ID
APPLICATION_CUSTOM_FIELDS_APPLICATION_FKAPPLICATION_CUSTOM_FIELDSYYAPP_IDAPP_ID
APPLICATION_LOOKUP_APPLICATION_FKAPPLICATION_LOOKUPYYAPP_IDAPP_ID
APPLICATION_MESSAGE_APPLICATION_FKAPPLICATION_MESSAGEYYAPP_IDAPP_ID
APPLICATION_MESSAGE_RECIPIENT_APPLICATION_FKAPPLICATION_MESSAGE_RECIPIENTYYAPP_IDAPP_ID
CANDIDATE_MILESTONE_APPLICATION_FKCANDIDATE_MILESTONEYYAPP_IDAPP_ID
CANDIDATE_WORKFLOW_APPLICATION_FKCANDIDATE_WORKFLOWYYAPP_IDAPP_ID
COMPLIANCE_APPLICATION_FKCOMPLIANCEYYAPP_IDAPP_ID
EDUCATION_APPLICATION_FKEDUCATIONYYAPP_IDAPP_ID
GDPR_APPLICATION_APPLICATION_FKGDPR_APPLICATIONYYAPP_IDAPP_ID
INTERVIEW_APPLICATION_FKINTERVIEWYYAPP_IDAPP_ID
LOOKUP_EID_APPLICATION_APPLICATION_FKLOOKUP_EID_APPLICATIONYYAPP_IDAPP_ID
ONBOARDING_NEW_HIRE_APPLICATION_FKONBOARDING_NEW_HIREYYAPP_IDAPP_ID
SCREENING_FORM_APPLICATION_FKSCREENING_FORMYYAPP_IDAPP_ID
SCREENING_FORM_VERIFY_APPLICATION_FKSCREENING_FORM_VERIFYYYAPP_IDAPP_ID
VIDEO_FORM_EVALUATION_APPLICATION_FKVIDEO_FORM_EVALUATIONYYAPP_IDAPP_ID
VIDEO_FORM_EVALUATION_QUESTION_APPLICATION_FKVIDEO_FORM_EVALUATION_QUESTIONYYAPP_IDAPP_ID
VIDEO_FORM_RESPONSE_APPLICATION_FKVIDEO_FORM_RESPONSEYYAPP_IDAPP_ID
VIDEO_FORM_RESPONSE_QUESTION_APPLICATION_FKVIDEO_FORM_RESPONSE_QUESTIONYYAPP_IDAPP_ID
WORK_HISTORY_APPLICATION_FKWORK_HISTORYYYAPP_IDAPP_ID
WORK_HISTORY_PROFILE_APPLICATION_FKWORK_HISTORY_PROFILEYYAPP_IDAPP_ID

 

Table NamePUBLIC.APPROVER
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APPROVER_IDPYBIGINTLT
2ITEM_IDFYBIGINTLT
3ITEM_KINDBIGINTLT
4USER_IDBIGINTLT
5COMPANY_IDFYBIGINT (38) LT
6APPROVER_STATUSVARCHAR (100) LT
7APPROVER_SUBMITTEDTimestampLT
8APPROVER_UPDATEDTimestampLT
9APPROVER_TIME_TO_UPDATEBIGINTLT
10APPROVER_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1APPROVER_IDApprover ID (Approval ID)

2ITEM_IDJob ID

3ITEM_KINDItem Kind (always Job, in this context)

4USER_IDApprover User ID (COMPANY_USER.company_user_id)

5COMPANY_IDApprover Company ID

6APPROVER_STATUSApprover Status Read Retracted Rejected Skipped Initial Replaced Approved

7APPROVER_SUBMITTEDApproval request sent date timestamp

8APPROVER_UPDATEDApprover Updated Date

9APPROVER_TIME_TO_UPDATEDuration in days between Approver_Submitted and Approver_Updated

10APPROVER_DELETEDApprover Deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
APPROVER_PKPKAPPROVER_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
APPROVER_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
APPROVER_JOB_FKJOBYYITEM_IDJOB_ID

 

Table NamePUBLIC.CAMPAIGN_CONTACT
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1CAMPAIGN_CONTACT_IDPYBIGINTLT
2CAMPAIGN_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4CAMPAIGN_CONTACT_STATUSVARCHAR (50) LT
5CAMPAIGN_CONTACT_LAST_CONTACTED_DATETimestampLT
6CAMPAIGN_CONTACT_UNSUBSCRIBED_DATETimestampLT
7CONTACT_IDFYBIGINTLT
8CAMPAIGN_CONTACT_CREATED_DATETimestampLT
9CAMPAIGN_CONTACT_UPDATED_DATETimestampLT
10CAMPAIGN_CONTACT_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1CAMPAIGN_CONTACT_IDCampaign and Contact ID unique identifier

2CAMPAIGN_IDCampaign ID

3COMPANY_IDCompany ID

4CAMPAIGN_CONTACT_STATUSCampaign Contact Status

5CAMPAIGN_CONTACT_LAST_CONTACTED_DATEContact last contacted date

6CAMPAIGN_CONTACT_UNSUBSCRIBED_DATEContact Unsubscribed Date

7CONTACT_IDContact ID

8CAMPAIGN_CONTACT_CREATED_DATEContact added to campaign date

9CAMPAIGN_CONTACT_UPDATED_DATECampaign contact record updated date

10CAMPAIGN_CONTACT_DELETEDCampaign contact deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
CAMPAIGN_CONTACT_PKPKCAMPAIGN_CONTACT_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
CAMPAIGN_CONTACT_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
CAMPAIGN_CONTACT_CAMPAIGN_FKCAMPAIGNYYCAMPAIGN_IDCAMPAIGN_ID
CAMPAIGN_CONTACT_CONTACT_FKCONTACTYYCONTACT_IDCONTACT_ID

 

Table NamePUBLIC.CANDIDATE_WORKFLOW
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


DescriptionThis table represents any combination of two workflow states when a candidate is moved from one to the other. The previous state represents the state the candidate is moved from, while the next state represents the state the candidate is moved to. In the event the candidate is in 'New' status, the previous workflow state will be empty and next workflow state will be' New'.
Notes

Number Of Columns17
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APP_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3APP_PREV_WORKFLOW_STATE_ITEM_IDBIGINTLT
4APP_PREV_WORKFLOW_STATE_DATETimestampLT
5APP_PREV_WORKFLOW_STATE_NAMEVARCHAR (100) LT
6APP_NEXT_WORKFLOW_STATE_ITEM_IDBIGINTLT
7APP_NEXT_WORKFLOW_STATE_DATETimestampLT
8APP_NEXT_WORKFLOW_STATE_NAMEVARCHAR (100) LT
9APP_WORKFLOW_STATE_IN_DAYSBIGINTLT
10APP_MODIFIEDTimestampLT
11APP_PREV_WORKFLOW_STATE_POSITIONBIGINTLT
12APP_NEXT_WORKFLOW_STATE_POSITIONBIGINTLT
13APP_NEXT_WORKFLOW_STATE_ACTION_USER_IDFBIGINTLT
14APP_WORKFLOW_ACTION_USER_FULL_NAMEVARCHAR (100) LT
15APP_WORKFLOW_ACTION_USER_EMAILVARCHAR (100) LT
16APP_WORKFLOW_WORKFLOW_IDPYBIGINTLT
17APP_WORKFLOW_STATE_IN_DAYS_NEXT_STATEBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1APP_IDApplication ID

2COMPANY_IDCompany ID

3APP_PREV_WORKFLOW_STATE_ITEM_IDApplication previous workflow state item ID

4APP_PREV_WORKFLOW_STATE_DATEApplication previous workflow state date timestamp

5APP_PREV_WORKFLOW_STATE_NAMEApplication previous workflow state name

6APP_NEXT_WORKFLOW_STATE_ITEM_IDApplication next workflow state item ID

7APP_NEXT_WORKFLOW_STATE_DATEApplication next workflow state date timestamp

8APP_NEXT_WORKFLOW_STATE_NAMEApplication next workflow state name

9APP_WORKFLOW_STATE_IN_DAYSApplication workflow previous state in days

10APP_MODIFIEDApplication last modified date timestamp

11APP_PREV_WORKFLOW_STATE_POSITIONApplication previous workflow state position

12APP_NEXT_WORKFLOW_STATE_POSITIONApplication next workflow state position

13APP_NEXT_WORKFLOW_STATE_ACTION_USER_IDApplication next workflow state action user ID (next step owner)

14APP_WORKFLOW_ACTION_USER_FULL_NAMEApplication workflow action user full name (Workflow actor) (COMPANY_USER.company_user_id)

15APP_WORKFLOW_ACTION_USER_EMAILApplication workflow action user email address (Workflow actor)

16APP_WORKFLOW_WORKFLOW_IDApplication workflow ID

17APP_WORKFLOW_STATE_IN_DAYS_NEXT_STATEApplication workflow next state in days (app_next_workflow_state_date to today)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
CANDIDATE_WORKFLOW_PKPKAPP_WORKFLOW_WORKFLOW_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
CANDIDATE_WORKFLOW_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
CANDIDATE_WORKFLOW_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
CANDIDATE_WORKFLOW_COMPANY_USER_FKCOMPANY_USERYAPP_NEXT_WORKFLOW_STATE_ACTION_USER_IDUSER_ID

 

Table NamePUBLIC.COMPANY_USER
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns42
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDPYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_FIRST_NAMEVARCHAR (100) LT
4USER_LAST_NAMEVARCHAR (100) LT
5USER_FULL_NAMEVARCHAR (210) LT
6USER_EMAILVARCHAR (100) LT
7USER_TITLEVARCHAR (100) LT
8USER_ADDRESSVARCHAR (100) LT
9USER_CITYVARCHAR (50) LT
10USER_POSTALCODEVARCHAR (20) LT
11USER_STATEVARCHAR (100) LT
12USER_ROLEVARCHAR (200) LT
13USER_CREATEDTimestampLT
14USER_HOMEPHONEVARCHAR (20) LT
15USER_WORKPHONEVARCHAR (20) LT
16USER_MOBILEVARCHAR (20) LT
17USER_IS_EMPLOYEEBooleanLT
18USER_COUNTRYVARCHAR (50) LT
19USER_DISABLEDBooleanLT
20USER_ZIPVARCHAR (20) LT
21USER_DEPARTMENTVARCHAR (50) LT
22USER_LOCATIONVARCHAR (50) LT
23USER_MODIFIEDTimestampLT
24USER_LAST_LOGGED_INTimestampLT
25USER_INVITATION_STATUSVARCHAR (100) LT
26USER_INVITATION_SENT_DATETimestampLT
27USER_INVITATION_ACCEPTED_DATETimestampLT
28USER_INVITATION_COMPANY_IDBIGINTLT
29USER_PUBLISHER_STATUSBooleanLT
30USER_ACTIVEBooleanLT
31USER_EMPLOYEE_IDVARCHAR (40) LT
32USER_LANGUAGEVARCHAR (150) LT
33USER_MANAGER_IDBIGINTLT
34USER_FACEBOOK_REQUIRES_REAUTHENTICATIONBooleanLT
35USER_FACEBOOK_REQUIRES_CONNECTIONBooleanLT
36USER_LINKEDIN_REQUIRES_REAUTHENTICATIONBooleanLT
37USER_LINKEDIN_REQUIRES_CONNECTIONBooleanLT
38USER_TWITTER_REQUIRES_REAUTHENTICATIONBooleanLT
39USER_TWITTER_REQUIRES_CONNECTIONBooleanLT
40USER_FACEBOOK_REQUIRES_STATUS_UPDATE_ENABLEBooleanLT
41USER_LINKEDIN_REQUIRES_STATUS_UPDATE_ENABLEBooleanLT
42USER_TWITTER_REQUIRES_STATUS_UPDATE_ENABLEBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID

2COMPANY_IDCompany ID

3USER_FIRST_NAMEUser first name

4USER_LAST_NAMEUser last name

5USER_FULL_NAMEUser full name

6USER_EMAILUser email address

7USER_TITLEUser title

8USER_ADDRESSUser address

9USER_CITYUser city

10USER_POSTALCODEUser postal code

11USER_STATEUser state

12USER_ROLEUser role

13USER_CREATEDUser created date timestamp

14USER_HOMEPHONEUser home phone number

15USER_WORKPHONEUser workphone number

16USER_MOBILEUser mobile phone number

17USER_IS_EMPLOYEEUser is employee flag - used to differentiate candidates from employee users (TRUE/FALSE)

18USER_COUNTRYUser country

19USER_DISABLEDUser disabled flag - no longer active (TRUE/FALSE)

20USER_ZIPUser zip code

21USER_DEPARTMENTUser department

22USER_LOCATIONUser location

23USER_MODIFIEDUser last modified date timestamp

25USER_INVITATION_STATUSUser invitation status

26USER_INVITATION_SENT_DATEUser invitation sent date

27USER_INVITATION_ACCEPTED_DATEUser invitation accepted date

28USER_INVITATION_COMPANY_IDUser invitation company ID

29USER_PUBLISHER_STATUSUser publisher status

30USER_ACTIVEUser active (TRUE/FALSE)

31USER_EMPLOYEE_IDUser employee ID

32USER_LANGUAGEUser default language

33USER_MANAGER_IDUser manager ID

34USER_FACEBOOK_REQUIRES_REAUTHENTICATIONUser - Facebook requires re-authentication (TRUE/FALSE)

35USER_FACEBOOK_REQUIRES_CONNECTIONUser - Facebook requires connection (TRUE/FALSE)

36USER_LINKEDIN_REQUIRES_REAUTHENTICATIONUser - LinkedIn requires re-authentication (TRUE/FALSE)

37USER_LINKEDIN_REQUIRES_CONNECTIONUser - LinkedIn requires connection (TRUE/FALSE)

38USER_TWITTER_REQUIRES_REAUTHENTICATIONUser - Twitter requires re-authentication (TRUE/FALSE)

39USER_TWITTER_REQUIRES_CONNECTIONUser - Twitter requires connection (TRUE/FALSE)

40USER_FACEBOOK_REQUIRES_STATUS_UPDATE_ENABLEUser - Facebook requires status updated enabled (TRUE/FALSE)

41USER_LINKEDIN_REQUIRES_STATUS_UPDATE_ENABLEUser - LinkedIn requires status updated enabled (TRUE/FALSE)

42USER_TWITTER_REQUIRES_STATUS_UPDATE_ENABLEUser - Twitter requires status updated enabled (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
COMPANY_USER_PKPKUSER_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
COMPANY_USER_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
AGENCY_JOB_COMPANY_USER_FKAGENCY_JOBYYUSER_IDUSER_ID
AGENCY_USER_COMPANY_USER_FKAGENCY_USERYYAGENCY_USER_IDUSER_ID
APPLICATION_COMPANY_USER_FKAPPLICATIONYYAPP_USER_IDUSER_ID
APPLICATION_MESSAGE_COMPANY_USER_FKAPPLICATION_MESSAGEYYUSER_IDUSER_ID
CAMPAIGN_COMPANY_USER_FKCAMPAIGNYYUSER_IDUSER_ID
CANDIDATE_WORKFLOW_COMPANY_USER_FKCANDIDATE_WORKFLOWYAPP_NEXT_WORKFLOW_STATE_ACTION_USER_IDUSER_ID
COMPANY_USER_CUSTOM_FIELDS_COMPANY_USER_FKCOMPANY_USER_CUSTOM_FIELDSYYUSER_IDUSER_ID
COMPANY_USER_ROLES_COMPANY_USER_FKCOMPANY_USER_ROLESYYUSER_IDUSER_ID
CONTACT_COMPANY_USER_FKCONTACTYYUSER_IDUSER_ID
CONTACT_STATUS_HISTORY_COMPANY_USER_FKCONTACT_STATUS_HISTORYYYUSER_IDUSER_ID
GDPR_ONBOARDING_ENTITY_COMPANY_USER_FKGDPR_ONBOARDING_ENTITYYYGDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERIDUSER_ID
INTERVIEW_COMPANY_USER_FKINTERVIEWYYUSER_IDUSER_ID
JOB_MESSAGE_COMPANY_USER_FKJOB_MESSAGEYYUSER_IDUSER_ID
JOB_OWNER_APPROVER_COMPANY_USER_FKJOB_OWNER_APPROVERYYUSER_IDUSER_ID
JOB_OWNER_COMPANY_USER_FKJOB_OWNERYYUSER_IDUSER_ID
OFCCP_SEARCH_COMPANY_USER_FKOFCCP_SEARCHYYUSER_IDUSER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKONBOARDING_NEW_HIREYYONB_NEW_HIRE_CREATED_BY_USER_IDUSER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv1ONBOARDING_NEW_HIREYYONB_NEW_HIRE_HIRING_MANAGER_USER_IDUSER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv2ONBOARDING_NEW_HIREYYONB_NEW_HIRE_MODIFIED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKONBOARDING_PROCESSYYONB_PROCESS_MODIFIED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv1ONBOARDING_PROCESSYYONB_PROCESS_CREATED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv2ONBOARDING_PROCESSYYONB_HIRING_MANAGER_USER_IDUSER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKONBOARDING_PROCESS_TEMPLATEYYONB_PROCESS_TEMPLATE_CREATED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKv1ONBOARDING_PROCESS_TEMPLATEYYONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_IDUSER_ID
ONBOARDING_TASK_COMPANY_USER_FKONBOARDING_TASKYYONB_TASK_ASSIGNEE_USER_IDUSER_ID
ONBOARDING_TASK_COMPANY_USER_FKv1ONBOARDING_TASKYYONB_TASK_CREATED_BY_USER_IDUSER_ID
ONBOARDING_TASK_COMPANY_USER_FKv2ONBOARDING_TASKYYONB_TASK_MODIFIED_BY_USER_IDUSER_ID
REQUISITION_ACCESS_COMPANY_USER_FKREQUISITION_ACCESSYYUSER_IDUSER_ID
SOURCE_DATA_COMPANY_USER_FKSOURCE_DATAYYUSER_IDUSER_ID
USER_ACTIVITY_COMPANY_USER_FKUSER_ACTIVITYYYUSER_IDUSER_ID
USER_ASSIGNED_JOB_ID_TO_JOB_CAT_COMPANY_USER_FKUSER_ASSIGNED_JOB_ID_TO_JOB_CATYYUSER_IDUSER_ID
USER_JOBVITE_ACTIVITY_COMPANY_USER_FKUSER_JOBVITE_ACTIVITYYYUSER_IDUSER_ID
VIDEO_FORM_EVALUATION_COMPANY_USER_FKVIDEO_FORM_EVALUATIONYYUSER_IDUSER_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_USER_FKVIDEO_FORM_EVALUATION_QUESTIONYYUSER_IDUSER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKVIDEO_FORM_RESPONSEYYSENT_BY_USER_IDUSER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKv1VIDEO_FORM_RESPONSEYINTERVIEWEE_USER_IDUSER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKVIDEO_FORM_RESPONSE_QUESTIONYINTERVIEWEE_USER_IDUSER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKv1VIDEO_FORM_RESPONSE_QUESTIONYYSENT_BY_USER_IDUSER_ID
VIDEO_QUESTION_COMPANY_USER_FKVIDEO_QUESTIONYYUSER_IDUSER_ID

 

Table NamePUBLIC.COMPLIANCE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns40
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1COMPLIANCE_IDPYBIGINTLT
2APP_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4COMPLIANCE_PREOFFER_GENDERVARCHAR (30) LT
5COMPLIANCE_POSTOFFER_GENDERVARCHAR (30) LT
6COMPLIANCE_PREOFFER_ETHNICITYVARCHAR (30) LT
7COMPLIANCE_POSTOFFER_ETHNICITYVARCHAR (30) LT
8COMPLIANCE_PREOFFER_EEOFORM_FULLNAMEVARCHAR (100) LT
9COMPLIANCE_POSTOFFER_EEOFORM_FULLNAMEVARCHAR (100) LT
10COMPLIANCE_PREOFFER_EEOFORM_SUBMITDATETimestampLT
11COMPLIANCE_POSTOFFER_EEOFORM_SUBMITDATETimestampLT
12COMPLIANCE_PREOFFER_RACEVARCHAR (30) LT
13COMPLIANCE_POSTOFFER_RACEVARCHAR (30) LT
14COMPLIANCE_POSTOFFER_DISABLEDVETERANBooleanLT
15COMPLIANCE_POSTOFFER_RECENTLYSEPERATEDBooleanLT
16COMPLIANCE_POSTOFFER_ARMEDFORCESSERVICEMEDALVETERANBooleanLT
17COMPLIANCE_PREOFFER_PROTECTEDVETERANBooleanLT
18COMPLIANCE_POSTOFFER_PROTECTEDVETERANBooleanLT
19COMPLIANCE_PREOFFER_NOTPROTECTEDVETERANBooleanLT
20COMPLIANCE_POSTOFFER_NOTPROTECTEDVETERANBooleanLT
21COMPLIANCE_POSTOFFER_ACTIVEWARTIMEORCAMPAIGNBADGEVETERANBooleanLT
22COMPLIANCE_PREOFFER_DECLINETOSELFIDENTIFYVETERANSTATUSBooleanLT
23COMPLIANCE_POSTOFFER_DECLINETOSELFIDENTIFYVETERANSTATUSBooleanLT
24COMPLIANCE_PREOFFER_VETERANFORM_FULLNAMEVARCHAR (100) LT
25COMPLIANCE_POSTOFFER_VETERANFORM_FULLNAMEVARCHAR (100) LT
26COMPLIANCE_PREOFFER_VETERANFORM_SUBMITDATETimestampLT
27COMPLIANCE_POSTOFFER_VETERANFORM_SUBMITDATETimestampLT
28COMPLIANCE_PREOFFER_DISABILITYSTATUSVARCHAR (20) LT
29COMPLIANCE_POSTOFFER_DISABILITYSTATUSVARCHAR (20) LT
30COMPLIANCE_PREOFFER_DISABILITYFORM_FULLNAMEVARCHAR (100) LT
31COMPLIANCE_POSTOFFER_DISABILITYFORM_FULLNAMEVARCHAR (100) LT
32COMPLIANCE_PREOFFER_DISABILITYFORM_SUBMITDATETimestampLT
33COMPLIANCE_POSTOFFER_DISABILITYFORM_SUBMITDATETimestampLT
34COMPLIANCE_PREOFFER_FORM_SENT_DATETimestampLT
35COMPLIANCE_PREOFFER_FORM_STATUSVARCHAR (10) LT
36COMPLIANCE_POSTOFFER_FORM_SENT_DATETimestampLT
37COMPLIANCE_POSTOFFER_FORM_STATUSVARCHAR (10) LT
38COMPLIANCE_UPDATEDATETimestampLT
39COMPLIANCE_PREOFFER_FORM_COMPLETED_DATETimestampLT
40COMPLIANCE_POSTOFFER_FORM_COMPLETED_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1COMPLIANCE_IDCompliance record ID

2APP_IDApplication ID

3COMPANY_IDCompany ID

4COMPLIANCE_PREOFFER_GENDERPreoffer Gender

5COMPLIANCE_POSTOFFER_GENDERPost offer Gender

6COMPLIANCE_PREOFFER_ETHNICITYPreoffer Ethnicity

7COMPLIANCE_POSTOFFER_ETHNICITYPost offer Ethnicity

8COMPLIANCE_PREOFFER_EEOFORM_FULLNAMEPreoffer EEO Form full name

9COMPLIANCE_POSTOFFER_EEOFORM_FULLNAMEPost offer EEO Form full name

10COMPLIANCE_PREOFFER_EEOFORM_SUBMITDATEPreoffer EEO Form submitted date

11COMPLIANCE_POSTOFFER_EEOFORM_SUBMITDATEPost offer EEO Form submitted date

12COMPLIANCE_PREOFFER_RACEPre offer Race

13COMPLIANCE_POSTOFFER_RACEPost offer Race

14COMPLIANCE_POSTOFFER_DISABLEDVETERANPost offer Disabled Veteran status (TRUE/FALSE)

15COMPLIANCE_POSTOFFER_RECENTLYSEPERATEDPost offer Recently Separated Veteran status (TRUE/FALSE)

16COMPLIANCE_POSTOFFER_ARMEDFORCESSERVICEMEDALVETERANPost offer Armed Forces Service Medal Veteran status (TRUE/FALSE)

17COMPLIANCE_PREOFFER_PROTECTEDVETERANPreoffer Protected Veteran status (TRUE/FALSE)

18COMPLIANCE_POSTOFFER_PROTECTEDVETERANPost offer Protected Veteran status (TRUE/FALSE)

19COMPLIANCE_PREOFFER_NOTPROTECTEDVETERANPreoffer Not a Protected Veteran status (TRUE/FALSE)

20COMPLIANCE_POSTOFFER_NOTPROTECTEDVETERANPost offer Not a Protected Veteran status (TRUE/FALSE)

21COMPLIANCE_POSTOFFER_ACTIVEWARTIMEORCAMPAIGNBADGEVETERANPost offer Active Wartime or Campaign Veteran status (TRUE/FALSE)

22COMPLIANCE_PREOFFER_DECLINETOSELFIDENTIFYVETERANSTATUSPreoffer decline to self identify Veteran status (TRUE/FALSE)

23COMPLIANCE_POSTOFFER_DECLINETOSELFIDENTIFYVETERANSTATUSPost offer decline to self identify Veteran status (TRUE/FALSE)

24COMPLIANCE_PREOFFER_VETERANFORM_FULLNAMEPreoffer Veteran Form full name

25COMPLIANCE_POSTOFFER_VETERANFORM_FULLNAMEPost offer Veteran Form full name

26COMPLIANCE_PREOFFER_VETERANFORM_SUBMITDATEPreoffer Veteran Form submit date

27COMPLIANCE_POSTOFFER_VETERANFORM_SUBMITDATEPost offer Veteran Form submit date

28COMPLIANCE_PREOFFER_DISABILITYSTATUSPreoffer disability status

29COMPLIANCE_POSTOFFER_DISABILITYSTATUSPost offer disability status

30COMPLIANCE_PREOFFER_DISABILITYFORM_FULLNAMEPreoffer disability form full name

31COMPLIANCE_POSTOFFER_DISABILITYFORM_FULLNAMEPost offer disability form full name

32COMPLIANCE_PREOFFER_DISABILITYFORM_SUBMITDATEPreoffer disability form submitted date

33COMPLIANCE_POSTOFFER_DISABILITYFORM_SUBMITDATEPost offer disability form submitted date

34COMPLIANCE_PREOFFER_FORM_SENT_DATEPreoffer form sent date

35COMPLIANCE_PREOFFER_FORM_STATUSPreoffer form status

36COMPLIANCE_POSTOFFER_FORM_SENT_DATEPost offer form sent date

37COMPLIANCE_POSTOFFER_FORM_STATUSPost offer form status

38COMPLIANCE_UPDATEDATECompliance record last updated date

39COMPLIANCE_PREOFFER_FORM_COMPLETED_DATEPreoffer form completed date

40COMPLIANCE_POSTOFFER_FORM_COMPLETED_DATEPostoffer form completed date

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
COMPLIANCE_PKPKCOMPLIANCE_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
COMPLIANCE_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
COMPLIANCE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.CONTACT
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns53
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1CONTACT_IDPYBIGINTLT
2USER_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4CONTACT_CREATED_DATETimestampLT
5CONTACT_MODIFIED_DATETimestampLT
6CONTACT_FIRST_NAMEVARCHAR (100) LT
7CONTACT_LAST_NAMEVARCHAR (100) LT
8CONTACT_MIDDLE_NAMEVARCHAR (100) LT
9CONTACT_FULL_NAMEVARCHAR (200) LT
10CONTACT_JOB_TITLEVARCHAR (100) LT
11CONTACT_COMPANY_NAMEVARCHAR (100) LT
12CONTACT_DEPARTMENT_NAMEVARCHAR (100) LT
13CONTACT_SOURCE_NAMEVARCHAR (100) LT
14CONTACT_GENDERVARCHAR (20) LT
15CONTACT_RACEVARCHAR (20) LT
16CONTACT_STATUS_IDBIGINTLT
17CONTACT_STATUSVARCHAR (50) LT
18CONTACT_ASSIGNED_TOBIGINTLT
19CONTACT_ADDRESS1VARCHAR (100) LT
20CONTACT_ADDRESS2VARCHAR (50) LT
21CONTACT_ADDRESS3VARCHAR (50) LT
22CONTACT_CITYVARCHAR (50) LT
23CONTACT_STATEVARCHAR (50) LT
24CONTACT_ZIPVARCHAR (10) LT
25CONTACT_COUNTRYVARCHAR (50) LT
26CONTACT_EMAIL_STATUSVARCHAR (50) LT
27CONTACT_TAGSVARCHAR (65535) LT
28CONTACT_NOTESVARCHAR (65535) LT
29CONTACT_ADDRESS_NOTESVARCHAR (100) LT
30CONTACT_ADDRESS_TYPEVARCHAR (50) LT
31CONTACT_PRIMARY_PHONEVARCHAR (20) LT
32CONTACT_PRIMARY_EMAILVARCHAR (50) LT
33CONTACT_CUSTOM_DATAVARCHAR (65535) LT
34CONTACT_SOCIAL_NETWORK_URLSVARCHAR (200) LT
35CONTACT_WEBSITESVARCHAR (200) LT
36CONTACT_NOTES_LAST_UPDATEDTimestampLT
37CONTACT_NOTES_LAST_UPDATED_BYBIGINTLT
38CONTACT_DELETEDBooleanLT
39CONTACT_SOURCE_TYPE_IDBIGINTLT
40CONTACT_SOURCE_TYPEVARCHAR (128) LT
41CANDIDATE_IDBIGINTLT
42CONTACT_JOB_ALERTS_SUBSCRIBEDBooleanLT
43CONTACT_JOB_ALERTS_ACTIVEBooleanLT
44CONTACT_GDPR_CONSENT_DATETimestampLT
45CONTACT_GDPR_CONSENT_LAST_REQUESTED_DATETimestampLT
46CONTACT_GDPR_CONSENT_LOC_LANVARCHAR (100) LT
47CONTACT_GDPR_DELETION_DATETimestampLT
48CONTACT_GDPR_CONSENT_LINKVARCHAR (255) LT
49CONTACT_GDPR_FORGOTTENBooleanLT
50CONTACT_GDPR_CONSENT_STATUSVARCHAR (100) LT
51CONTACT_EIDVARCHAR (50) LT
52COMPANY_DOUBLE_EIDVARCHAR (100) LT
53CONTACT_CONSENT_URLVARCHAR (500) LT

Columns Comments
NoColumn NameDescriptionNotes
1CONTACT_IDContact ID

2USER_IDUser ID

3COMPANY_IDCompany ID

4CONTACT_CREATED_DATEContact created date timestamp

5CONTACT_MODIFIED_DATEContact last modified date timestamp

6CONTACT_FIRST_NAMEContact first name

7CONTACT_LAST_NAMEContact last name

8CONTACT_MIDDLE_NAMEContact middle name

9CONTACT_FULL_NAMEContact full name

10CONTACT_JOB_TITLEContact job title

11CONTACT_COMPANY_NAMEContact company name

12CONTACT_DEPARTMENT_NAMEContact department name

13CONTACT_SOURCE_NAMEContact source name

14CONTACT_GENDERContact gender

15CONTACT_RACEContact race

16CONTACT_STATUS_IDContact status ID

17CONTACT_STATUSContact Status Alumni Available Candidate Contacted Do Not Contact Do Not Hire Employy Future New Newly Hired Not Interested Warm

18CONTACT_ASSIGNED_TOContact assigned to user (Contact ID)

19CONTACT_ADDRESS1Contact address line 1

20CONTACT_ADDRESS2Contact address line 2

21CONTACT_ADDRESS3Contact address line 3

22CONTACT_CITYContact city

23CONTACT_STATEContact state

24CONTACT_ZIPContact zip code

25CONTACT_COUNTRYContact country

26CONTACT_EMAIL_STATUSContact email status Has not opted out Opted out Limited Bounced

27CONTACT_TAGSContact Tags

28CONTACT_NOTESContact notes

29CONTACT_ADDRESS_NOTESContact address notes

30CONTACT_ADDRESS_TYPEContact address type

31CONTACT_PRIMARY_PHONEContact primary phone number

32CONTACT_PRIMARY_EMAILContact primary email address

33CONTACT_CUSTOM_DATAContact custom data

34CONTACT_SOCIAL_NETWORK_URLSContact social network URLs

35CONTACT_WEBSITESContact websites

36CONTACT_NOTES_LAST_UPDATEDContact notes last updated date timestamp

37CONTACT_NOTES_LAST_UPDATED_BYContact notes last update by (UserID)

38CONTACT_DELETEDContact deleted (TRUE/FALSE)

39CONTACT_SOURCE_TYPE_IDContact source type ID

40CONTACT_SOURCE_TYPEContact source type Agency Campaing Career Site Email Employee Hiring Manager Import Internal Internal Transfer Job Board Job Notification Recruiter Resume Search Web Search

41CANDIDATE_IDCandidate ID

42CONTACT_JOB_ALERTS_SUBSCRIBEDContact is subscribed to job alerts (TRUE/FALSE)

43CONTACT_JOB_ALERTS_ACTIVEContact signed up for active job alerts (TRUE/FALSE)

44CONTACT_GDPR_CONSENT_DATEContact GDPR consent given date timestamp

45CONTACT_GDPR_CONSENT_LAST_REQUESTED_DATEContact GDPR last consent requested date timestamp

46CONTACT_GDPR_CONSENT_LOC_LANContact GDPR consent location language

47CONTACT_GDPR_DELETION_DATEContact GDPR deletion date

48CONTACT_GDPR_CONSENT_LINKContact GDPR consent link

49CONTACT_GDPR_FORGOTTENContact GDPR forgotten (TRUE/FALSE)

50CONTACT_GDPR_CONSENT_STATUSContact GDPR Consent status Not requested Requested Consented Declined

51CONTACT_EIDContact encrypted ID

52COMPANY_DOUBLE_EIDContact double encrypted ID

53CONTACT_CONSENT_URLContact consent URL

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
CONTACT_PKPKCONTACT_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
CONTACT_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
CONTACT_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
CAMPAIGN_CONTACT_CONTACT_FKCAMPAIGN_CONTACTYYCONTACT_IDCONTACT_ID
CONTACT_CUSTOM_FIELDS_CONTACT_FKCONTACT_CUSTOM_FIELDSYYCONTACT_IDCONTACT_ID
CONTACT_STATUS_HISTORY_CONTACT_FKCONTACT_STATUS_HISTORYYYCONTACT_IDCONTACT_ID
CONTACT_URL_CONTACT_FKCONTACT_URLYYCONTACT_IDCONTACT_ID
EMAIL_CAMPAIGN_CONTACT_CONTACT_FKEMAIL_CAMPAIGN_CONTACTYYCONTACT_IDCONTACT_ID
GDPR_CONTACT_CONTACT_FKGDPR_CONTACTYYCONTACT_IDCONTACT_ID
LOOKUP_EID_CONTACT_CONTACT_FKLOOKUP_EID_CONTACTYYCONTACT_IDCONTACT_ID
LOOKUP_EID_DOUBLE_ENCRYPTED_CONTACT_CONTACT_FKLOOKUP_EID_DOUBLE_ENCRYPTED_CONTACTYYCONTACT_IDCONTACT_ID

 

Table NamePUBLIC.CONTACT_STATUS_HISTORY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns13
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1CONTACT_STATUS_HISTORY_IDPYBIGINTLT
2USER_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4CONTACT_IDFYBIGINTLT
5CONTACT_STATUS_HISTORY_CREATED_DATETimestampLT
6CONTACT_STATUS_HISTORY_MODIFIED_DATETimestampLT
7CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_IDBIGINTLT
8CONTACT_STATUS_HISTORY_PREVIOUS_STATUSVARCHAR (50) LT
9CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_DATETimestampLT
10CONTACT_STATUS_HISTORY_NEXT_STATUS_IDBIGINTLT
11CONTACT_STATUS_HISTORY_NEXT_STATUSVARCHAR (50) LT
12CONTACT_STATUS_HISTORY_NEXT_STATUS_DATETimestampLT
13CONTACT_STATUS_HISTORY_STATUS_IN_DAYSBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1CONTACT_STATUS_HISTORY_IDContact status history record ID

2USER_IDUser ID

3COMPANY_IDCompany ID

4CONTACT_IDContact ID

5CONTACT_STATUS_HISTORY_CREATED_DATEContact status history record created date timestamp

6CONTACT_STATUS_HISTORY_MODIFIED_DATEContact status history record last modified date timestamp

7CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_IDContact previous status record ID

8CONTACT_STATUS_HISTORY_PREVIOUS_STATUSContact previous status

9CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_DATEContact previous status start date timestamp

10CONTACT_STATUS_HISTORY_NEXT_STATUS_IDContact next status record ID

11CONTACT_STATUS_HISTORY_NEXT_STATUSContact next status

12CONTACT_STATUS_HISTORY_NEXT_STATUS_DATEContact next status start date timestamp

13CONTACT_STATUS_HISTORY_STATUS_IN_DAYSContact history status in days (Previous status date to next status date)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
CONTACT_STATUS_HISTORY_PKPKCONTACT_STATUS_HISTORY_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
CONTACT_STATUS_HISTORY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
CONTACT_STATUS_HISTORY_CONTACT_FKCONTACTYYCONTACT_IDCONTACT_ID
CONTACT_STATUS_HISTORY_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.EDUCATION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APP_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3CANDIDATE_IDBIGINTLT
4EDUCATION_COLLEGE_NAMEVARCHAR (200) LT
5EDUCATION_DEGREE_NAMEVARCHAR (200) LT
6EDUCATION_MAJORVARCHAR (200) LT
7EDUCATION_DEGREE_TYPEVARCHAR (50) LT
8EDUCATION_START_DATEVARCHAR (20) LT
9EDUCATION_END_DATEVARCHAR (20) LT
10EDUCATION_MODIFIED_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1APP_IDApplication ID

2COMPANY_IDCompany ID

3CANDIDATE_IDCandidate ID

4EDUCATION_COLLEGE_NAMEEducation College name

5EDUCATION_DEGREE_NAMEEducation degree name

6EDUCATION_MAJOREducation major

7EDUCATION_DEGREE_TYPEEducation Degree type

8EDUCATION_START_DATEEducation start date

9EDUCATION_END_DATEEducation end date

10EDUCATION_MODIFIED_DATEEducation record last modified date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
EDUCATION_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
EDUCATION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.ENGAGE_USER
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns2
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDPYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ENGAGE_USER_PKPKUSER_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGNYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGEYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_CONTACT_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_CONTACTYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_CONTACT_STATUS_HISTORY_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_CONTACT_STATUS_HISTORYYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_ENGAGE_USER_FKENGAGE_USER_ACTIVITYYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_JOB_MESSAGE_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_JOB_MESSAGEYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_TASK_ENGAGE_USER_FKENGAGE_USER_ACTIVITY_TASKYYUSER_IDUSER_ID

 

Table NamePUBLIC.ENGAGE_USER_ACTIVITY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns41
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_ACTIVITY_DATETimestampLT
4USER_MESSAGES_SENT_TO_CONTACTSBIGINTLT
5USER_SHARE_CONTACT_COUNTBIGINTLT
6USER_REQUISITION_COUNTBIGINTLT
7USER_ASSIGNED_CONTACTSBIGINTLT
8USER_CONTACTS_ADDEDBIGINTLT
9USER_ACTIVE_EMAIL_CAMPAIGNSBIGINTLT
10USER_ACTIVE_SOCIAL_CAMPAIGNSBIGINTLT
11USER_ACTIVE_WEBPAGE_CAMPAIGNSBIGINTLT
12USER_CONTACTS_MOVEDBIGINTLT
13USER_SOCIAL_CAMPAIGN_MESSAGES_SENTBIGINTLT
14USER_EMAIL_CAMPAIGN_MESSAGES_SENTBIGINTLT
15USER_TASK_CREATEDBIGINTLT
16USER_TASK_COMPLETEDBIGINTLT
17USER_TASK_INCOMPLETEBIGINTLT
18USER_TASK_OVERDUEBIGINTLT
19USER_JOBVITE_RECEIVEBIGINTLT
20USER_JOBVITE_SENDBIGINTLT
21USER_JOBVITE_BROADCASTBIGINTLT
22USER_JOBVITE_VIEWBIGINTLT
23USER_JOBVITE_CLICK_TO_APPLYBIGINTLT
24USER_JOBVITE_FORWARDBIGINTLT
25USER_JOBVITE_APPLYBIGINTLT
26USER_JOBVITE_HIREBIGINTLT
27USER_JOBVITE_EMAIL_DIRECTBIGINTLT
28USER_JOBVITE_LINKEDIN_DIRECTBIGINTLT
29USER_JOBVITE_LINKEDIN_BROADCASTBIGINTLT
30USER_JOBVITE_FACEBOOK_BROADCASTBIGINTLT
31USER_JOBVITE_TWITTER_BROADCASTBIGINTLT
32USER_JOBVITE_JOBLINK_BROADCASTBIGINTLT
33USER_CANDIDATES_ADDEDBIGINTLT
34USER_CONTACTS_MOVED_CONTACTEDBIGINTLT
35USER_CONTACTS_MOVED_HIREDBIGINTLT
36USER_ACTIVE_CAMPAIGNSBIGINTLT
37USER_PUBLISHER_STATUSBooleanLT
38USER_CONTACTS_EVER_MOVED_CANDIDATE_STATUSBIGINTLT
39USER_CONTACTS_EVER_MOVED_CONTACTED_STATUSBIGINTLT
40USER_CONTACTS_EVER_MOVED_HIRED_STATUSBIGINTLT
41USER_NOTES_ADDEDBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

3USER_ACTIVITY_DATEUser activity date timestamp

4USER_MESSAGES_SENT_TO_CONTACTSNumber of messages sent to contacts

5USER_SHARE_CONTACT_COUNTShare contact count

6USER_REQUISITION_COUNTRequisition count

7USER_ASSIGNED_CONTACTSNumber of assigned contacts

8USER_CONTACTS_ADDEDNumber of contacts added

9USER_ACTIVE_EMAIL_CAMPAIGNSNumber of active email campaigns

10USER_ACTIVE_SOCIAL_CAMPAIGNSNumber of active social campaigns

11USER_ACTIVE_WEBPAGE_CAMPAIGNSNumber of active webpage campaigns

12USER_CONTACTS_MOVEDNumber of contacts moved

13USER_SOCIAL_CAMPAIGN_MESSAGES_SENTNumber of social campaign messages sent

14USER_EMAIL_CAMPAIGN_MESSAGES_SENTNumber of email campaign messages sent

15USER_TASK_CREATEDNumber of tasks created

16USER_TASK_COMPLETEDNumber of tasks completed

17USER_TASK_INCOMPLETENumber of incomplete tasks

18USER_TASK_OVERDUENumber of overdue tasks

19USER_JOBVITE_RECEIVENumber of Jobvites received

20USER_JOBVITE_SENDNumber of Jobvites sent

21USER_JOBVITE_BROADCASTNumber of Jobvites broadcasted

22USER_JOBVITE_VIEWNumber of Jobvites viewed

23USER_JOBVITE_CLICK_TO_APPLYNumber of Jobvite apply clicks

24USER_JOBVITE_FORWARDNumber of Jobvites forwarded

25USER_JOBVITE_APPLYNumber of Jobvite applies

26USER_JOBVITE_HIRENumber of Jobvite hires

27USER_JOBVITE_EMAIL_DIRECTNumber of Jobvite direct emails

28USER_JOBVITE_LINKEDIN_DIRECTNumber of Jobvite LinkedIn direct messages

29USER_JOBVITE_LINKEDIN_BROADCASTNumber of Jobvite LinkedIn broadcasts

30USER_JOBVITE_FACEBOOK_BROADCASTNumber of Jobvite Facebook broadcasts

31USER_JOBVITE_TWITTER_BROADCASTNumber of Jobvite Twitter broadcasts

32USER_JOBVITE_JOBLINK_BROADCASTNumber of Jobvite JobLinks broadcast

33USER_CANDIDATES_ADDEDNumber of candidates added

34USER_CONTACTS_MOVED_CONTACTEDNumber of contacts moved to Contacted status

35USER_CONTACTS_MOVED_HIREDNumber of contacts moved to Hired status

36USER_ACTIVE_CAMPAIGNSTotal number of active campaigns

37USER_PUBLISHER_STATUSUser has publisher status (TRUE/FALSE)

38USER_CONTACTS_EVER_MOVED_CANDIDATE_STATUSTotal number of contacts ever moved into Candidate status

39USER_CONTACTS_EVER_MOVED_CONTACTED_STATUSTotal number of contacts ever moved into Contacted status

40USER_CONTACTS_EVER_MOVED_HIRED_STATUSTotal number of contacts ever moved into Hired status

41USER_NOTES_ADDEDNumber of user notes added

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_ACTIVITY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ENGAGE_USER_ACTIVITY_ENGAGE_USER_FKENGAGE_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_ACTIVITY_DATETimestampLT
4USER_ACTIVE_EMAIL_CAMPAIGNSBIGINTLT
5USER_ACTIVE_SOCIAL_CAMPAIGNSBIGINTLT
6USER_ACTIVE_WEBPAGE_CAMPAIGNSBIGINTLT
7USER_ACTIVE_CAMPAIGNSBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

3USER_ACTIVITY_DATEActive campaign activity record date timestamp

4USER_ACTIVE_EMAIL_CAMPAIGNSNumber of active email campaigns

5USER_ACTIVE_SOCIAL_CAMPAIGNSNumber of active social campaigns

6USER_ACTIVE_WEBPAGE_CAMPAIGNSNumber of active webpage campaigns

7USER_ACTIVE_CAMPAIGNSTotal number of active campaigns

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_ENGAGE_USER_FKENGAGE_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_ACTIVITY_DATETimestampLT
4USER_SOCIAL_CAMPAIGN_MESSAGES_SENTBIGINTLT
5USER_EMAIL_CAMPAIGN_MESSAGES_SENTBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

3USER_ACTIVITY_DATECampaign message activity date timestamp

4USER_SOCIAL_CAMPAIGN_MESSAGES_SENTNumber of social campaign messages sent

5USER_EMAIL_CAMPAIGN_MESSAGES_SENTNumber of email campaign messages sent

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_ENGAGE_USER_FKENGAGE_USERYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.ENGAGE_USER_ACTIVITY_CONTACT
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_ACTIVITY_DATETimestampLT
4USER_ASSIGNED_CONTACTSBIGINTLT
5USER_CONTACTS_MOVEDBIGINTLT
6USER_CONTACTS_ADDEDBIGINTLT
7USER_CANDIDATES_ADDEDBIGINTLT
8USER_CONTACTS_MOVED_CONTACTEDBIGINTLT
9USER_CONTACTS_MOVED_HIREDBIGINTLT
10USER_NOTES_ADDEDBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

3USER_ACTIVITY_DATEContact activity record date timestamp

4USER_ASSIGNED_CONTACTSNumber of assigned contacts

5USER_CONTACTS_MOVEDNumber of contacts moved

6USER_CONTACTS_ADDEDNumber of contacts added

7USER_CANDIDATES_ADDEDNumber of candidates added

8USER_CONTACTS_MOVED_CONTACTEDNumber of contacts moved to Contacted status

9USER_CONTACTS_MOVED_HIREDNumber of contacts moved to Hired status

10USER_NOTES_ADDEDNumber of notes added

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ENGAGE_USER_ACTIVITY_CONTACT_ENGAGE_USER_FKENGAGE_USERYYUSER_IDUSER_ID
ENGAGE_USER_ACTIVITY_CONTACT_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.GDPR_APPLICATION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns19
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APP_IDFYBIGINTLT
2APP_EIDVARCHAR (50) LT
3COMPANY_IDFYBIGINT (38) LT
4GDPR_APP_SENT_DATETimestampLT
5GDPR_APP_REMOVED_DATETimestampLT
6GDPR_APP_REMOVE_INITIATOR_TYPEVARCHAR (20) LT
7GDPR_APP_REMOVE_TYPEVARCHAR (10) LT
8GDPR_APP_CONSENT_DATETimestampLT
9GDPR_APP_CONSENT_LOC_LANVARCHAR (100) LT
10GDPR_APP_REMOVAL_REASONVARCHAR (200) LT
11GDPR_APP_REMOVAL_INITIATOR_NAMEVARCHAR (200) LT
12GDPR_APP_REMOVAL_INITIATOR_EMAILVARCHAR (100) LT
13GDPR_APP_REMOVAL_INITIATOR_DEPARTMENTVARCHAR (50) LT
14GDPR_APP_REMOVAL_INITIATOR_USERIDBIGINTLT
15GDPR_APP_JOB_IDFYBIGINTLT
16GDPR_APP_JOB_LOCATION_NAMEVARCHAR (150) LT
17GDPR_APP_JOB_LOCATION_COUNTRYVARCHAR (100) LT
18GDPR_APP_JOB_TITLEVARCHAR (150) LT
19GDPR_APP_JOB_REGION_NAMEVARCHAR (150) LT

Columns Comments
NoColumn NameDescriptionNotes
1APP_IDApplication ID

2APP_EIDApplication encrypted ID

3COMPANY_IDCompany ID

4GDPR_APP_SENT_DATEGDPR application sent date timestamp

5GDPR_APP_REMOVED_DATEGDPR application removed date timestamp

6GDPR_APP_REMOVE_INITIATOR_TYPEGDPR application removal initiator type

7GDPR_APP_REMOVE_TYPEGDPR application removal type

8GDPR_APP_CONSENT_DATEGDPR application consent date

9GDPR_APP_CONSENT_LOC_LANGDPR application consent location language

10GDPR_APP_REMOVAL_REASONGDPR application removal reason

11GDPR_APP_REMOVAL_INITIATOR_NAMEGDPR application removal initiator name

12GDPR_APP_REMOVAL_INITIATOR_EMAILGDPR application removal initiator email

13GDPR_APP_REMOVAL_INITIATOR_DEPARTMENTGDPR application removal initiator department

14GDPR_APP_REMOVAL_INITIATOR_USERIDGDPR application removal initiator user ID

15GDPR_APP_JOB_IDApplication job ID

16GDPR_APP_JOB_LOCATION_NAMEApplication job location name

17GDPR_APP_JOB_LOCATION_COUNTRYApplication job location country

18GDPR_APP_JOB_TITLEApplication job title

19GDPR_APP_JOB_REGION_NAMEApplication job region name

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
GDPR_APPLICATION_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
GDPR_APPLICATION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
GDPR_APPLICATION_JOB_FKJOBYYGDPR_APP_JOB_IDJOB_ID

 

Table NamePUBLIC.GDPR_CONTACT
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns14
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1CONTACT_IDFYBIGINTLT
2CONTACT_EIDVARCHAR (50) LT
3COMPANY_IDFYBIGINT (38) LT
4GDPR_CONTACT_CREATED_DATETimestampLT
5GDPR_CONTACT_REMOVED_DATETimestampLT
6GDPR_CONTACT_REMOVE_INITIATOR_TYPEVARCHAR (20) LT
7GDPR_CONTACT_REMOVE_TYPEVARCHAR (10) LT
8GDPR_CONTACT_CONSENT_DATETimestampLT
9GDPR_CONTACT_CONSENT_LOC_LANVARCHAR (100) LT
10GDPR_CONTACT_REMOVAL_REASONVARCHAR (200) LT
11GDPR_CONTACT_REMOVAL_INITIATOR_NAMEVARCHAR (200) LT
12GDPR_CONTACT_REMOVAL_INITIATOR_EMAILVARCHAR (100) LT
13GDPR_CONTACT_REMOVAL_INITIATOR_DEPARTMENTVARCHAR (50) LT
14GDPR_CONTACT_REMOVAL_INITIATOR_USERIDBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1CONTACT_IDContact ID

2CONTACT_EIDContact encrypted ID

3COMPANY_IDCompany ID

4GDPR_CONTACT_CREATED_DATEGDPR contact created date timestamp

5GDPR_CONTACT_REMOVED_DATEGDPR contact removed date timestamp

6GDPR_CONTACT_REMOVE_INITIATOR_TYPEGDPR contact removal initiator type

7GDPR_CONTACT_REMOVE_TYPEGDPR contact removal type

8GDPR_CONTACT_CONSENT_DATEGDPR contact consent date

9GDPR_CONTACT_CONSENT_LOC_LANGDPR contact consent location language

10GDPR_CONTACT_REMOVAL_REASONGDPR contact removal reason

11GDPR_CONTACT_REMOVAL_INITIATOR_NAMEGDPR contact removal initiator name

13GDPR_CONTACT_REMOVAL_INITIATOR_DEPARTMENTGDPR removal initiator department

14GDPR_CONTACT_REMOVAL_INITIATOR_USERIDGDPR contact removal inititator UserID

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
GDPR_CONTACT_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
GDPR_CONTACT_CONTACT_FKCONTACTYYCONTACT_IDCONTACT_ID

 

Table NamePUBLIC.GDPR_ONBOARDING_ENTITY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns12
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_ENTITY_IDPYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3GDPR_ONB_ENTITY_REMOVED_TYPEBIGINTLT
4GDPR_ONB_ENTITY_REMOVED_DATETimestampLT
5GDPR_ONB_ENTITY_REMOVE_INITIATOR_TYPEVARCHAR (20) LT
6GDPR_ONB_ENTITY_REMOVE_TYPEVARCHAR (10) LT
7GDPR_ONB_ENTITY_CONSENT_DATETimestampLT
8GDPR_ONB_ENTITY_REMOVAL_INITIATOR_NAMEVARCHAR (200) LT
9GDPR_ONB_ENTITY_REMOVAL_INITIATOR_EMAILVARCHAR (100) LT
10GDPR_ONB_ENTITY_REMOVAL_INITIATOR_DEPARTMENTVARCHAR (50) LT
11GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERIDFYBIGINTLT
12GDPR_ONB_ENTITY_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_ENTITY_IDOnboarding entity ID

2COMPANY_IDCompany ID

3GDPR_ONB_ENTITY_REMOVED_TYPEGDPR onboarding entity removal type

4GDPR_ONB_ENTITY_REMOVED_DATEGDPR onboarding entity removed date timestamp

5GDPR_ONB_ENTITY_REMOVE_INITIATOR_TYPEGDPR onboarding entity removal intiator type

6GDPR_ONB_ENTITY_REMOVE_TYPEGDPR onboarding entity removal type

7GDPR_ONB_ENTITY_CONSENT_DATEGDPR onboarding entity consent date

8GDPR_ONB_ENTITY_REMOVAL_INITIATOR_NAMEGDPR onboarding entity removal initiator name

9GDPR_ONB_ENTITY_REMOVAL_INITIATOR_EMAILGDPR onboarding entity removal initiator email

10GDPR_ONB_ENTITY_REMOVAL_INITIATOR_DEPARTMENTGDPR onboarding entity removal initiator department

11GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERIDGDPR onboarding entity removal initiator user ID (COMPANY_USER.company_user_id)

12GDPR_ONB_ENTITY_DELETEDGDPR onboarding entity deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
GDPR_ONBOARDING_ENTITY_PKPKONB_ENTITY_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
GDPR_ONBOARDING_ENTITY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
GDPR_ONBOARDING_ENTITY_COMPANY_USER_FKCOMPANY_USERYYGDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERIDUSER_ID

 

Table NamePUBLIC.INTERVIEW
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns21
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1INTERVIEW_IDPYBIGINTLT
2USER_IDFYBIGINTLT
3APP_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5INTERVIEW_TYPEVARCHAR (100) LT
6INTERVIEW_CREATED_DATETimestampLT
7INTERVIEW_SCHEDULED_DATETimestampLT
8INTERVIEW_SCHEDULED_UTC_DATETimestampLT
9INTERVIEW_SUMMARYVARCHAR (100) LT
10INTERVIEW_COMPLETEDBooleanLT
11INTERVIEW_COMPLETED_BYBIGINTLT
12INTERVIEW_FLAGSBIGINTLT
13INTERVIEW_CANCELLEDBooleanLT
14INTERVIEW_MODIFIEDTimestampLT
15INTERVIEW_COMPLETED_DATETimestampLT
16INTERVIEW_STATUSVARCHAR (25) LT
17INTERVIEW_SUBMITTED_DATETimestampLT
18INTERVIEW_HR_RESTRICTEDBooleanLT
19INTERVIEW_SCHEDULED_BY_USER_IDBIGINTLT
20INTERVIEW_LOCATIONVARCHAR (50) LT
21INTERVIEW_LOCATION_EMAILVARCHAR (50) LT

Columns Comments
NoColumn NameDescriptionNotes
1INTERVIEW_IDInterview ID

2USER_IDUser ID (COMPANY_USER.company_user_id)

3APP_IDApplication ID

4COMPANY_IDCompany ID

5INTERVIEW_TYPEInterview type

6INTERVIEW_CREATED_DATEInterview created date timestamp

7INTERVIEW_SCHEDULED_DATEInterview scheduled date timestamp

8INTERVIEW_SCHEDULED_UTC_DATEInterview scheduled date timestamp (UTC)

9INTERVIEW_SUMMARYInterview summary

10INTERVIEW_COMPLETEDInterview completed (TRUE/FALSE)

11INTERVIEW_COMPLETED_BYInterview completed by UserID (COMPANY_USER.company_user_id)

12INTERVIEW_FLAGSInterview flags

13INTERVIEW_CANCELLEDInterview cancelled (TRUE/FALSE)

14INTERVIEW_MODIFIEDInterview last modified date timestamp

15INTERVIEW_COMPLETED_DATEInterview completed date timestamp

16INTERVIEW_STATUSInterview status

17INTERVIEW_SUBMITTED_DATEInterview submitted date timestamp

18INTERVIEW_HR_RESTRICTEDInterview HR restricted (TRUE/FALSE)

19INTERVIEW_SCHEDULED_BY_USER_IDInterview scheduled by UserID (COMPANY_USER.company_user_id)

20INTERVIEW_LOCATIONInterview location

21INTERVIEW_LOCATION_EMAILInterview location email address

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
INTERVIEW_PKPKINTERVIEW_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
INTERVIEW_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
INTERVIEW_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
INTERVIEW_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.INTERVIEW_EVALUATION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1INTERVIEW_EVALUATION_IDPYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3INTERVIEW_EVALUATION_MODIFIED_DATETimestampLT
4INTERVIEW_EVALUATION_TYPEVARCHAR (50) LT
5INTERVIEW_EVALUATION_TITLEVARCHAR (256) LT
6INTERVIEW_EVALUATION_RATINGVARCHAR (256) LT
7INTERVIEW_EVALUATION_COMMENTSVARCHAR (4096) LT

Columns Comments
NoColumn NameDescriptionNotes
1INTERVIEW_EVALUATION_IDInterview evaluation record ID

2COMPANY_IDCompany ID

3INTERVIEW_EVALUATION_MODIFIED_DATEInterview evaluation last modified date timestamp

4INTERVIEW_EVALUATION_TYPEInterview evaluation type

5INTERVIEW_EVALUATION_TITLEInterview evaluation title

6INTERVIEW_EVALUATION_RATINGInterview evaluation rating

7INTERVIEW_EVALUATION_COMMENTSInterview evaluation comments

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
INTERVIEW_EVALUATION_PKPKINTERVIEW_EVALUATION_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
INTERVIEW_EVALUATION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.JOB
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns71
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1JOB_IDPYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3JOB_TITLEVARCHAR (150) LT
4JOB_SENT_DATETimestampLT
5JOB_CATEGORYVARCHAR (60) LT
6JOB_CLOSE_DATETimestampLT
7JOB_MODIFIED_DATETimestampLT
8JOB_OPEN_DATETimestampLT
9JOB_AVAILABLE_TOBIGINTLT
10JOB_REQUISITION_IDVARCHAR (50) LT
11JOB_CREATED_BYVARCHAR (200) LT
12JOB_BRIEF_DESCRIPTIONVARCHAR (2000) LT
13JOB_OPENINGSBIGINTLT
14JOB_FILLED_ONTimestampLT
15JOB_CAREER_SITEBooleanLT
16JOB_COMPANY_NAMEVARCHAR (50) LT
17JOB_COUNTRYVARCHAR (50) LT
18JOB_PRIVATEBooleanLT
19JOB_NOTIFIEDBooleanLT
20JOB_APPROVE_DATETimestampLT
21JOB_FILLED_ON2TimestampLT
22JOB_NOTIFICATIONVARCHAR (10) LT
23JOB_START_DATETimestampLT
24JOB_END_DATETimestampLT
25JOB_PUT_ON_HOLD_DATETimestampLT
26JOB_HOLD_TIME_SPANBIGINTLT
27JOB_LOCATION_NAMEVARCHAR (150) LT
28JOB_LOCATION_ADDRESSVARCHAR (100) LT
29JOB_LOCATION_POSTAL_CODEVARCHAR (10) LT
30JOB_LOCATION_CITYVARCHAR (100) LT
31JOB_LOCATION_STATEVARCHAR (100) LT
32JOB_LOCATION_COUNTRYVARCHAR (100) LT
33JOB_LOCATION_ADDRESS2VARCHAR (50) LT
34JOB_REGION_NAMEVARCHAR (150) LT
35JOB_SUBSIDIARY_NAMEVARCHAR (100) LT
36JOB_DEPARTMENT_NAMEVARCHAR (150) LT
37JOB_WORKFLOW_TITLEVARCHAR (50) LT
38JOB_JOBTYPE_NAMEVARCHAR (100) LT
39JOB_DAYS_OPENBIGINTLT
40JOB_EVALUATION_NAMEVARCHAR (100) LT
41JOB_PRE_INTERVIEW_FORMVARCHAR (150) LT
42JOB_TIME_TO_FILLBIGINTLT
43JOB_TIME_TO_APPROVEBIGINTLT
44JOB_CREATED_USER_FIRST_NAMEVARCHAR (100) LT
45JOB_CREATED_USER_LAST_NAMEVARCHAR (100) LT
46JOB_CREATED_USER_EMAILVARCHAR (100) LT
47JOB_STATUSVARCHAR (25) LT
48JOB_EEOCATEGORYVARCHAR (100) LT
49JOB_PUBLISH_OPTIONVARCHAR (100) LT
50JOB_DELETEDBooleanLT
51JOB_LINK_URLVARCHAR (256) LT
52JOB_R_FULL_NAME_GROUPVARCHAR (65535) LT
53JOB_HM_FULL_NAME_GROUPVARCHAR (65535) LT
54JOB_CREATED_BY_USERIDBIGINTLT
55JOB_PRIMARY_HM_FIRST_NAMEVARCHAR (100) LT
56JOB_PRIMARY_HM_LAST_NAMEVARCHAR (100) LT
57JOB_PRIMARY_HM_FULL_NAMEVARCHAR (202) LT
58JOB_PRIMARY_HM_EMAILVARCHAR (100) LT
59JOB_AGENCY_LISTVARCHAR (65535) LT
60JOB_BONUSBIGINTLT
61JOB_EIDVARCHAR (50) LT
62JOB_LOCATION_LISTVARCHAR (65535) LT
63JOB_REMAINING_OPENINGSBIGINTLT
64JOB_MOST_RECENT_OPEN_DATETimestampLT
65JOB_PRIMARY_RECRUITER_FIRST_NAMEVARCHAR (100) LT
66JOB_PRIMARY_RECRUITER_LAST_NAMEVARCHAR (100) LT
67JOB_PRIMARY_RECRUITER_FULL_NAMEVARCHAR (202) LT
68JOB_PRIMARY_RECRUITER_EMAILVARCHAR (100) LT
69JOB_APPLY_FORMVARCHAR (256) LT
70JOB_FURTHEST_CANDIDATE_STATUSVARCHAR (150) LT
71JOB_EMAIL_LANGVARCHAR (100) LT

Columns Comments
NoColumn NameDescriptionNotes
1JOB_IDJob ID

2COMPANY_IDCompany ID

3JOB_TITLEJob title

4JOB_SENT_DATEJob sent date timestamp

5JOB_CATEGORYJob category

6JOB_CLOSE_DATEJob closed date timestamp

7JOB_MODIFIED_DATEJob last modified date timestamp

8JOB_OPEN_DATEJob open date timestamp

9JOB_AVAILABLE_TONumber of individuals job is available to

10JOB_REQUISITION_IDRequisition ID

11JOB_CREATED_BYJob created by user full name

12JOB_BRIEF_DESCRIPTIONJob brief description

13JOB_OPENINGSNumber of job openings

14JOB_FILLED_ONJob filled on date timestamp

15JOB_CAREER_SITEJob listed on a career site (TRUE/FALSE)

16JOB_COMPANY_NAMEJob company name

17JOB_COUNTRYJob location country

18JOB_PRIVATEJob marked private (TRUE/FALSE)

19JOB_NOTIFIEDJob notification (TRUE/FALSE)

20JOB_APPROVE_DATEJob approval date timestamp

21JOB_FILLED_ON2Job filled on date timestamp

22JOB_NOTIFICATIONJob notification

23JOB_START_DATEJob start date timestamp

24JOB_END_DATEJob end date timestamp

25JOB_PUT_ON_HOLD_DATEJob put on hold date timestamp

26JOB_HOLD_TIME_SPANJob hold time span (in days)

27JOB_LOCATION_NAMEJob location name

28JOB_LOCATION_ADDRESSJob loction address

29JOB_LOCATION_POSTAL_CODEJob location postal code

30JOB_LOCATION_CITYJob location city

31JOB_LOCATION_STATEJob location state

32JOB_LOCATION_COUNTRYJob location country

33JOB_LOCATION_ADDRESS2Job location address line 2

34JOB_REGION_NAMEJob region name

35JOB_SUBSIDIARY_NAMEJob subsidiary name

36JOB_DEPARTMENT_NAMEJob department name

37JOB_WORKFLOW_TITLEJob workflow title

38JOB_JOBTYPE_NAMEJob type name Full-time Part-time Contractor Intern

39JOB_DAYS_OPENJob days open

40JOB_EVALUATION_NAMEJob evaluation name

41JOB_PRE_INTERVIEW_FORMJob pre-interview form

42JOB_TIME_TO_FILLJob time-to-fill (days)

43JOB_TIME_TO_APPROVEJob time to approve (days)

44JOB_CREATED_USER_FIRST_NAMEJob creator first name

45JOB_CREATED_USER_LAST_NAMEJob creator last name

46JOB_CREATED_USER_EMAILJob creator email address

47JOB_STATUSJob Status

48JOB_EEOCATEGORYJob EEO category

49JOB_PUBLISH_OPTIONJob publish option Limited Access All empoyees (Internal) Everyone (External)

50JOB_DELETEDJob has been deleted (TRUE/FALSE)

51JOB_LINK_URLJob link URL

52JOB_R_FULL_NAME_GROUPJob recruiters (full name)

53JOB_HM_FULL_NAME_GROUPJob hiring managers (full name)

54JOB_CREATED_BY_USERIDJob creator user ID (COMPANY_USER.company_user_id)

55JOB_PRIMARY_HM_FIRST_NAMEPrimary hiring manager first name

56JOB_PRIMARY_HM_LAST_NAMEPrimary hiring manager last name

57JOB_PRIMARY_HM_FULL_NAMEPrimary hiring manager full name

58JOB_PRIMARY_HM_EMAILPrimary hiring manager email address

59JOB_AGENCY_LISTJob agency list

60JOB_BONUSJob referal bonus

61JOB_EIDJob encrypted ID

62JOB_LOCATION_LISTJob location list

63JOB_REMAINING_OPENINGSJob openings remaining

64JOB_MOST_RECENT_OPEN_DATEMost recent open date timestamp

65JOB_PRIMARY_RECRUITER_FIRST_NAMEJob primary recruiter first name

66JOB_PRIMARY_RECRUITER_LAST_NAMEJob primary recruiter last name

67JOB_PRIMARY_RECRUITER_FULL_NAMEJob primary recruiter full name

68JOB_PRIMARY_RECRUITER_EMAILJob primary recruiter email address

69JOB_APPLY_FORMJob apply form

70JOB_FURTHEST_CANDIDATE_STATUSJob furthest candidate status

71JOB_EMAIL_LANGJob associated email language

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
JOB_PKPKJOB_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
JOB_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
AGENCY_JOB_JOB_FKAGENCY_JOBYYJOB_IDJOB_ID
APPLICATION_JOB_FKAPPLICATIONYYJOB_IDJOB_ID
APPLICATION_LOOKUP_JOB_FKAPPLICATION_LOOKUPYYJOB_IDJOB_ID
APPROVER_JOB_FKAPPROVERYYITEM_IDJOB_ID
CANDIDATE_MILESTONE_JOB_FKCANDIDATE_MILESTONEYYJOB_IDJOB_ID
GDPR_APPLICATION_JOB_FKGDPR_APPLICATIONYYGDPR_APP_JOB_IDJOB_ID
JOB_CATEGORY_BENCHMARKS_JOB_FKJOB_CATEGORY_BENCHMARKSYYJOB_IDJOB_ID
JOB_CUSTOM_FIELDS_JOB_FKJOB_CUSTOM_FIELDSYYJOB_IDJOB_ID
JOB_DESC_DETAILS_JOB_FKJOB_DESC_DETAILSYYJOB_IDJOB_ID
JOB_ID_TO_CWSMETRICS_BENCHMARKS_JOB_FKJOB_ID_TO_CWSMETRICS_BENCHMARKSYYJOB_IDJOB_ID
JOB_ID_TO_CWSMETRICS_PAGE_VIEWS_JOB_FKJOB_ID_TO_CWSMETRICS_PAGE_VIEWSYYJOB_IDJOB_ID
JOB_ID_TO_JOB_CAT_JOB_FKJOB_ID_TO_JOB_CATYYJOB_IDJOB_ID
JOB_ID_TO_JOB_CAT_PROD_JOB_FKJOB_ID_TO_JOB_CAT_PRODYYJOB_IDJOB_ID
JOB_ID_TO_JOB_TAXONOMY_JOB_FKJOB_ID_TO_JOB_TAXONOMYYYJOB_IDJOB_ID
JOB_JOBVITE_ACTIVITY_JOB_FKJOB_JOBVITE_ACTIVITYYYJOB_IDJOB_ID
JOB_OPEN_HISTORY_JOB_FKJOB_OPEN_HISTORYYYJOB_IDJOB_ID
JOB_OWNER_APPROVER_JOB_FKJOB_OWNER_APPROVERYYJOB_IDJOB_ID
JOB_OWNER_JOB_FKJOB_OWNERYYJOB_IDJOB_ID
LOOKUP_EID_JOB_JOB_FKLOOKUP_EID_JOBYYJOB_IDJOB_ID
OFCCP_SEARCH_JOB_FKOFCCP_SEARCHYYJOB_IDJOB_ID
ONBOARDING_NEW_HIRE_JOB_FKONBOARDING_NEW_HIREYYJOB_IDJOB_ID
REQUISITION_ACCESS_JOB_FKREQUISITION_ACCESSYYJOB_IDJOB_ID
SOURCE_DATA_JOB_FKSOURCE_DATAYYJOB_IDJOB_ID
UNFILLED_JOB_FUNNEL_SNAPSHOT_JOB_FKUNFILLED_JOB_FUNNEL_SNAPSHOTYYJOB_IDJOB_ID
USER_ACTIVITY_JOB_FKUSER_ACTIVITYYYJOB_IDJOB_ID
USER_ASSIGNED_JOB_ID_TO_JOB_CAT_JOB_FKUSER_ASSIGNED_JOB_ID_TO_JOB_CATYYJOB_IDJOB_ID
VIDEO_FORM_RESPONSE_JOB_FKVIDEO_FORM_RESPONSEYYJOB_IDJOB_ID
VIDEO_FORM_RESPONSE_QUESTION_JOB_FKVIDEO_FORM_RESPONSE_QUESTIONYYJOB_IDJOB_ID

 

Table NamePUBLIC.JOB_JOBVITE_ACTIVITY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns16
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1JOB_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3JOB_JOBVITE_SENDBIGINTLT
4JOB_JOBVITE_BROADCASTBIGINTLT
5JOB_JOBVITE_VIEWBIGINTLT
6JOB_JOBVITE_CLICK_TO_APPLYBIGINTLT
7JOB_JOBVITE_FORWARDBIGINTLT
8JOB_JOBVITE_APPLYBIGINTLT
9JOB_JOBVITE_HIREBIGINTLT
10JOB_JOBVITE_EMAIL_DIRECTBIGINTLT
11JOB_JOBVITE_LINKEDIN_DIRECTBIGINTLT
12JOB_JOBVITE_LINKEDIN_BROADCASTBIGINTLT
13JOB_JOBVITE_FACEBOOK_BROADCASTBIGINTLT
14JOB_JOBVITE_TWITTER_BROADCASTBIGINTLT
15JOB_JOBVITE_JOBLINK_BROADCASTBIGINTLT
16JOB_JOBVITE_ACTIVITY_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1JOB_IDJob ID

2COMPANY_IDCompany ID

3JOB_JOBVITE_SENDNumber of Jobvites sent

4JOB_JOBVITE_BROADCASTNumber of Jobvites broadcast

5JOB_JOBVITE_VIEWNumber of Jobvites viewed

6JOB_JOBVITE_CLICK_TO_APPLYNumber of Jobvites apply starts

7JOB_JOBVITE_FORWARDNumber of Jobvites forwarded

8JOB_JOBVITE_APPLYNumber of Jobvites applies complete

9JOB_JOBVITE_HIRENumber of Jobvites resulting in hires

10JOB_JOBVITE_EMAIL_DIRECTNumber of Jobvites emailed directly

11JOB_JOBVITE_LINKEDIN_DIRECTNumber of Jobvites shared directly on LinkedIn

12JOB_JOBVITE_LINKEDIN_BROADCASTNumber of Jobvites brodcast to LinkedIn

13JOB_JOBVITE_FACEBOOK_BROADCASTNumber of Jobvites brodcast to Facebook

14JOB_JOBVITE_TWITTER_BROADCASTNumber of Jobvites brodcast to Twitter

15JOB_JOBVITE_JOBLINK_BROADCASTNumber of Jobvites brodcast to Joblink

16JOB_JOBVITE_ACTIVITY_DATEJobvite activity record date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
JOB_JOBVITE_ACTIVITY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
JOB_JOBVITE_ACTIVITY_JOB_FKJOBYYJOB_IDJOB_ID

 

Table NamePUBLIC.JOB_OPEN_HISTORY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1JOB_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3JOB_OPEN_FROM_DATETimestampLT
4JOB_OPEN_TO_DATETimestampLT
5JOB_OPEN_MODIFIED_DATETimestampLT
6JOB_OPEN_PRIMARY_KEYPYBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1JOB_IDJob ID

2COMPANY_IDCompany ID

3JOB_OPEN_FROM_DATEJob open from (start) date timestamp

4JOB_OPEN_TO_DATEJob open to (end) date timestamp

5JOB_OPEN_MODIFIED_DATEJob open last modified date timestamp

6JOB_OPEN_PRIMARY_KEYJob open primary key

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
JOB_OPEN_HISTORY_PKPKJOB_OPEN_PRIMARY_KEYASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
JOB_OPEN_HISTORY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
JOB_OPEN_HISTORY_JOB_FKJOBYYJOB_IDJOB_ID

 

Table NamePUBLIC.JOB_OWNER
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns6
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1JOB_OWNER_IDPYBIGINTLT
2JOB_IDFYBIGINTLT
3USER_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5IS_RECRUITERBooleanLT
6JOB_OWNER_MODIFIEDTimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1JOB_OWNER_IDJob owner ID

2JOB_IDJob ID

3USER_IDUser ID (COMPANY_USER.company_user_id)

4COMPANY_IDCompany ID

5IS_RECRUITEROwner is recruiter (TRUE/FALSE)

6JOB_OWNER_MODIFIEDJob owner last modified date timestamp

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
JOB_OWNER_PKPKJOB_OWNER_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
JOB_OWNER_JOB_FKJOBYYJOB_IDJOB_ID
JOB_OWNER_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
JOB_OWNER_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.OFCCP_SEARCH
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1SEARCH_IDPYBIGINTLT
2JOB_IDFYBIGINTLT
3USER_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5SEARCH_DATETimestampLT
6SEARCH_KEYWORDSVARCHAR (500) LT
7SEARCH_ALLWORDSVARCHAR (500) LT
8SEARCH_EXACT_PHRASEVARCHAR (500) LT
9SEARCH_ANYWORDVARCHAR (500) LT
10SEARCH_NOWORDVARCHAR (500) LT

Columns Comments
NoColumn NameDescriptionNotes
1SEARCH_IDOFCCP Search ID

2JOB_IDJob ID

3USER_IDUser ID (COMPANY_USER.company_user_id)

4COMPANY_IDCompany ID

5SEARCH_DATESearch date timestamp

6SEARCH_KEYWORDSSearch keywords

7SEARCH_ALLWORDSSearch all words

8SEARCH_EXACT_PHRASESearch exact phrase

9SEARCH_ANYWORDSearch anyword

10SEARCH_NOWORDSearch no words

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
OFCCP_SEARCH_PKPKSEARCH_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
OFCCP_SEARCH_JOB_FKJOBYYJOB_IDJOB_ID
OFCCP_SEARCH_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
OFCCP_SEARCH_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.ONBOARDING_NEW_HIRE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns35
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_NEW_HIRE_IDPYVARCHAR (30) LT
2APP_IDFYBIGINTLT
3JOB_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5ONB_NEW_HIRE_ADDRESSVARCHAR (100) LT
6ONB_NEW_HIRE_CELL_PHONEVARCHAR (25) LT
7ONB_NEW_HIRE_CELL_PHONE_CODEVARCHAR (4) LT
8ONB_NEW_HIRE_CELL_PHONE_EXTENSIONVARCHAR (10) LT
9ONB_NEW_HIRE_CITYVARCHAR (100) LT
10ONB_NEW_HIRE_COUNTRYVARCHAR (100) LT
11ONB_NEW_HIRE_CREATED_BY_USER_IDFYBIGINTLT
12ONB_NEW_HIRE_CREATED_DATETimestampLT
13ONB_NEW_HIRE_MODIFIED_DATETimestampLT
14ONB_NEW_HIRE_EMAILVARCHAR (100) LT
15ONB_NEW_HIRE_FIRST_NAMEVARCHAR (100) LT
16ONB_NEW_HIRE_LAST_NAMEVARCHAR (100) LT
17ONB_NEW_HIRE_FULL_NAMEVARCHAR (201) LT
18ONB_NEW_HIRE_HIRING_MANAGER_USER_IDFYBIGINTLT
19ONB_NEW_HIRE_HOME_PHONEVARCHAR (25) LT
20ONB_NEW_HIRE_HOME_PHONE_COUNTRY_CODEVARCHAR (4) LT
21ONB_NEW_HIRE_HOME_PHONE_EXTENSIONVARCHAR (10) LT
22ONB_NEW_HIRE_HIRE_DATETimestampLT
23ONB_NEW_HIRE_START_DATETimestampLT
24ONB_NEW_HIRE_STATEVARCHAR (100) LT
25ONB_NEW_HIRE_STATE_OTHERVARCHAR (50) LT
26ONB_NEW_HIRE_MODIFIED_BY_USER_IDFYBIGINTLT
27ONB_NEW_HIRE_WORKFLOW_STATUSVARCHAR (100) LT
28ONB_NEW_HIRE_ZIPVARCHAR (50) LT
29ONB_NEW_HIRE_JOB_TITLEVARCHAR (100) LT
30ONB_NEW_HIRE_CANDIDATE_IDBIGINTLT
31ONB_NEW_HIRE_JOB_SEEKER_IDBIGINTLT
32ONB_NEW_HIRE_EMPLOYEE_USER_IDBIGINTLT
33ONB_NEW_HIRE_ENTITY_CODEVARCHAR (100) LT
34ONB_NEW_HIRE_DELETEDBooleanLT
35ONB_NEW_HIRE_GDPR_FORGOTTENBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_NEW_HIRE_IDOnboarding new hire ID

2APP_IDApplication ID

3JOB_IDJob ID

4COMPANY_IDCompany ID

5ONB_NEW_HIRE_ADDRESSNew hire address

6ONB_NEW_HIRE_CELL_PHONENew hire cell phone

7ONB_NEW_HIRE_CELL_PHONE_CODENew hire cell phone country code

8ONB_NEW_HIRE_CELL_PHONE_EXTENSIONNew hire cell phone extension

9ONB_NEW_HIRE_CITYNew hire address city

10ONB_NEW_HIRE_COUNTRYNew hire address country

11ONB_NEW_HIRE_CREATED_BY_USER_IDNew hire created by user (User ID)

12ONB_NEW_HIRE_CREATED_DATENew hire created date timestamp

13ONB_NEW_HIRE_MODIFIED_DATENew hire onboarding record last modified date timestamp

14ONB_NEW_HIRE_EMAILNew hire email address

15ONB_NEW_HIRE_FIRST_NAMENew hire first name

16ONB_NEW_HIRE_LAST_NAMENew hire last name

17ONB_NEW_HIRE_FULL_NAMENew hire full name

18ONB_NEW_HIRE_HIRING_MANAGER_USER_IDNew hire Hiring Manager user ID

19ONB_NEW_HIRE_HOME_PHONENew hire home phone

20ONB_NEW_HIRE_HOME_PHONE_COUNTRY_CODENew hire home phone country code

21ONB_NEW_HIRE_HOME_PHONE_EXTENSIONNew hire home phone extension

22ONB_NEW_HIRE_HIRE_DATENew hire hire date

23ONB_NEW_HIRE_START_DATENew hire start date

24ONB_NEW_HIRE_STATENew hire address state

25ONB_NEW_HIRE_STATE_OTHERNew hire address state other

26ONB_NEW_HIRE_MODIFIED_BY_USER_IDNew hire onboarding record last modified by User ID (COMPANY_USER.company_user_id)

27ONB_NEW_HIRE_WORKFLOW_STATUSNew hire workflow status

28ONB_NEW_HIRE_ZIPNew hire address zip code

29ONB_NEW_HIRE_JOB_TITLENew hire job title

30ONB_NEW_HIRE_CANDIDATE_IDNew hire candidate ID

31ONB_NEW_HIRE_JOB_SEEKER_IDNew hire job seeker ID

32ONB_NEW_HIRE_EMPLOYEE_USER_IDNew hire employee user ID (COMPANY_USER.company_user_id)

33ONB_NEW_HIRE_ENTITY_CODENew hire entity code

34ONB_NEW_HIRE_DELETEDNew hire deleted (TRUE/FALSE)

35ONB_NEW_HIRE_GDPR_FORGOTTENNew hire record forgotten/anonymized for GDPR purposes (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ONBOARDING_NEW_HIRE_PKPKONB_NEW_HIRE_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_NEW_HIRE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ONBOARDING_NEW_HIRE_JOB_FKJOBYYJOB_IDJOB_ID
ONBOARDING_NEW_HIRE_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv2COMPANY_USERYYONB_NEW_HIRE_MODIFIED_BY_USER_IDUSER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKCOMPANY_USERYYONB_NEW_HIRE_CREATED_BY_USER_IDUSER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv1COMPANY_USERYYONB_NEW_HIRE_HIRING_MANAGER_USER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_PROCESS_ONBOARDING_NEW_HIRE_FKONBOARDING_PROCESSYYONB_NEW_HIRE_IDONB_NEW_HIRE_ID

 

Table NamePUBLIC.ONBOARDING_PORTAL
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns16
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_PORTAL_IDYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3ONB_PORTAL_DESCRIPTIONVARCHAR (1000) LT
4ONB_PORTAL_EXTERNAL_NAMEVARCHAR (256) LT
5ONB_PORTAL_INTERNAL_NAMEVARCHAR (256) LT
6ONB_PORTAL_CREATED_DATETimestampLT
7ONB_PORTAL_MODIFIED_DATETimestampLT
8ONB_PORTAL_CREATED_BY_USER_IDBIGINTLT
9ONB_PORTAL_MODIFIED_BY_USER_IDBIGINTLT
10ONB_PORTAL_LIFE_CYCLE_STATUSVARCHAR (50) LT
11ONB_PORTAL_USED_IN_ONBOARDINGSBIGINTLT
12ONB_PORTAL_USED_IN_PROCESSBIGINTLT
13ONB_PORTAL_TRANSLATION_COMPLETEBooleanLT
14ONB_PORTAL_WORKFLOW_STATUSVARCHAR (100) LT
15ONB_PORTAL_ENTITY_CODEVARCHAR (100) LT
16ONB_PORTAL_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_PORTAL_IDOnboarding portal ID

2COMPANY_IDCompany ID

3ONB_PORTAL_DESCRIPTIONOnboarding portal description

4ONB_PORTAL_EXTERNAL_NAMEOnboarding portal external name

5ONB_PORTAL_INTERNAL_NAMEOnboarding portal internal name

6ONB_PORTAL_CREATED_DATEOnboarding portal created date timestamp

7ONB_PORTAL_MODIFIED_DATEOnboarding portal last modified date timestamp

8ONB_PORTAL_CREATED_BY_USER_IDOnboarding portal creator User ID (COMPANY_USER.company_user_id)

9ONB_PORTAL_MODIFIED_BY_USER_IDOnboarding portal last modified by User ID (COMPANY_USER.company_user_id)

10ONB_PORTAL_LIFE_CYCLE_STATUSOnboarding portal life cycle status

11ONB_PORTAL_USED_IN_ONBOARDINGSOnboarding portal used in onboardings

12ONB_PORTAL_USED_IN_PROCESSOnboarding portal used in process

13ONB_PORTAL_TRANSLATION_COMPLETEOnboarding portal translation completed

14ONB_PORTAL_WORKFLOW_STATUSOnboarding portal workflow status

15ONB_PORTAL_ENTITY_CODEOnboarding portal entity code

16ONB_PORTAL_DELETEDOnboarding portal deleted (TRUE/FALSE)

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_PORTAL_COMPANY_FKv1COMPANYYYCOMPANY_IDCOMPANY_ID
ONBOARDING_PORTAL_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

 

Table NamePUBLIC.ONBOARDING_PROCESS
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns31
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_PROCESS_IDPYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3ONB_NEW_HIRE_IDFYVARCHAR (30) LT
4ONB_PROCESS_HIRE_DATETimestampLT
5ONB_HIRING_MANAGER_USER_IDFYBIGINTLT
6ONB_PROCESS_PORTAL_IDVARCHAR (30) LT
7ONB_PROCESS_START_DATETimestampLT
8ONB_PROCESS_ACTUAL_KICKOFF_DATETimestampLT
9ONB_PROCESS_COMPLETES_ONTimestampLT
10ONB_PROCESS_COMPLETION_DATETimestampLT
11ONB_PROCESS_CREATED_BY_USER_IDFYBIGINTLT
12ONB_PROCESS_CREATED_DATETimestampLT
13ONB_PROCESS_MODIFIED_DATETimestampLT
14ONB_PROCESS_DELAYED_KICK_OFF_DATETimestampLT
15ONB_PROCESS_LIFE_CYCLE_STATUSVARCHAR (50) LT
16ONB_PROCESS_NUMBER_OF_COMPLETED_TASKSBIGINTLT
17ONB_PROCESS_NUMBER_OF_ISSUESBIGINTLT
18ONB_PROCESS_NUMBER_OF_OVERDUESBIGINTLT
19ONB_PROCESS_NUMBER_OF_SOON_OVERDUESBIGINTLT
20ONB_PROCESS_NUMBER_OF_TASKSBIGINTLT
21ONB_PROCESS_ORCHESTRATOR_USER_IDBIGINTLT
22ONB_PROCESS_ORCHESTRATOR_LOCKEDBooleanLT
23ONB_PROCESS_ORCHESTRATOR_TYPEVARCHAR (100) LT
24ONB_PROCESS_PERCENTAGE_OF_COMPLETEDBIGINTLT
25ONB_PROCESS_TEMPLATE_IDFYVARCHAR (30) LT
26ONB_PROCESS_TEMPLATE_NAMEVARCHAR (256) LT
27ONB_PROCESS_TRANSLATIONS_COMPLETEBooleanLT
28ONB_PROCESS_MODIFIED_BY_USER_IDFYBIGINTLT
29ONB_PROCESS_WORKFLOW_STATUSVARCHAR (100) LT
30ONB_PROCESS_ENTITY_CODEVARCHAR (100) LT
31ONB_PROCESS_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_PROCESS_IDOnboarding process ID

2COMPANY_IDCompany ID

3ONB_NEW_HIRE_IDOnboarding new hire ID

4ONB_PROCESS_HIRE_DATEOnboarding process hire date

5ONB_HIRING_MANAGER_USER_IDOnboarding hiring manager User ID (COMPANY_USER.company_user_id)

6ONB_PROCESS_PORTAL_IDOnboarding process portal ID

7ONB_PROCESS_START_DATEOnboarding process start date

8ONB_PROCESS_ACTUAL_KICKOFF_DATEOnboarding process kickoff date

9ONB_PROCESS_COMPLETES_ONOnboarding process completion target date

10ONB_PROCESS_COMPLETION_DATEOnboarding process completion date

11ONB_PROCESS_CREATED_BY_USER_IDOnboarding process creator User ID (COMPANY_USER.company_user_id)

12ONB_PROCESS_CREATED_DATEOnboarding process record created date timestamp

13ONB_PROCESS_MODIFIED_DATEOnboarding process last modified date timestamp

14ONB_PROCESS_DELAYED_KICK_OFF_DATEOnboarding process delayed kick off date

15ONB_PROCESS_LIFE_CYCLE_STATUSOnboarding process life cycle status

16ONB_PROCESS_NUMBER_OF_COMPLETED_TASKSNumber of completed onboarding tasks

17ONB_PROCESS_NUMBER_OF_ISSUESNumber of onboarding issues

18ONB_PROCESS_NUMBER_OF_OVERDUESNumber of overdue onboarding tasks

19ONB_PROCESS_NUMBER_OF_SOON_OVERDUESNumber of onboarding tasks that will be overdue soon

20ONB_PROCESS_NUMBER_OF_TASKSNumber of onboarding tasks

21ONB_PROCESS_ORCHESTRATOR_USER_IDOnboarding process orchestrator User ID (COMPANY_USER.company_user_id)

22ONB_PROCESS_ORCHESTRATOR_LOCKEDOnboarding process orchestrator locked (TRUE/FALSE)

23ONB_PROCESS_ORCHESTRATOR_TYPEOnboarding process orchestrator type

24ONB_PROCESS_PERCENTAGE_OF_COMPLETEDOnboarding process percent completed

25ONB_PROCESS_TEMPLATE_IDOnboarding process template ID

26ONB_PROCESS_TEMPLATE_NAMEOnboarding process template name

27ONB_PROCESS_TRANSLATIONS_COMPLETEOnboarding process translation complete

28ONB_PROCESS_MODIFIED_BY_USER_IDOnboarding process record last modified by User ID (COMPANY_USER.company_user_id)

29ONB_PROCESS_WORKFLOW_STATUSOnboarding process current workflow status

30ONB_PROCESS_ENTITY_CODEOnboarding process entity code

31ONB_PROCESS_DELETEDOnboarding process deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ONBOARDING_PROCESS_PKPKONB_PROCESS_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_PROCESS_ONBOARDING_NEW_HIRE_FKONBOARDING_NEW_HIREYYONB_NEW_HIRE_IDONB_NEW_HIRE_ID
ONBOARDING_PROCESS_ONBOARDING_PROCESS_TEMPLATE_FKONBOARDING_PROCESS_TEMPLATEYYONB_PROCESS_TEMPLATE_IDONB_PROCESS_TEMPLATE_ID
ONBOARDING_PROCESS_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv1COMPANY_USERYYONB_PROCESS_CREATED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv2COMPANY_USERYYONB_HIRING_MANAGER_USER_IDUSER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKCOMPANY_USERYYONB_PROCESS_MODIFIED_BY_USER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_TASK_ONBOARDING_PROCESS_FKONBOARDING_TASKYYONB_TASK_PROCESS_INSTANCE_IDONB_PROCESS_ID

 

Table NamePUBLIC.ONBOARDING_PROCESS_TEMPLATE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns19
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_PROCESS_TEMPLATE_IDPYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3ONB_PROCESS_TEMPLATE_NAMEVARCHAR (100) LT
4ONB_PROCESS_TEMPLATE_DESCRIPTIONVARCHAR (1000) LT
5ONB_PROCESS_TEMPLATE_CODEVARCHAR (100) LT
6ONB_PROCESS_TEMPLATE_NUMBER_OF_TASKSBIGINTLT
7ONB_PROCESS_TEMPLATE_ORCHESTRATOR_IDBIGINTLT
8ONB_PROCESS_TEMPLATE_HAS_CORPORATE_ACCOUNTBooleanLT
9ONB_PROCESS_TEMPLATE_PORTAL_IDVARCHAR (30) LT
10ONB_PROCESS_TEMPLATE_ORCHESTRATOR_TYPEVARCHAR (100) LT
11ONB_PROCESS_TEMPLATE_CREATED_DATETimestampLT
12ONB_PROCESS_TEMPLATE_MODIFIED_DATETimestampLT
13ONB_PROCESS_TEMPLATE_CREATED_BY_USER_IDFYBIGINTLT
14ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_IDFYBIGINTLT
15ONB_PROCESS_TEMPLATE_LIFE_CYCLE_STATUSVARCHAR (50) LT
16ONB_PROCESS_TEMPLATE_TRANSLATION_COMPLETEBooleanLT
17ONB_PROCESS_TEMPLATE_WORKFLOW_STATUSVARCHAR (100) LT
18ONB_PROCESS_TEMPLATE_ENTITY_CODEVARCHAR (100) LT
19ONB_PROCESS_TEMPLATE_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_PROCESS_TEMPLATE_IDOnboarding process template ID

2COMPANY_IDCompany ID

3ONB_PROCESS_TEMPLATE_NAMETemplate name

4ONB_PROCESS_TEMPLATE_DESCRIPTIONTemplate description

5ONB_PROCESS_TEMPLATE_CODETemplate code

6ONB_PROCESS_TEMPLATE_NUMBER_OF_TASKSTemplate number of tasks

7ONB_PROCESS_TEMPLATE_ORCHESTRATOR_IDTemplate orchestrator ID

8ONB_PROCESS_TEMPLATE_HAS_CORPORATE_ACCOUNTTemplate has corporate account (YES/NO)

9ONB_PROCESS_TEMPLATE_PORTAL_IDTemplate portal ID

10ONB_PROCESS_TEMPLATE_ORCHESTRATOR_TYPETemplate orchestrator type

11ONB_PROCESS_TEMPLATE_CREATED_DATETemplate created date timestamp

12ONB_PROCESS_TEMPLATE_MODIFIED_DATETemplate last modified date timestamp

13ONB_PROCESS_TEMPLATE_CREATED_BY_USER_IDTemplate created by User ID (COMPANY_USER.company_user_id)

14ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_IDTemplate last modified by User ID (COMPANY_USER.company_user_id)

15ONB_PROCESS_TEMPLATE_LIFE_CYCLE_STATUSTemplate life cycle status

16ONB_PROCESS_TEMPLATE_TRANSLATION_COMPLETETemplate translation completed (TRUE/FALSE)

17ONB_PROCESS_TEMPLATE_WORKFLOW_STATUSTemplate workflow status

18ONB_PROCESS_TEMPLATE_ENTITY_CODETemplate entity code

19ONB_PROCESS_TEMPLATE_DELETEDTemplate deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ONBOARDING_PROCESS_TEMPLATE_PKPKONB_PROCESS_TEMPLATE_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_PROCESS_TEMPLATE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKCOMPANY_USERYYONB_PROCESS_TEMPLATE_CREATED_BY_USER_IDUSER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKv1COMPANY_USERYYONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_PROCESS_ONBOARDING_PROCESS_TEMPLATE_FKONBOARDING_PROCESSYYONB_PROCESS_TEMPLATE_IDONB_PROCESS_TEMPLATE_ID

 

Table NamePUBLIC.ONBOARDING_TASK
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns37
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_TASK_IDPYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3ONB_TASK_ACTIVATED_ASSIGNEE_TYPEVARCHAR (100) LT
4ONB_TASK_ACTIVATED_ASSIGNEE_USER_IDBIGINTLT
5ONB_TASK_ASSIGNEE_TYPEVARCHAR (100) LT
6ONB_TASK_ASSIGNEE_USER_IDFYBIGINTLT
7ONB_TASK_ISSUE_RAISEDBooleanLT
8ONB_TASK_OVERDUE_STATUSVARCHAR (100) LT
9ONB_TASK_ACTUAL_ACTIVATION_DATETimestampLT
10ONB_TASK_COMPLETEBooleanLT
11ONB_TASK_COMPLETION_DATETimestampLT
12ONB_TASK_CREATED_BY_USER_IDFYBIGINTLT
13ONB_TASK_CREATED_DATETimestampLT
14ONB_TASK_MODIFIED_DATETimestampLT
15ONB_TASK_DELAYED_ACTIVATION_DATETimestampLT
16ONB_TASK_DELAYED_ACTIVATION_REFERENCEVARCHAR (100) LT
17ONB_TASK_DESCRIPTIONVARCHAR (1000) LT
18ONB_TASK_DUE_DATETimestampLT
19ONB_TASK_DUE_DATE_OFFSETBIGINTLT
20ONB_TASK_EXPECTED_ACTIVATION_DATETimestampLT
21ONB_TASK_LAST_TIME_SEENTimestampLT
22ONB_TASK_LIFE_CYCLE_STATUSVARCHAR (100) LT
23ONB_TASK_LOCKEDBooleanLT
24ONB_TASK_LOCKED_DUE_DATEBooleanLT
25ONB_TASK_PROCESS_INSTANCE_IDFYVARCHAR (30) LT
26ONB_TASK_REFERENCE_DUE_DATEVARCHAR (100) LT
27ONB_TASK_SOURCE_TYPEVARCHAR (100) LT
28ONB_TASK_TEMPLATE_IDFYVARCHAR (30) LT
29ONB_TASK_TEMPLATE_INTERNAL_NAMEVARCHAR (256) LT
30ONB_TASK_TEMPLATE_EXTERNAL_NAMEVARCHAR (256) LT
31ONB_TASK_MODIFIED_BY_USER_IDFYBIGINTLT
32ONB_TASK_WORKFLOW_STATUSVARCHAR (100) LT
33ONB_TASK_ASSIGNED_DAYSBIGINTLT
34ONB_TASK_BLOCKED_DAYSBIGINTLT
35ONB_TASK_ENTITY_CODEVARCHAR (100) LT
36ONB_TASK_DELETEDBooleanLT
37ONB_TASK_OVERDUE_DAYSBIGINTLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_TASK_IDOnboarding Task ID

2COMPANY_IDCompany ID

3ONB_TASK_ACTIVATED_ASSIGNEE_TYPETask activated assignee type

4ONB_TASK_ACTIVATED_ASSIGNEE_USER_IDTask activated assignee User ID (COMPANY_USER.company_user_id)

5ONB_TASK_ASSIGNEE_TYPETask assignee type

6ONB_TASK_ASSIGNEE_USER_IDTask assignee User ID (COMPANY_USER.company_user_id)

7ONB_TASK_ISSUE_RAISEDTask has an issue raised (TRUE/FALSE)

8ONB_TASK_OVERDUE_STATUSTask overdue status

9ONB_TASK_ACTUAL_ACTIVATION_DATETask actual activation date timestamp

10ONB_TASK_COMPLETETask completed (TRUE/FALSE)

11ONB_TASK_COMPLETION_DATETask completion date timestamp

12ONB_TASK_CREATED_BY_USER_IDTask creator User ID (COMPANY_USER.company_user_id)

13ONB_TASK_CREATED_DATETask created date timestamp

14ONB_TASK_MODIFIED_DATETask last modified date timestamp

15ONB_TASK_DELAYED_ACTIVATION_DATETask delayed activation date timestamp

16ONB_TASK_DELAYED_ACTIVATION_REFERENCETask delayed activation reference

17ONB_TASK_DESCRIPTIONTask description

18ONB_TASK_DUE_DATETask due date

19ONB_TASK_DUE_DATE_OFFSETTask due date offset

20ONB_TASK_EXPECTED_ACTIVATION_DATETask expected activation date

21ONB_TASK_LAST_TIME_SEENTask last time seen date timestamp

22ONB_TASK_LIFE_CYCLE_STATUSTask life cycle status

23ONB_TASK_LOCKEDTask locked (TRUE/FALSE)

24ONB_TASK_LOCKED_DUE_DATETask locked due date (TRUE/FALSE)

25ONB_TASK_PROCESS_INSTANCE_IDTask process instance ID

26ONB_TASK_REFERENCE_DUE_DATETask reference due date

27ONB_TASK_SOURCE_TYPETask source type

28ONB_TASK_TEMPLATE_IDTask template ID

29ONB_TASK_TEMPLATE_INTERNAL_NAMETask template internal name

30ONB_TASK_TEMPLATE_EXTERNAL_NAMETask template external name

31ONB_TASK_MODIFIED_BY_USER_IDTask last modified by User ID (COMPANY_USER.company_user_id)

32ONB_TASK_WORKFLOW_STATUSTask workflow status

33ONB_TASK_ASSIGNED_DAYSTask assigned days

34ONB_TASK_BLOCKED_DAYSTask blocked days

35ONB_TASK_ENTITY_CODETask entity code

36ONB_TASK_DELETEDTask deleted (TRUE/FALSE)

37ONB_TASK_OVERDUE_DAYSTask overdue days

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ONBOARDING_TASK_PKPKONB_TASK_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_TASK_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
ONBOARDING_TASK_ONBOARDING_PROCESS_FKONBOARDING_PROCESSYYONB_TASK_PROCESS_INSTANCE_IDONB_PROCESS_ID
ONBOARDING_TASK_ONBOARDING_TASK_TEMPLATE_FKONBOARDING_TASK_TEMPLATEYYONB_TASK_TEMPLATE_IDONB_TASK_TEMPLATE_ID
ONBOARDING_TASK_COMPANY_USER_FKv2COMPANY_USERYYONB_TASK_MODIFIED_BY_USER_IDUSER_ID
ONBOARDING_TASK_COMPANY_USER_FKv1COMPANY_USERYYONB_TASK_CREATED_BY_USER_IDUSER_ID
ONBOARDING_TASK_COMPANY_USER_FKCOMPANY_USERYYONB_TASK_ASSIGNEE_USER_IDUSER_ID

 

Table NamePUBLIC.ONBOARDING_TASK_TEMPLATE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns21
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1ONB_TASK_TEMPLATE_IDPYVARCHAR (30) LT
2COMPANY_IDFYBIGINT (38) LT
3ONB_TASK_TEMPLATE_DESCRIPTIONVARCHAR (1000) LT
4ONB_TASK_TEMPLATE_EXTERNAL_NAMEVARCHAR (256) LT
5ONB_TASK_TEMPLATE_INTERNAL_NAMEVARCHAR (256) LT
6ONB_TASK_TEMPLATE_ASSIGNEE_LOCKEDBooleanLT
7ONB_TASK_TEMPLATE_ASSIGNEE_TYPEVARCHAR (100) LT
8ONB_TASK_TEMPLATE_ASSIGNEE_FIRST_NAMEVARCHAR (100) LT
9ONB_TASK_TEMPLATE_ASSIGNEE_LAST_NAMEVARCHAR (100) LT
10ONB_TASK_TEMPLATE_CODEVARCHAR (100) LT
11ONB_TASK_TEMPLATE_CREATED_DATETimestampLT
12ONB_TASK_TEMPLATE_MODIFIED_DATETimestampLT
13ONB_TASK_TEMPLATE_CREATED_BY_USER_IDBIGINTLT
14ONB_TASK_TEMPLATE_MODIFIED_BY_USER_IDBIGINTLT
15ONB_TASK_TEMPLATE_LIFE_CYCLE_STATUSVARCHAR (50) LT
16ONB_TASK_TEMPLATE_LOCKED_DUE_DATEBooleanLT
17ONB_TASK_TEMPLATE_PROCESS_TYPEVARCHAR (100) LT
18ONB_TASK_TEMPLATE_TRANSLATION_COMPLETEBooleanLT
19ONB_TASK_TEMPLATE_WORKFLOW_STATUSVARCHAR (100) LT
20ONB_TASK_TEMPLATE_ENTITY_CODEVARCHAR (100) LT
21ONB_TASK_TEMPLATE_DELETEDBooleanLT

Columns Comments
NoColumn NameDescriptionNotes
1ONB_TASK_TEMPLATE_IDTask Template ID

2COMPANY_IDCompany ID

3ONB_TASK_TEMPLATE_DESCRIPTIONTask template description

4ONB_TASK_TEMPLATE_EXTERNAL_NAMETask template external name

5ONB_TASK_TEMPLATE_INTERNAL_NAMETask template internal name

6ONB_TASK_TEMPLATE_ASSIGNEE_LOCKEDTask template assigned locked (TRUE/FALSE)

7ONB_TASK_TEMPLATE_ASSIGNEE_TYPETask template assignee type

8ONB_TASK_TEMPLATE_ASSIGNEE_FIRST_NAMETask template assignee first name

9ONB_TASK_TEMPLATE_ASSIGNEE_LAST_NAMETask template assignee last name

10ONB_TASK_TEMPLATE_CODETask template code

11ONB_TASK_TEMPLATE_CREATED_DATETask template created date timestamp

12ONB_TASK_TEMPLATE_MODIFIED_DATETask template last modified date timestamp

13ONB_TASK_TEMPLATE_CREATED_BY_USER_IDTask templated creator User ID (COMPANY_USER.company_user_id)

14ONB_TASK_TEMPLATE_MODIFIED_BY_USER_IDTask template last modified by User ID (COMPANY_USER.company_user_id)

15ONB_TASK_TEMPLATE_LIFE_CYCLE_STATUSTask template life cycle status

16ONB_TASK_TEMPLATE_LOCKED_DUE_DATETack template locked due date (TRUE/FALSE)

17ONB_TASK_TEMPLATE_PROCESS_TYPETask template process type

18ONB_TASK_TEMPLATE_TRANSLATION_COMPLETETask template translation complete (TRUE/FALSE)

19ONB_TASK_TEMPLATE_WORKFLOW_STATUSTask template workflow status

20ONB_TASK_TEMPLATE_ENTITY_CODETask template entity code

21ONB_TASK_TEMPLATE_DELETEDTask template deleted (TRUE/FALSE)

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
ONBOARDING_TASK_TEMPLATE_PKPKONB_TASK_TEMPLATE_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_TASK_TEMPLATE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
ONBOARDING_TASK_ONBOARDING_TASK_TEMPLATE_FKONBOARDING_TASKYYONB_TASK_TEMPLATE_IDONB_TASK_TEMPLATE_ID

 

Table NamePUBLIC.SCREENING_FORM
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns10
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1SCREENING_FORM_IDPYBIGINTLT
2APP_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4SCREENING_FORM_NAMEVARCHAR (128) LT
5SCREENING_FORM_STATUSVARCHAR (128) LT
6SCREENING_FORM_COMPLETED_DATETimestampLT
7SCREENING_FORM_SENT_DATETimestampLT
8SCREENING_FORM_TEMPLATE_IDBIGINTLT
9SCREENING_FORM_TOTAL_SCOREDECIMAL (5,2)LT
10SCREENING_FORM_MODIFIED_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1SCREENING_FORM_IDScreening form ID

2APP_IDApplication ID

3COMPANY_IDCompany ID

4SCREENING_FORM_NAMEScreening form name

5SCREENING_FORM_STATUSScreening form status

6SCREENING_FORM_COMPLETED_DATEScreening form completed date timestamp

7SCREENING_FORM_SENT_DATEScreening form sent date timestamp

8SCREENING_FORM_TEMPLATE_IDScreening form template ID

9SCREENING_FORM_TOTAL_SCOREScreening form total score

10SCREENING_FORM_MODIFIED_DATEScreening form last modified date timestamp

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
SCREENING_FORM_PKPKSCREENING_FORM_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
SCREENING_FORM_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
SCREENING_FORM_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
SCREENING_FORM_QUESTION_SCREENING_FORM_FKSCREENING_FORM_QUESTIONYYSCREENING_FORM_IDSCREENING_FORM_ID
SCREENING_FORM_VERIFY_SCREENING_FORM_FKSCREENING_FORM_VERIFYYYSCREENING_FORM_IDSCREENING_FORM_ID

 

Table NamePUBLIC.SCREENING_FORM_QUESTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns7
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1SCREENING_FORM_IDFYBIGINTLT
2SCREENING_FORM_COMPLETED_DATETimestampLT
3COMPANY_IDFYBIGINT (38) LT
4SCREENING_FORM_QUESTIONVARCHAR (65535) LT
5SCREENING_FORM_ANSWERVARCHAR (65535) LT
6SCREENING_FORM_QUESTION_SCOREBIGINTLT
7SCREENING_FORM_TOTAL_SCOREDECIMAL (5,2)LT

Columns Comments
NoColumn NameDescriptionNotes
1SCREENING_FORM_IDScreening form ID

2SCREENING_FORM_COMPLETED_DATEScreening form completed date timestamp

3COMPANY_IDCompany ID

4SCREENING_FORM_QUESTIONScreening form question

5SCREENING_FORM_ANSWERScreening form answer

6SCREENING_FORM_QUESTION_SCOREScreening form question score

7SCREENING_FORM_TOTAL_SCOREScreening form total score

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
SCREENING_FORM_QUESTION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
SCREENING_FORM_QUESTION_SCREENING_FORM_FKSCREENING_FORMYYSCREENING_FORM_IDSCREENING_FORM_ID

 

Table NamePUBLIC.USER_JOBVITE_ACTIVITY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns17
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1USER_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3USER_JOBVITE_RECEIVEBIGINTLT
4USER_JOBVITE_SENDBIGINTLT
5USER_JOBVITE_BROADCASTBIGINTLT
6USER_JOBVITE_VIEWBIGINTLT
7USER_JOBVITE_CLICK_TO_APPLYBIGINTLT
8USER_JOBVITE_FORWARDBIGINTLT
9USER_JOBVITE_APPLYBIGINTLT
10USER_JOBVITE_HIREBIGINTLT
11USER_JOBVITE_EMAIL_DIRECTBIGINTLT
12USER_JOBVITE_LINKEDIN_DIRECTBIGINTLT
13USER_JOBVITE_LINKEDIN_BROADCASTBIGINTLT
14USER_JOBVITE_FACEBOOK_BROADCASTBIGINTLT
15USER_JOBVITE_TWITTER_BROADCASTBIGINTLT
16USER_JOBVITE_JOBLINK_BROADCASTBIGINTLT
17USER_JOBVITE_ACTIVITY_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1USER_IDUser ID (COMPANY_USER.company_user_id)

2COMPANY_IDCompany ID

3USER_JOBVITE_RECEIVEUser Jobvites received

4USER_JOBVITE_SENDUser Jobvites sent

5USER_JOBVITE_BROADCASTUser Jobvites broadcast

6USER_JOBVITE_VIEWUser Jobvites viewed

7USER_JOBVITE_CLICK_TO_APPLYUser Jobvite apply starts

8USER_JOBVITE_FORWARDUser Jobvites forwarded

9USER_JOBVITE_APPLYUser Jobvite apply completes

10USER_JOBVITE_HIREUser Jobvites resulting in hire

11USER_JOBVITE_EMAIL_DIRECTUser Jobvites emailed directly

12USER_JOBVITE_LINKEDIN_DIRECTUser Jobvites shared directly on LinkedIn

13USER_JOBVITE_LINKEDIN_BROADCASTUser Jobvites broadcast to LinkedIn

14USER_JOBVITE_FACEBOOK_BROADCASTUser Jobvites broadcast to Facebook

15USER_JOBVITE_TWITTER_BROADCASTUser Jobvites broadcast to Twitter

16USER_JOBVITE_JOBLINK_BROADCASTUser Jobvites broadcast to Joblink

17USER_JOBVITE_ACTIVITY_DATEUser Jobvite activity date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
USER_JOBVITE_ACTIVITY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
USER_JOBVITE_ACTIVITY_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.VIDEO_FORM_EVALUATION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1VIDEO_FORM_EVALUATION_IDPYVARCHAR (24) LT
2VIDEO_FORM_RESPONSE_IDFYVARCHAR (24) LT
3USER_IDFYBIGINTLT
4APP_IDFYBIGINTLT
5COMPANY_IDFYBIGINT (38) LT
6STATUSVARCHAR (128) LT
7VIDEO_FORM_EVALUATION_CREATE_DATETimestampLT
8VIDEO_FORM_EVALUATION_UPDATE_DATETimestampLT
9VIDEO_FORM_EVALUATION_COMPLETION_DATETimestampLT
10VIDEO_FORM_EVALUATION_OVERALL_RATINGBIGINTLT
11VIDEO_FORM_EVALUATION_OVERALL_COMMENTVARCHAR (512) LT

Columns Comments
NoColumn NameDescriptionNotes
1VIDEO_FORM_EVALUATION_IDVideo evaluation form ID

2VIDEO_FORM_RESPONSE_IDVideo evaluation form response ID

3USER_IDUser ID (COMPANY_USER.company_user_id)

4APP_IDApplication ID

5COMPANY_IDCompany ID

6STATUSVideo evaluation form status

7VIDEO_FORM_EVALUATION_CREATE_DATEVideo evaluation form creation date timestamp

8VIDEO_FORM_EVALUATION_UPDATE_DATEVideo evaluation form last updated date timestamp

9VIDEO_FORM_EVALUATION_COMPLETION_DATEVideo evaluation form completion date timestamp

10VIDEO_FORM_EVALUATION_OVERALL_RATINGVideo evaluation form overall rating

11VIDEO_FORM_EVALUATION_OVERALL_COMMENTVideo evaluation form overall comments

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
VIDEO_FORM_EVALUATION_PKPKVIDEO_FORM_EVALUATION_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_EVALUATION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_FORM_EVALUATION_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
VIDEO_FORM_EVALUATION_VIDEO_FORM_RESPONSE_FKVIDEO_FORM_RESPONSEYYVIDEO_FORM_RESPONSE_IDVIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_EVALUATION_FKVIDEO_FORM_EVALUATION_QUESTIONYYVIDEO_FORM_EVALUATION_IDVIDEO_FORM_EVALUATION_ID

 

Table NamePUBLIC.VIDEO_FORM_EVALUATION_QUESTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1VIDEO_FORM_EVALUATION_IDFYVARCHAR (24) LT
2VIDEO_FORM_RESPONSE_IDFYVARCHAR (24) LT
3USER_IDFYBIGINTLT
4APP_IDFYBIGINTLT
5COMPANY_IDFYBIGINT (38) LT
6VIDEO_QUESTION_IDFYVARCHAR (24) LT
7VIDEO_QUESTION_RESPONSE_RATINGBIGINTLT
8VIDEO_QUESTION_RESPONSE_COMMENTVARCHAR (512) LT
9VIDEO_FORM_EVALUATION_UPDATE_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1VIDEO_FORM_EVALUATION_IDVideo evaluation ID

2VIDEO_FORM_RESPONSE_IDVideo response form ID

3USER_IDUser ID (COMPANY_USER.company_user_id)

4APP_IDApplication ID

5COMPANY_IDCompany ID

6VIDEO_QUESTION_IDVideo question ID

7VIDEO_QUESTION_RESPONSE_RATINGVideo question response rating

8VIDEO_QUESTION_RESPONSE_COMMENTVideo question response comment

9VIDEO_FORM_EVALUATION_UPDATE_DATEVideo evaluation form updated date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_QUESTION_FKVIDEO_QUESTIONYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_EVALUATION_FKVIDEO_FORM_EVALUATIONYYVIDEO_FORM_EVALUATION_IDVIDEO_FORM_EVALUATION_ID
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_RESPONSE_FKVIDEO_FORM_RESPONSEYYVIDEO_FORM_RESPONSE_IDVIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_FORM_EVALUATION_QUESTION_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

 

Table NamePUBLIC.VIDEO_FORM_RESPONSE
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns18
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1VIDEO_FORM_RESPONSE_IDPYVARCHAR (24) LT
2APP_IDFYBIGINTLT
3COMPANY_IDFYBIGINT (38) LT
4INTERVIEWEE_USER_IDFBIGINTLT
5CANDIDATE_IDBIGINTLT
6SENT_BY_USER_IDFYBIGINTLT
7JOB_IDFYBIGINTLT
8WORKFLOW_IDBIGINTLT
9STATUSVARCHAR (128) LT
10VIDEO_FORM_EVALUATION_REQUEST_COUNTBIGINTLT
11VIDEO_FORM_EVALUATION_COMPLETED_COUNTBIGINTLT
12VIDEO_FORM_IDFYVARCHAR (24) LT
13VIDEO_FORM_RESPONSE_CREATE_DATETimestampLT
14VIDEO_FORM_RESPONSE_UPDATE_DATETimestampLT
15VIDEO_FORM_RESPONSE_SENT_DATETimestampLT
16VIDEO_FORM_RESPONSE_VIEW_DATETimestampLT
17VIDEO_FORM_RESPONSE_DEADLINE_DATETimestampLT
18VIDEO_FORM_RESPONSE_COMPLETION_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1VIDEO_FORM_RESPONSE_IDVideo form response ID

2APP_IDApplication ID

3COMPANY_IDCompany ID

4INTERVIEWEE_USER_IDInterviewee User ID (COMPANY_USER.company_user_id)

5CANDIDATE_IDCandidate ID

6SENT_BY_USER_IDSent by User ID (COMPANY_USER.company_user_id)

7JOB_IDJob ID

8WORKFLOW_IDWorkflow ID

9STATUSStatus

10VIDEO_FORM_EVALUATION_REQUEST_COUNTVideo form evaluation request count

11VIDEO_FORM_EVALUATION_COMPLETED_COUNTVideo form evaluation completed count

12VIDEO_FORM_IDVideo form ID

13VIDEO_FORM_RESPONSE_CREATE_DATEVideo form response created date timestamp

14VIDEO_FORM_RESPONSE_UPDATE_DATEVideo form response last updated date timestamp

15VIDEO_FORM_RESPONSE_SENT_DATEVideo form response sent date timestamp

16VIDEO_FORM_RESPONSE_VIEW_DATEVideo form response viewed date timestamp

17VIDEO_FORM_RESPONSE_DEADLINE_DATEVideo form response deadline date

18VIDEO_FORM_RESPONSE_COMPLETION_DATEVideo form response completion date timestamp

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
VIDEO_FORM_RESPONSE_PKPKVIDEO_FORM_RESPONSE_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_RESPONSE_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_FORM_RESPONSE_VIDEO_FORM_FKVIDEO_FORMYYVIDEO_FORM_IDVIDEO_FORM_ID
VIDEO_FORM_RESPONSE_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
VIDEO_FORM_RESPONSE_JOB_FKJOBYYJOB_IDJOB_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKv1COMPANY_USERYINTERVIEWEE_USER_IDUSER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKCOMPANY_USERYYSENT_BY_USER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_RESPONSE_FKVIDEO_FORM_EVALUATION_QUESTIONYYVIDEO_FORM_RESPONSE_IDVIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_VIDEO_FORM_RESPONSE_FKVIDEO_FORM_EVALUATIONYYVIDEO_FORM_RESPONSE_IDVIDEO_FORM_RESPONSE_ID

 

Table NamePUBLIC.VIDEO_FORM_RESPONSE_QUESTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1VIDEO_FORM_RESPONSE_IDYVARCHAR (24) LT
2VIDEO_FORM_IDFYVARCHAR (24) LT
3APP_IDFYBIGINTLT
4COMPANY_IDFYBIGINT (38) LT
5INTERVIEWEE_USER_IDFBIGINTLT
6SENT_BY_USER_IDFYBIGINTLT
7CANDIDATE_IDBIGINTLT
8JOB_IDFYBIGINTLT
9VIDEO_QUESTION_IDFYVARCHAR (24) LT
10VIDEO_QUESTION_RESPONSE_DURATIONBIGINTLT
11VIDEO_FORM_RESPONSE_UPDATE_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1VIDEO_FORM_RESPONSE_IDVideo form response ID

2VIDEO_FORM_IDVideo form ID

3APP_IDApplication ID

4COMPANY_IDCompany ID

5INTERVIEWEE_USER_IDInterviewee User ID (COMPANY_USER.company_user_id)

6SENT_BY_USER_IDSent by User ID (COMPANY_USER.company_user_id)

7CANDIDATE_IDCandidate ID

8JOB_IDJob ID

9VIDEO_QUESTION_IDVideo Question ID

10VIDEO_QUESTION_RESPONSE_DURATIONVideo question response duration (min)

11VIDEO_FORM_RESPONSE_UPDATE_DATEVideo form response last updated date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_RESPONSE_QUESTION_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_QUESTION_FKVIDEO_QUESTIONYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_FORM_FKVIDEO_FORMYYVIDEO_FORM_IDVIDEO_FORM_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_FORM_RESPONSE_QUESTION_JOB_FKJOBYYJOB_IDJOB_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKv1COMPANY_USERYYSENT_BY_USER_IDUSER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKCOMPANY_USERYINTERVIEWEE_USER_IDUSER_ID

 

Table NamePUBLIC.VIDEO_QUESTION
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns9
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1VIDEO_QUESTION_IDPYVARCHAR (24) LT
2COMPANY_IDFYBIGINT (38) LT
3USER_IDFYBIGINTLT
4VIDEO_QUESTION_TITLEVARCHAR (512) LT
5VIDEO_QUESTION_TIME_TO_ANSWERBIGINTLT
6VIDEO_QUESTION_TIME_TO_PREPAREBIGINTLT
7VIDEO_QUESTION_NUMBER_OF_REDOBIGINTLT
8VIDEO_QUESTION_CREATE_DATETimestampLT
9VIDEO_QUESTION_UPDATE_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1VIDEO_QUESTION_IDVideo question ID

2COMPANY_IDCompany ID

3USER_IDUser ID (COMPANY_USER.company_user_id)

4VIDEO_QUESTION_TITLEVideo question title

5VIDEO_QUESTION_TIME_TO_ANSWERVideo question time to answer

6VIDEO_QUESTION_TIME_TO_PREPAREVideo question time to prepare

7VIDEO_QUESTION_NUMBER_OF_REDOVideo question number of redo's

8VIDEO_QUESTION_CREATE_DATEVideo question created date

9VIDEO_QUESTION_UPDATE_DATEVideo question last updated date timestamp

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
VIDEO_QUESTION_PKPKVIDEO_QUESTION_IDASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_QUESTION_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_QUESTION_COMPANY_USER_FKCOMPANY_USERYYUSER_IDUSER_ID

Foreign Keys (referred from)
NameReferred FromMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_QUESTION_FKVIDEO_FORM_EVALUATION_QUESTIONYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_QUESTION_FKVIDEO_FORM_RESPONSE_QUESTIONYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID
VIDEO_QUESTION_FORM_MAP_VIDEO_QUESTION_FKVIDEO_QUESTION_FORM_MAPYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID

 

Table NamePUBLIC.VIDEO_QUESTION_FORM_MAP
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns5
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1PRIM_KEYPYVARCHAR (49) LT
2COMPANY_IDFYBIGINT (38) LT
3VIDEO_QUESTION_IDFYVARCHAR (24) LT
4VIDEO_FORM_IDFYVARCHAR (24) LT
5VIDEO_FORM_UPDATE_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1PRIM_KEYVideo question form mapping primary key

2COMPANY_IDCompany ID

3VIDEO_QUESTION_IDVideo question ID

4VIDEO_FORM_IDVideo Form ID

5VIDEO_FORM_UPDATE_DATEVideo form last updated date timestamp

Indexes
Index NameStateFunctionalSpatialExpressionColumn NameSort
Order
VIDEO_QUESTION_FORM_MAP_PKPKPRIM_KEYASC

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
VIDEO_QUESTION_FORM_MAP_VIDEO_FORM_FKVIDEO_FORMYYVIDEO_FORM_IDVIDEO_FORM_ID
VIDEO_QUESTION_FORM_MAP_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
VIDEO_QUESTION_FORM_MAP_VIDEO_QUESTION_FKVIDEO_QUESTIONYYVIDEO_QUESTION_IDVIDEO_QUESTION_ID

 

Table NamePUBLIC.WORK_HISTORY
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query


Description
Notes

Number Of Columns11
Number Of Rows Min.0
Number Of Rows Max.9999999
Expected Number Of Rows0
Expected Growth0
Growth IntervalYear

Used In Diagrams
Diagram Name
Jobvite Data Exchange

Columns
NoColumn NamePKFKMData TypeDT
kind
Domain NameFormula
(Default Value)
SecurityAbbreviation
1APP_IDFYBIGINTLT
2COMPANY_IDFYBIGINT (38) LT
3CANDIDATE_IDBIGINTLT
4WORK_HISTORY_COMPANY_NAMEVARCHAR (100) LT
5WORK_HISTORY_TITLEVARCHAR (100) LT
6WORK_HISTORY_INDUSTRYVARCHAR (100) LT
7WORK_HISTORY_START_MONTHVARCHAR (2) LT
8WORK_HISTORY_START_YEARVARCHAR (4) LT
9WORK_HISTORY_END_MONTHVARCHAR (2) LT
10WORK_HISTORY_END_YEARVARCHAR (4) LT
11WORK_HISTORY_MODIFIED_DATETimestampLT

Columns Comments
NoColumn NameDescriptionNotes
1APP_IDApplication ID

2COMPANY_IDCompany ID

3CANDIDATE_IDCandidate ID

4WORK_HISTORY_COMPANY_NAMEWork history company name

5WORK_HISTORY_TITLEWork history title

6WORK_HISTORY_INDUSTRYWork history industry

7WORK_HISTORY_START_MONTHWork history start month

8WORK_HISTORY_START_YEARWork history start year

9WORK_HISTORY_END_MONTHWork history end month

10WORK_HISTORY_END_YEARWork history end year

11WORK_HISTORY_MODIFIED_DATEWork history last modified date timestamp

Foreign Keys (referring to)
NameRefering ToMandatoryTransferableIn ArcColumnsReferred ColumnsDelete Rule
WORK_HISTORY_COMPANY_FKCOMPANYYYCOMPANY_IDCOMPANY_ID
WORK_HISTORY_APPLICATION_FKAPPLICATIONYYAPP_IDAPP_ID


Jobvite Data Exchange

PUBLIC.JOB_JOBVITE_ACTIVITY * F JOB_ID INTEGER * F COMPANY_ID INTEGER JOB_JOBVITE_SEND INTEGER JOB_JOBVITE_BROADCAST INTEGER JOB_JOBVITE_VIEW INTEGER JOB_JOBVITE_CLICK_TO_APPLY INTEGER JOB_JOBVITE_FORWARD INTEGER JOB_JOBVITE_APPLY INTEGER JOB_JOBVITE_HIRE INTEGER JOB_JOBVITE_EMAIL_DIRECT INTEGER JOB_JOBVITE_LINKEDIN_DIRECT INTEGER JOB_JOBVITE_LINKEDIN_BROADCAST INTEGER JOB_JOBVITE_FACEBOOK_BROADCAST INTEGER JOB_JOBVITE_TWITTER_BROADCAST INTEGER JOB_JOBVITE_JOBLINK_BROADCAST INTEGER JOB_JOBVITE_ACTIVITY_DATE TIMESTAMP JOB_JOBVITE_ACTIVITY_COMPANY_FK (COMPANY_ID) JOB_JOBVITE_ACTIVITY_JOB_FK (JOB_ID) PUBLIC.VIDEO_FORM_EVALUATION_QUESTION * F VIDEO_FORM_EVALUATION_ID VARCHAR2 (24) * F VIDEO_FORM_RESPONSE_ID VARCHAR2 (24) * F USER_ID INTEGER * F APP_ID INTEGER * F COMPANY_ID INTEGER * F VIDEO_QUESTION_ID VARCHAR2 (24) VIDEO_QUESTION_RESPONSE_RATING INTEGER VIDEO_QUESTION_RESPONSE_COMMENT VARCHAR2 (512) VIDEO_FORM_EVALUATION_UPDATE_DATE TIMESTAMP VIDEO_FORM_EVALUATION_QUESTION_VIDEO_QUESTION_FK (VIDEO_QUESTION_ID) VIDEO_FORM_EVALUATION_QUESTION_COMPANY_FK (COMPANY_ID) VIDEO_FORM_EVALUATION_QUESTION_APPLICATION_FK (APP_ID) VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_RESPONSE_FK (VIDEO_FORM_RESPONSE_ID) VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_EVALUATION_FK (VIDEO_FORM_EVALUATION_ID) VIDEO_FORM_EVALUATION_QUESTION_COMPANY_USER_FK (USER_ID) PUBLIC.VIDEO_QUESTION_FORM_MAP * P PRIM_KEY VARCHAR2 (49) * F COMPANY_ID INTEGER * F VIDEO_QUESTION_ID VARCHAR2 (24) * F VIDEO_FORM_ID VARCHAR2 (24) VIDEO_FORM_UPDATE_DATE TIMESTAMP VIDEO_QUESTION_FORM_MAP_PK (PRIM_KEY) VIDEO_QUESTION_FORM_MAP_VIDEO_FORM_FK (VIDEO_FORM_ID) VIDEO_QUESTION_FORM_MAP_VIDEO_QUESTION_FK (VIDEO_QUESTION_ID) VIDEO_QUESTION_FORM_MAP_COMPANY_FK (COMPANY_ID) PUBLIC.SCREENING_FORM_QUESTION * F SCREENING_FORM_ID INTEGER SCREENING_FORM_COMPLETED_DATE TIMESTAMP * F COMPANY_ID INTEGER SCREENING_FORM_QUESTION VARCHAR2 (65535) SCREENING_FORM_ANSWER VARCHAR2 (65535) SCREENING_FORM_QUESTION_SCORE INTEGER SCREENING_FORM_TOTAL_SCORE NUMBER (5,2) SCREENING_FORM_QUESTION_SCREENING_FORM_FK (SCREENING_FORM_ID) SCREENING_FORM_QUESTION_COMPANY_FK (COMPANY_ID) PUBLIC.CONTACT_STATUS_HISTORY * P CONTACT_STATUS_HISTORY_ID INTEGER * F USER_ID INTEGER * F COMPANY_ID INTEGER * F CONTACT_ID INTEGER CONTACT_STATUS_HISTORY_CREATED_DATE TIMESTAMP CONTACT_STATUS_HISTORY_MODIFIED_DATE TIMESTAMP CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_ID INTEGER CONTACT_STATUS_HISTORY_PREVIOUS_STATUS VARCHAR2 (50) CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_DATE TIMESTAMP CONTACT_STATUS_HISTORY_NEXT_STATUS_ID INTEGER CONTACT_STATUS_HISTORY_NEXT_STATUS VARCHAR2 (50) CONTACT_STATUS_HISTORY_NEXT_STATUS_DATE TIMESTAMP CONTACT_STATUS_HISTORY_STATUS_IN_DAYS INTEGER CONTACT_STATUS_HISTORY_PK (CONTACT_STATUS_HISTORY_ID) CONTACT_STATUS_HISTORY_COMPANY_FK (COMPANY_ID) CONTACT_STATUS_HISTORY_CONTACT_FK (CONTACT_ID) CONTACT_STATUS_HISTORY_COMPANY_USER_FK (USER_ID) PUBLIC.VIDEO_FORM_EVALUATION * P VIDEO_FORM_EVALUATION_ID VARCHAR2 (24) * F VIDEO_FORM_RESPONSE_ID VARCHAR2 (24) * F USER_ID INTEGER * F APP_ID INTEGER * F COMPANY_ID INTEGER STATUS VARCHAR2 (128) VIDEO_FORM_EVALUATION_CREATE_DATE TIMESTAMP VIDEO_FORM_EVALUATION_UPDATE_DATE TIMESTAMP VIDEO_FORM_EVALUATION_COMPLETION_DATE TIMESTAMP VIDEO_FORM_EVALUATION_OVERALL_RATING INTEGER VIDEO_FORM_EVALUATION_OVERALL_COMMENT VARCHAR2 (512) VIDEO_FORM_EVALUATION_PK (VIDEO_FORM_EVALUATION_ID) VIDEO_FORM_EVALUATION_VIDEO_FORM_RESPONSE_FK (VIDEO_FORM_RESPONSE_ID) VIDEO_FORM_EVALUATION_COMPANY_FK (COMPANY_ID) VIDEO_FORM_EVALUATION_APPLICATION_FK (APP_ID) VIDEO_FORM_EVALUATION_COMPANY_USER_FK (USER_ID) PUBLIC.ONBOARDING_NEW_HIRE * P ONB_NEW_HIRE_ID VARCHAR2 (30) * F APP_ID INTEGER * F JOB_ID INTEGER * F COMPANY_ID INTEGER ONB_NEW_HIRE_ADDRESS VARCHAR2 (100) ONB_NEW_HIRE_CELL_PHONE VARCHAR2 (25) ONB_NEW_HIRE_CELL_PHONE_CODE VARCHAR2 (4) ONB_NEW_HIRE_CELL_PHONE_EXTENSION VARCHAR2 (10) ONB_NEW_HIRE_CITY VARCHAR2 (100) ONB_NEW_HIRE_COUNTRY VARCHAR2 (100) * F ONB_NEW_HIRE_CREATED_BY_USER_ID INTEGER ONB_NEW_HIRE_CREATED_DATE TIMESTAMP ONB_NEW_HIRE_MODIFIED_DATE TIMESTAMP ONB_NEW_HIRE_EMAIL VARCHAR2 (100) ONB_NEW_HIRE_FIRST_NAME VARCHAR2 (100) ONB_NEW_HIRE_LAST_NAME VARCHAR2 (100) ONB_NEW_HIRE_FULL_NAME VARCHAR2 (201) * F ONB_NEW_HIRE_HIRING_MANAGER_USER_ID INTEGER ONB_NEW_HIRE_HOME_PHONE VARCHAR2 (25) ONB_NEW_HIRE_HOME_PHONE_COUNTRY_CODE VARCHAR2 (4) ONB_NEW_HIRE_HOME_PHONE_EXTENSION VARCHAR2 (10) ONB_NEW_HIRE_HIRE_DATE TIMESTAMP ONB_NEW_HIRE_START_DATE TIMESTAMP ONB_NEW_HIRE_STATE VARCHAR2 (100) ONB_NEW_HIRE_STATE_OTHER VARCHAR2 (50) * F ONB_NEW_HIRE_MODIFIED_BY_USER_ID INTEGER ONB_NEW_HIRE_WORKFLOW_STATUS VARCHAR2 (100) ONB_NEW_HIRE_ZIP VARCHAR2 (50) ONB_NEW_HIRE_JOB_TITLE VARCHAR2 (100) ONB_NEW_HIRE_CANDIDATE_ID INTEGER ONB_NEW_HIRE_JOB_SEEKER_ID INTEGER ONB_NEW_HIRE_EMPLOYEE_USER_ID INTEGER ONB_NEW_HIRE_ENTITY_CODE VARCHAR2 (100) ONB_NEW_HIRE_DELETED CHAR (1) ONB_NEW_HIRE_GDPR_FORGOTTEN CHAR (1) ONBOARDING_NEW_HIRE_PK (ONB_NEW_HIRE_ID) ONBOARDING_NEW_HIRE_COMPANY_FK (COMPANY_ID) ONBOARDING_NEW_HIRE_JOB_FK (JOB_ID) ONBOARDING_NEW_HIRE_APPLICATION_FK (APP_ID) ONBOARDING_NEW_HIRE_COMPANY_USER_FK (ONB_NEW_HIRE_CREATED_BY_USER_ID) ONBOARDING_NEW_HIRE_COMPANY_USER_FKv1 (ONB_NEW_HIRE_HIRING_MANAGER_USER_ID) ONBOARDING_NEW_HIRE_COMPANY_USER_FKv2 (ONB_NEW_HIRE_MODIFIED_BY_USER_ID) PUBLIC.CAMPAIGN_CONTACT * P CAMPAIGN_CONTACT_ID INTEGER * F CAMPAIGN_ID INTEGER * F COMPANY_ID INTEGER CAMPAIGN_CONTACT_STATUS VARCHAR2 (50) CAMPAIGN_CONTACT_LAST_CONTACTED_DATE TIMESTAMP CAMPAIGN_CONTACT_UNSUBSCRIBED_DATE TIMESTAMP * F CONTACT_ID INTEGER CAMPAIGN_CONTACT_CREATED_DATE TIMESTAMP CAMPAIGN_CONTACT_UPDATED_DATE TIMESTAMP CAMPAIGN_CONTACT_DELETED CHAR (1) CAMPAIGN_CONTACT_PK (CAMPAIGN_CONTACT_ID) CAMPAIGN_CONTACT_COMPANY_FK (COMPANY_ID) CAMPAIGN_CONTACT_CAMPAIGN_FK (CAMPAIGN_ID) CAMPAIGN_CONTACT_CONTACT_FK (CONTACT_ID) PUBLIC.USER_JOBVITE_ACTIVITY * F USER_ID INTEGER * F COMPANY_ID INTEGER USER_JOBVITE_RECEIVE INTEGER USER_JOBVITE_SEND INTEGER USER_JOBVITE_BROADCAST INTEGER USER_JOBVITE_VIEW INTEGER USER_JOBVITE_CLICK_TO_APPLY INTEGER USER_JOBVITE_FORWARD INTEGER USER_JOBVITE_APPLY INTEGER USER_JOBVITE_HIRE INTEGER USER_JOBVITE_EMAIL_DIRECT INTEGER USER_JOBVITE_LINKEDIN_DIRECT INTEGER USER_JOBVITE_LINKEDIN_BROADCAST INTEGER USER_JOBVITE_FACEBOOK_BROADCAST INTEGER USER_JOBVITE_TWITTER_BROADCAST INTEGER USER_JOBVITE_JOBLINK_BROADCAST INTEGER USER_JOBVITE_ACTIVITY_DATE TIMESTAMP USER_JOBVITE_ACTIVITY_COMPANY_USER_FK (USER_ID) USER_JOBVITE_ACTIVITY_COMPANY_FK (COMPANY_ID) PUBLIC.CONTACT * P CONTACT_ID INTEGER * F USER_ID INTEGER * F COMPANY_ID INTEGER CONTACT_CREATED_DATE TIMESTAMP CONTACT_MODIFIED_DATE TIMESTAMP CONTACT_FIRST_NAME VARCHAR2 (100) CONTACT_LAST_NAME VARCHAR2 (100) CONTACT_MIDDLE_NAME VARCHAR2 (100) CONTACT_FULL_NAME VARCHAR2 (200) CONTACT_JOB_TITLE VARCHAR2 (100) CONTACT_COMPANY_NAME VARCHAR2 (100) CONTACT_DEPARTMENT_NAME VARCHAR2 (100) CONTACT_SOURCE_NAME VARCHAR2 (100) CONTACT_GENDER VARCHAR2 (20) CONTACT_RACE VARCHAR2 (20) CONTACT_STATUS_ID INTEGER CONTACT_STATUS VARCHAR2 (50) CONTACT_ASSIGNED_TO INTEGER CONTACT_ADDRESS1 VARCHAR2 (100) CONTACT_ADDRESS2 VARCHAR2 (50) CONTACT_ADDRESS3 VARCHAR2 (50) CONTACT_CITY VARCHAR2 (50) CONTACT_STATE VARCHAR2 (50) CONTACT_ZIP VARCHAR2 (10) CONTACT_COUNTRY VARCHAR2 (50) CONTACT_EMAIL_STATUS VARCHAR2 (50) CONTACT_TAGS VARCHAR2 (65535) CONTACT_NOTES VARCHAR2 (65535) CONTACT_ADDRESS_NOTES VARCHAR2 (100) CONTACT_ADDRESS_TYPE VARCHAR2 (50) CONTACT_PRIMARY_PHONE VARCHAR2 (20) CONTACT_PRIMARY_EMAIL VARCHAR2 (50) CONTACT_CUSTOM_DATA VARCHAR2 (65535) CONTACT_SOCIAL_NETWORK_URLS VARCHAR2 (200) CONTACT_WEBSITES VARCHAR2 (200) CONTACT_NOTES_LAST_UPDATED TIMESTAMP CONTACT_NOTES_LAST_UPDATED_BY INTEGER CONTACT_DELETED CHAR (1) CONTACT_SOURCE_TYPE_ID INTEGER CONTACT_SOURCE_TYPE VARCHAR2 (128) CANDIDATE_ID INTEGER CONTACT_JOB_ALERTS_SUBSCRIBED CHAR (1) CONTACT_JOB_ALERTS_ACTIVE CHAR (1) CONTACT_GDPR_CONSENT_DATE TIMESTAMP CONTACT_GDPR_CONSENT_LAST_REQUESTED_DATE TIMESTAMP CONTACT_GDPR_CONSENT_LOC_LAN VARCHAR2 (100) CONTACT_GDPR_DELETION_DATE TIMESTAMP CONTACT_GDPR_CONSENT_LINK VARCHAR2 (255) CONTACT_GDPR_FORGOTTEN CHAR (1) CONTACT_GDPR_CONSENT_STATUS VARCHAR2 (100) CONTACT_EID VARCHAR2 (50) COMPANY_DOUBLE_EID VARCHAR2 (100) CONTACT_CONSENT_URL VARCHAR2 (500) CONTACT_PK (CONTACT_ID) CONTACT_COMPANY_FK (COMPANY_ID) CONTACT_COMPANY_USER_FK (USER_ID) PUBLIC.ONBOARDING_PROCESS * P ONB_PROCESS_ID VARCHAR2 (30) * F COMPANY_ID INTEGER * F ONB_NEW_HIRE_ID VARCHAR2 (30) ONB_PROCESS_HIRE_DATE TIMESTAMP * F ONB_HIRING_MANAGER_USER_ID INTEGER ONB_PROCESS_PORTAL_ID VARCHAR2 (30) ONB_PROCESS_START_DATE TIMESTAMP ONB_PROCESS_ACTUAL_KICKOFF_DATE TIMESTAMP ONB_PROCESS_COMPLETES_ON TIMESTAMP ONB_PROCESS_COMPLETION_DATE TIMESTAMP * F ONB_PROCESS_CREATED_BY_USER_ID INTEGER ONB_PROCESS_CREATED_DATE TIMESTAMP ONB_PROCESS_MODIFIED_DATE TIMESTAMP ONB_PROCESS_DELAYED_KICK_OFF_DATE TIMESTAMP ONB_PROCESS_LIFE_CYCLE_STATUS VARCHAR2 (50) ONB_PROCESS_NUMBER_OF_COMPLETED_TASKS INTEGER ONB_PROCESS_NUMBER_OF_ISSUES INTEGER ONB_PROCESS_NUMBER_OF_OVERDUES INTEGER ONB_PROCESS_NUMBER_OF_SOON_OVERDUES INTEGER ONB_PROCESS_NUMBER_OF_TASKS INTEGER ONB_PROCESS_ORCHESTRATOR_USER_ID INTEGER ONB_PROCESS_ORCHESTRATOR_LOCKED CHAR (1) ONB_PROCESS_ORCHESTRATOR_TYPE VARCHAR2 (100) ONB_PROCESS_PERCENTAGE_OF_COMPLETED INTEGER * F ONB_PROCESS_TEMPLATE_ID VARCHAR2 (30) ONB_PROCESS_TEMPLATE_NAME VARCHAR2 (256) ONB_PROCESS_TRANSLATIONS_COMPLETE CHAR (1) * F ONB_PROCESS_MODIFIED_BY_USER_ID INTEGER ONB_PROCESS_WORKFLOW_STATUS VARCHAR2 (100) ONB_PROCESS_ENTITY_CODE VARCHAR2 (100) ONB_PROCESS_DELETED CHAR (1) ONBOARDING_PROCESS_PK (ONB_PROCESS_ID) ONBOARDING_PROCESS_ONBOARDING_PROCESS_TEMPLATE_FK (ONB_PROCESS_TEMPLATE_ID) ONBOARDING_PROCESS_ONBOARDING_NEW_HIRE_FK (ONB_NEW_HIRE_ID) ONBOARDING_PROCESS_COMPANY_FK (COMPANY_ID) ONBOARDING_PROCESS_COMPANY_USER_FK (ONB_PROCESS_MODIFIED_BY_USER_ID) ONBOARDING_PROCESS_COMPANY_USER_FKv1 (ONB_PROCESS_CREATED_BY_USER_ID) ONBOARDING_PROCESS_COMPANY_USER_FKv2 (ONB_HIRING_MANAGER_USER_ID) PUBLIC.AGENCY_USER * PF AGENCY_USER_ID INTEGER AGENCY_INVITATION_COMPANY_ID INTEGER AGENCY_FIRST_NAME VARCHAR2 (100) AGENCY_LAST_NAME VARCHAR2 (100) AGENCY_FULL_NAME VARCHAR2 (210) AGENCY_EMAIL VARCHAR2 (100) AGENCY_CREATED TIMESTAMP AGENCY_MODIFIED TIMESTAMP AGENCY_INVITATION_STATUS VARCHAR2 (100) AGENCY_INVITATION_SENT_DATE TIMESTAMP AGENCY_INVITATION_ACCEPTED_DATE TIMESTAMP AGENCY_USER_PK (AGENCY_USER_ID) AGENCY_USER_COMPANY_USER_FK (AGENCY_USER_ID) PUBLIC.INTERVIEW * P INTERVIEW_ID INTEGER * F USER_ID INTEGER * F APP_ID INTEGER * F COMPANY_ID INTEGER INTERVIEW_TYPE VARCHAR2 (100) INTERVIEW_CREATED_DATE TIMESTAMP INTERVIEW_SCHEDULED_DATE TIMESTAMP INTERVIEW_SCHEDULED_UTC_DATE TIMESTAMP INTERVIEW_SUMMARY VARCHAR2 (100) INTERVIEW_COMPLETED CHAR (1) INTERVIEW_COMPLETED_BY INTEGER INTERVIEW_FLAGS INTEGER INTERVIEW_CANCELLED CHAR (1) INTERVIEW_MODIFIED TIMESTAMP INTERVIEW_COMPLETED_DATE TIMESTAMP INTERVIEW_STATUS VARCHAR2 (25) INTERVIEW_SUBMITTED_DATE TIMESTAMP INTERVIEW_HR_RESTRICTED CHAR (1) INTERVIEW_SCHEDULED_BY_USER_ID INTEGER INTERVIEW_LOCATION VARCHAR2 (50) INTERVIEW_LOCATION_EMAIL VARCHAR2 (50) INTERVIEW_PK (INTERVIEW_ID) INTERVIEW_COMPANY_FK (COMPANY_ID) INTERVIEW_APPLICATION_FK (APP_ID) INTERVIEW_COMPANY_USER_FK (USER_ID) PUBLIC.ONBOARDING_TASK * P ONB_TASK_ID VARCHAR2 (30) * F COMPANY_ID INTEGER ONB_TASK_ACTIVATED_ASSIGNEE_TYPE VARCHAR2 (100) ONB_TASK_ACTIVATED_ASSIGNEE_USER_ID INTEGER ONB_TASK_ASSIGNEE_TYPE VARCHAR2 (100) * F ONB_TASK_ASSIGNEE_USER_ID INTEGER ONB_TASK_ISSUE_RAISED CHAR (1) ONB_TASK_OVERDUE_STATUS VARCHAR2 (100) ONB_TASK_ACTUAL_ACTIVATION_DATE TIMESTAMP ONB_TASK_COMPLETE CHAR (1) ONB_TASK_COMPLETION_DATE TIMESTAMP * F ONB_TASK_CREATED_BY_USER_ID INTEGER ONB_TASK_CREATED_DATE TIMESTAMP ONB_TASK_MODIFIED_DATE TIMESTAMP ONB_TASK_DELAYED_ACTIVATION_DATE TIMESTAMP ONB_TASK_DELAYED_ACTIVATION_REFERENCE VARCHAR2 (100) ONB_TASK_DESCRIPTION VARCHAR2 (1000) ONB_TASK_DUE_DATE TIMESTAMP ONB_TASK_DUE_DATE_OFFSET INTEGER ONB_TASK_EXPECTED_ACTIVATION_DATE TIMESTAMP ONB_TASK_LAST_TIME_SEEN TIMESTAMP ONB_TASK_LIFE_CYCLE_STATUS VARCHAR2 (100) ONB_TASK_LOCKED CHAR (1) ONB_TASK_LOCKED_DUE_DATE CHAR (1) * F ONB_TASK_PROCESS_INSTANCE_ID VARCHAR2 (30) ONB_TASK_REFERENCE_DUE_DATE VARCHAR2 (100) ONB_TASK_SOURCE_TYPE VARCHAR2 (100) * F ONB_TASK_TEMPLATE_ID VARCHAR2 (30) ONB_TASK_TEMPLATE_INTERNAL_NAME VARCHAR2 (256) ONB_TASK_TEMPLATE_EXTERNAL_NAME VARCHAR2 (256) * F ONB_TASK_MODIFIED_BY_USER_ID INTEGER ONB_TASK_WORKFLOW_STATUS VARCHAR2 (100) ONB_TASK_ASSIGNED_DAYS INTEGER ONB_TASK_BLOCKED_DAYS INTEGER ONB_TASK_ENTITY_CODE VARCHAR2 (100) ONB_TASK_DELETED CHAR (1) ONB_TASK_OVERDUE_DAYS INTEGER ONBOARDING_TASK_PK (ONB_TASK_ID) ONBOARDING_TASK_ONBOARDING_TASK_TEMPLATE_FK (ONB_TASK_TEMPLATE_ID) ONBOARDING_TASK_ONBOARDING_PROCESS_FK (ONB_TASK_PROCESS_INSTANCE_ID) ONBOARDING_TASK_COMPANY_FK (COMPANY_ID) ONBOARDING_TASK_COMPANY_USER_FK (ONB_TASK_ASSIGNEE_USER_ID) ONBOARDING_TASK_COMPANY_USER_FKv1 (ONB_TASK_CREATED_BY_USER_ID) ONBOARDING_TASK_COMPANY_USER_FKv2 (ONB_TASK_MODIFIED_BY_USER_ID) PUBLIC.APPROVER * P APPROVER_ID INTEGER * F ITEM_ID INTEGER ITEM_KIND INTEGER USER_ID INTEGER * F COMPANY_ID INTEGER APPROVER_STATUS VARCHAR2 (100) APPROVER_SUBMITTED TIMESTAMP APPROVER_UPDATED TIMESTAMP APPROVER_TIME_TO_UPDATE INTEGER APPROVER_DELETED CHAR (1) APPROVER_PK (APPROVER_ID) APPROVER_JOB_FK (ITEM_ID) APPROVER_COMPANY_FK (COMPANY_ID) PUBLIC.VIDEO_QUESTION * P VIDEO_QUESTION_ID VARCHAR2 (24) * F COMPANY_ID INTEGER * F USER_ID INTEGER VIDEO_QUESTION_TITLE VARCHAR2 (512) VIDEO_QUESTION_TIME_TO_ANSWER INTEGER VIDEO_QUESTION_TIME_TO_PREPARE INTEGER VIDEO_QUESTION_NUMBER_OF_REDO INTEGER VIDEO_QUESTION_CREATE_DATE TIMESTAMP VIDEO_QUESTION_UPDATE_DATE TIMESTAMP VIDEO_QUESTION_PK (VIDEO_QUESTION_ID) VIDEO_QUESTION_COMPANY_FK (COMPANY_ID) VIDEO_QUESTION_COMPANY_USER_FK (USER_ID) PUBLIC.VIDEO_FORM_RESPONSE * P VIDEO_FORM_RESPONSE_ID VARCHAR2 (24) * F APP_ID INTEGER * F COMPANY_ID INTEGER F INTERVIEWEE_USER_ID INTEGER CANDIDATE_ID INTEGER * F SENT_BY_USER_ID INTEGER * F JOB_ID INTEGER WORKFLOW_ID INTEGER STATUS VARCHAR2 (128) VIDEO_FORM_EVALUATION_REQUEST_COUNT INTEGER VIDEO_FORM_EVALUATION_COMPLETED_COUNT INTEGER * F VIDEO_FORM_ID VARCHAR2 (24) VIDEO_FORM_RESPONSE_CREATE_DATE TIMESTAMP VIDEO_FORM_RESPONSE_UPDATE_DATE TIMESTAMP VIDEO_FORM_RESPONSE_SENT_DATE TIMESTAMP VIDEO_FORM_RESPONSE_VIEW_DATE TIMESTAMP VIDEO_FORM_RESPONSE_DEADLINE_DATE TIMESTAMP VIDEO_FORM_RESPONSE_COMPLETION_DATE TIMESTAMP VIDEO_FORM_RESPONSE_PK (VIDEO_FORM_RESPONSE_ID) VIDEO_FORM_RESPONSE_VIDEO_FORM_FK (VIDEO_FORM_ID) VIDEO_FORM_RESPONSE_COMPANY_FK (COMPANY_ID) VIDEO_FORM_RESPONSE_APPLICATION_FK (APP_ID) VIDEO_FORM_RESPONSE_JOB_FK (JOB_ID) VIDEO_FORM_RESPONSE_COMPANY_USER_FK (SENT_BY_USER_ID) VIDEO_FORM_RESPONSE_COMPANY_USER_FKv1 (INTERVIEWEE_USER_ID) PUBLIC.OFCCP_SEARCH * P SEARCH_ID INTEGER * F JOB_ID INTEGER * F USER_ID INTEGER * F COMPANY_ID INTEGER SEARCH_DATE TIMESTAMP SEARCH_KEYWORDS VARCHAR2 (500) SEARCH_ALLWORDS VARCHAR2 (500) SEARCH_EXACT_PHRASE VARCHAR2 (500) SEARCH_ANYWORD VARCHAR2 (500) SEARCH_NOWORD VARCHAR2 (500) OFCCP_SEARCH_PK (SEARCH_ID) OFCCP_SEARCH_JOB_FK (JOB_ID) OFCCP_SEARCH_COMPANY_FK (COMPANY_ID) OFCCP_SEARCH_COMPANY_USER_FK (USER_ID) PUBLIC.JOB_OPEN_HISTORY * F JOB_ID INTEGER * F COMPANY_ID INTEGER JOB_OPEN_FROM_DATE TIMESTAMP JOB_OPEN_TO_DATE TIMESTAMP JOB_OPEN_MODIFIED_DATE TIMESTAMP * P JOB_OPEN_PRIMARY_KEY INTEGER JOB_OPEN_HISTORY_PK (JOB_OPEN_PRIMARY_KEY) JOB_OPEN_HISTORY_JOB_FK (JOB_ID) JOB_OPEN_HISTORY_COMPANY_FK (COMPANY_ID) PUBLIC.ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE * F USER_ID INTEGER * F COMPANY_ID INTEGER USER_ACTIVITY_DATE TIMESTAMP USER_SOCIAL_CAMPAIGN_MESSAGES_SENT INTEGER USER_EMAIL_CAMPAIGN_MESSAGES_SENT INTEGER ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_ENGAGE_USER_FK (USER_ID) ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_COMPANY_FK (COMPANY_ID) PUBLIC.ONBOARDING_TASK_TEMPLATE * P ONB_TASK_TEMPLATE_ID VARCHAR2 (30) * F COMPANY_ID INTEGER ONB_TASK_TEMPLATE_DESCRIPTION VARCHAR2 (1000) ONB_TASK_TEMPLATE_EXTERNAL_NAME VARCHAR2 (256) ONB_TASK_TEMPLATE_INTERNAL_NAME VARCHAR2 (256) ONB_TASK_TEMPLATE_ASSIGNEE_LOCKED CHAR (1) ONB_TASK_TEMPLATE_ASSIGNEE_TYPE VARCHAR2 (100) ONB_TASK_TEMPLATE_ASSIGNEE_FIRST_NAME VARCHAR2 (100) ONB_TASK_TEMPLATE_ASSIGNEE_LAST_NAME VARCHAR2 (100) ONB_TASK_TEMPLATE_CODE VARCHAR2 (100) ONB_TASK_TEMPLATE_CREATED_DATE TIMESTAMP ONB_TASK_TEMPLATE_MODIFIED_DATE TIMESTAMP ONB_TASK_TEMPLATE_CREATED_BY_USER_ID INTEGER ONB_TASK_TEMPLATE_MODIFIED_BY_USER_ID INTEGER ONB_TASK_TEMPLATE_LIFE_CYCLE_STATUS VARCHAR2 (50) ONB_TASK_TEMPLATE_LOCKED_DUE_DATE CHAR (1) ONB_TASK_TEMPLATE_PROCESS_TYPE VARCHAR2 (100) ONB_TASK_TEMPLATE_TRANSLATION_COMPLETE CHAR (1) ONB_TASK_TEMPLATE_WORKFLOW_STATUS VARCHAR2 (100) ONB_TASK_TEMPLATE_ENTITY_CODE VARCHAR2 (100) ONB_TASK_TEMPLATE_DELETED CHAR (1) ONBOARDING_TASK_TEMPLATE_PK (ONB_TASK_TEMPLATE_ID) ONBOARDING_TASK_TEMPLATE_COMPANY_FK (COMPANY_ID) PUBLIC.SCREENING_FORM * P SCREENING_FORM_ID INTEGER * F APP_ID INTEGER * F COMPANY_ID INTEGER SCREENING_FORM_NAME VARCHAR2 (128) SCREENING_FORM_STATUS VARCHAR2 (128) SCREENING_FORM_COMPLETED_DATE TIMESTAMP SCREENING_FORM_SENT_DATE TIMESTAMP SCREENING_FORM_TEMPLATE_ID INTEGER SCREENING_FORM_TOTAL_SCORE NUMBER (5,2) SCREENING_FORM_MODIFIED_DATE TIMESTAMP SCREENING_FORM_PK (SCREENING_FORM_ID) SCREENING_FORM_APPLICATION_FK (APP_ID) SCREENING_FORM_COMPANY_FK (COMPANY_ID) PUBLIC.CANDIDATE_WORKFLOW * F APP_ID INTEGER * F COMPANY_ID INTEGER APP_PREV_WORKFLOW_STATE_ITEM_ID INTEGER APP_PREV_WORKFLOW_STATE_DATE TIMESTAMP APP_PREV_WORKFLOW_STATE_NAME VARCHAR2 (100) APP_NEXT_WORKFLOW_STATE_ITEM_ID INTEGER APP_NEXT_WORKFLOW_STATE_DATE TIMESTAMP APP_NEXT_WORKFLOW_STATE_NAME VARCHAR2 (100) APP_WORKFLOW_STATE_IN_DAYS INTEGER APP_MODIFIED TIMESTAMP APP_PREV_WORKFLOW_STATE_POSITION INTEGER APP_NEXT_WORKFLOW_STATE_POSITION INTEGER F APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID INTEGER APP_WORKFLOW_ACTION_USER_FULL_NAME VARCHAR2 (100) APP_WORKFLOW_ACTION_USER_EMAIL VARCHAR2 (100) * P APP_WORKFLOW_WORKFLOW_ID INTEGER APP_WORKFLOW_STATE_IN_DAYS_NEXT_STATE INTEGER CANDIDATE_WORKFLOW_PK (APP_WORKFLOW_WORKFLOW_ID) CANDIDATE_WORKFLOW_APPLICATION_FK (APP_ID) CANDIDATE_WORKFLOW_COMPANY_FK (COMPANY_ID) CANDIDATE_WORKFLOW_COMPANY_USER_FK (APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID) PUBLIC.JOB * P JOB_ID INTEGER * F COMPANY_ID INTEGER JOB_TITLE VARCHAR2 (150) JOB_SENT_DATE TIMESTAMP JOB_CATEGORY VARCHAR2 (60) JOB_CLOSE_DATE TIMESTAMP JOB_MODIFIED_DATE TIMESTAMP JOB_OPEN_DATE TIMESTAMP JOB_AVAILABLE_TO INTEGER JOB_REQUISITION_ID VARCHAR2 (50) JOB_CREATED_BY VARCHAR2 (200) JOB_BRIEF_DESCRIPTION VARCHAR2 (2000) JOB_OPENINGS INTEGER JOB_FILLED_ON TIMESTAMP JOB_CAREER_SITE CHAR (1) JOB_COMPANY_NAME VARCHAR2 (50) JOB_COUNTRY VARCHAR2 (50) JOB_PRIVATE CHAR (1) JOB_NOTIFIED CHAR (1) JOB_APPROVE_DATE TIMESTAMP JOB_FILLED_ON2 TIMESTAMP JOB_NOTIFICATION VARCHAR2 (10) JOB_START_DATE TIMESTAMP JOB_END_DATE TIMESTAMP JOB_PUT_ON_HOLD_DATE TIMESTAMP JOB_HOLD_TIME_SPAN INTEGER JOB_LOCATION_NAME VARCHAR2 (150) JOB_LOCATION_ADDRESS VARCHAR2 (100) JOB_LOCATION_POSTAL_CODE VARCHAR2 (10) JOB_LOCATION_CITY VARCHAR2 (100) JOB_LOCATION_STATE VARCHAR2 (100) JOB_LOCATION_COUNTRY VARCHAR2 (100) JOB_LOCATION_ADDRESS2 VARCHAR2 (50) JOB_REGION_NAME VARCHAR2 (150) JOB_SUBSIDIARY_NAME VARCHAR2 (100) JOB_DEPARTMENT_NAME VARCHAR2 (150) JOB_WORKFLOW_TITLE VARCHAR2 (50) JOB_JOBTYPE_NAME VARCHAR2 (100) JOB_DAYS_OPEN INTEGER JOB_EVALUATION_NAME VARCHAR2 (100) JOB_PRE_INTERVIEW_FORM VARCHAR2 (150) JOB_TIME_TO_FILL INTEGER JOB_TIME_TO_APPROVE INTEGER JOB_CREATED_USER_FIRST_NAME VARCHAR2 (100) JOB_CREATED_USER_LAST_NAME VARCHAR2 (100) JOB_CREATED_USER_EMAIL VARCHAR2 (100) JOB_STATUS VARCHAR2 (25) JOB_EEOCATEGORY VARCHAR2 (100) JOB_PUBLISH_OPTION VARCHAR2 (100) JOB_DELETED CHAR (1) JOB_LINK_URL VARCHAR2 (256) JOB_R_FULL_NAME_GROUP VARCHAR2 (65535) JOB_HM_FULL_NAME_GROUP VARCHAR2 (65535) JOB_CREATED_BY_USERID INTEGER JOB_PRIMARY_HM_FIRST_NAME VARCHAR2 (100) JOB_PRIMARY_HM_LAST_NAME VARCHAR2 (100) JOB_PRIMARY_HM_FULL_NAME VARCHAR2 (202) JOB_PRIMARY_HM_EMAIL VARCHAR2 (100) JOB_AGENCY_LIST VARCHAR2 (65535) JOB_BONUS INTEGER JOB_EID VARCHAR2 (50) JOB_LOCATION_LIST VARCHAR2 (65535) JOB_REMAINING_OPENINGS INTEGER JOB_MOST_RECENT_OPEN_DATE TIMESTAMP JOB_PRIMARY_RECRUITER_FIRST_NAME VARCHAR2 (100) JOB_PRIMARY_RECRUITER_LAST_NAME VARCHAR2 (100) JOB_PRIMARY_RECRUITER_FULL_NAME VARCHAR2 (202) JOB_PRIMARY_RECRUITER_EMAIL VARCHAR2 (100) JOB_APPLY_FORM VARCHAR2 (256) JOB_FURTHEST_CANDIDATE_STATUS VARCHAR2 (150) JOB_EMAIL_LANG VARCHAR2 (100) JOB_PK (JOB_ID) JOB_COMPANY_FK (COMPANY_ID) PUBLIC.COMPLIANCE * P COMPLIANCE_ID INTEGER * F APP_ID INTEGER * F COMPANY_ID INTEGER COMPLIANCE_PREOFFER_GENDER VARCHAR2 (30) COMPLIANCE_POSTOFFER_GENDER VARCHAR2 (30) COMPLIANCE_PREOFFER_ETHNICITY VARCHAR2 (30) COMPLIANCE_POSTOFFER_ETHNICITY VARCHAR2 (30) COMPLIANCE_PREOFFER_EEOFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_POSTOFFER_EEOFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_PREOFFER_EEOFORM_SUBMITDATE TIMESTAMP COMPLIANCE_POSTOFFER_EEOFORM_SUBMITDATE TIMESTAMP COMPLIANCE_PREOFFER_RACE VARCHAR2 (30) COMPLIANCE_POSTOFFER_RACE VARCHAR2 (30) COMPLIANCE_POSTOFFER_DISABLEDVETERAN CHAR (1) COMPLIANCE_POSTOFFER_RECENTLYSEPERATED CHAR (1) COMPLIANCE_POSTOFFER_ARMEDFORCESSERVICEMEDALVETERAN CHAR (1) COMPLIANCE_PREOFFER_PROTECTEDVETERAN CHAR (1) COMPLIANCE_POSTOFFER_PROTECTEDVETERAN CHAR (1) COMPLIANCE_PREOFFER_NOTPROTECTEDVETERAN CHAR (1) COMPLIANCE_POSTOFFER_NOTPROTECTEDVETERAN CHAR (1) COMPLIANCE_POSTOFFER_ACTIVEWARTIMEORCAMPAIGNBADGEVETERAN CHAR (1) COMPLIANCE_PREOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS CHAR (1) COMPLIANCE_POSTOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS CHAR (1) COMPLIANCE_PREOFFER_VETERANFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_POSTOFFER_VETERANFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_PREOFFER_VETERANFORM_SUBMITDATE TIMESTAMP COMPLIANCE_POSTOFFER_VETERANFORM_SUBMITDATE TIMESTAMP COMPLIANCE_PREOFFER_DISABILITYSTATUS VARCHAR2 (20) COMPLIANCE_POSTOFFER_DISABILITYSTATUS VARCHAR2 (20) COMPLIANCE_PREOFFER_DISABILITYFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_POSTOFFER_DISABILITYFORM_FULLNAME VARCHAR2 (100) COMPLIANCE_PREOFFER_DISABILITYFORM_SUBMITDATE TIMESTAMP COMPLIANCE_POSTOFFER_DISABILITYFORM_SUBMITDATE TIMESTAMP COMPLIANCE_PREOFFER_FORM_SENT_DATE TIMESTAMP COMPLIANCE_PREOFFER_FORM_STATUS VARCHAR2 (10) COMPLIANCE_POSTOFFER_FORM_SENT_DATE TIMESTAMP COMPLIANCE_POSTOFFER_FORM_STATUS VARCHAR2 (10) COMPLIANCE_UPDATEDATE TIMESTAMP COMPLIANCE_PREOFFER_FORM_COMPLETED_DATE TIMESTAMP COMPLIANCE_POSTOFFER_FORM_COMPLETED_DATE TIMESTAMP COMPLIANCE_PK (COMPLIANCE_ID) COMPLIANCE_APPLICATION_FK (APP_ID) COMPLIANCE_COMPANY_FK (COMPANY_ID) PUBLIC.ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN * F USER_ID INTEGER * F COMPANY_ID INTEGER USER_ACTIVITY_DATE TIMESTAMP USER_ACTIVE_EMAIL_CAMPAIGNS INTEGER USER_ACTIVE_SOCIAL_CAMPAIGNS INTEGER USER_ACTIVE_WEBPAGE_CAMPAIGNS INTEGER USER_ACTIVE_CAMPAIGNS INTEGER ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_ENGAGE_USER_FK (USER_ID) ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_COMPANY_FK (COMPANY_ID) PUBLIC.ENGAGE_USER_ACTIVITY_CONTACT * F USER_ID INTEGER * F COMPANY_ID INTEGER USER_ACTIVITY_DATE TIMESTAMP USER_ASSIGNED_CONTACTS INTEGER USER_CONTACTS_MOVED INTEGER USER_CONTACTS_ADDED INTEGER USER_CANDIDATES_ADDED INTEGER USER_CONTACTS_MOVED_CONTACTED INTEGER USER_CONTACTS_MOVED_HIRED INTEGER USER_NOTES_ADDED INTEGER ENGAGE_USER_ACTIVITY_CONTACT_ENGAGE_USER_FK (USER_ID) ENGAGE_USER_ACTIVITY_CONTACT_COMPANY_FK (COMPANY_ID) PUBLIC.ENGAGE_USER_ACTIVITY * F USER_ID INTEGER * F COMPANY_ID INTEGER USER_ACTIVITY_DATE TIMESTAMP USER_MESSAGES_SENT_TO_CONTACTS INTEGER USER_SHARE_CONTACT_COUNT INTEGER USER_REQUISITION_COUNT INTEGER USER_ASSIGNED_CONTACTS INTEGER USER_CONTACTS_ADDED INTEGER USER_ACTIVE_EMAIL_CAMPAIGNS INTEGER USER_ACTIVE_SOCIAL_CAMPAIGNS INTEGER USER_ACTIVE_WEBPAGE_CAMPAIGNS INTEGER USER_CONTACTS_MOVED INTEGER USER_SOCIAL_CAMPAIGN_MESSAGES_SENT INTEGER USER_EMAIL_CAMPAIGN_MESSAGES_SENT INTEGER USER_TASK_CREATED INTEGER USER_TASK_COMPLETED INTEGER USER_TASK_INCOMPLETE INTEGER USER_TASK_OVERDUE INTEGER USER_JOBVITE_RECEIVE INTEGER USER_JOBVITE_SEND INTEGER USER_JOBVITE_BROADCAST INTEGER USER_JOBVITE_VIEW INTEGER USER_JOBVITE_CLICK_TO_APPLY INTEGER USER_JOBVITE_FORWARD INTEGER USER_JOBVITE_APPLY INTEGER USER_JOBVITE_HIRE INTEGER USER_JOBVITE_EMAIL_DIRECT INTEGER USER_JOBVITE_LINKEDIN_DIRECT INTEGER USER_JOBVITE_LINKEDIN_BROADCAST INTEGER USER_JOBVITE_FACEBOOK_BROADCAST INTEGER USER_JOBVITE_TWITTER_BROADCAST INTEGER USER_JOBVITE_JOBLINK_BROADCAST INTEGER USER_CANDIDATES_ADDED INTEGER USER_CONTACTS_MOVED_CONTACTED INTEGER USER_CONTACTS_MOVED_HIRED INTEGER USER_ACTIVE_CAMPAIGNS INTEGER USER_PUBLISHER_STATUS CHAR (1) USER_CONTACTS_EVER_MOVED_CANDIDATE_STATUS INTEGER USER_CONTACTS_EVER_MOVED_CONTACTED_STATUS INTEGER USER_CONTACTS_EVER_MOVED_HIRED_STATUS INTEGER USER_NOTES_ADDED INTEGER ENGAGE_USER_ACTIVITY_ENGAGE_USER_FK (USER_ID) ENGAGE_USER_ACTIVITY_COMPANY_FK (COMPANY_ID) PUBLIC.GDPR_CONTACT * F CONTACT_ID INTEGER CONTACT_EID VARCHAR2 (50) * F COMPANY_ID INTEGER GDPR_CONTACT_CREATED_DATE TIMESTAMP GDPR_CONTACT_REMOVED_DATE TIMESTAMP GDPR_CONTACT_REMOVE_INITIATOR_TYPE VARCHAR2 (20) GDPR_CONTACT_REMOVE_TYPE VARCHAR2 (10) GDPR_CONTACT_CONSENT_DATE TIMESTAMP GDPR_CONTACT_CONSENT_LOC_LAN VARCHAR2 (100) GDPR_CONTACT_REMOVAL_REASON VARCHAR2 (200) GDPR_CONTACT_REMOVAL_INITIATOR_NAME VARCHAR2 (200) GDPR_CONTACT_REMOVAL_INITIATOR_EMAIL VARCHAR2 (100) GDPR_CONTACT_REMOVAL_INITIATOR_DEPARTMENT VARCHAR2 (50) GDPR_CONTACT_REMOVAL_INITIATOR_USERID INTEGER GDPR_CONTACT_COMPANY_FK (COMPANY_ID) GDPR_CONTACT_CONTACT_FK (CONTACT_ID) PUBLIC.GDPR_APPLICATION * F APP_ID INTEGER APP_EID VARCHAR2 (50) * F COMPANY_ID INTEGER GDPR_APP_SENT_DATE TIMESTAMP GDPR_APP_REMOVED_DATE TIMESTAMP GDPR_APP_REMOVE_INITIATOR_TYPE VARCHAR2 (20) GDPR_APP_REMOVE_TYPE VARCHAR2 (10) GDPR_APP_CONSENT_DATE TIMESTAMP GDPR_APP_CONSENT_LOC_LAN VARCHAR2 (100) GDPR_APP_REMOVAL_REASON VARCHAR2 (200) GDPR_APP_REMOVAL_INITIATOR_NAME VARCHAR2 (200) GDPR_APP_REMOVAL_INITIATOR_EMAIL VARCHAR2 (100) GDPR_APP_REMOVAL_INITIATOR_DEPARTMENT VARCHAR2 (50) GDPR_APP_REMOVAL_INITIATOR_USERID INTEGER * F GDPR_APP_JOB_ID INTEGER GDPR_APP_JOB_LOCATION_NAME VARCHAR2 (150) GDPR_APP_JOB_LOCATION_COUNTRY VARCHAR2 (100) GDPR_APP_JOB_TITLE VARCHAR2 (150) GDPR_APP_JOB_REGION_NAME VARCHAR2 (150) GDPR_APPLICATION_APPLICATION_FK (APP_ID) GDPR_APPLICATION_COMPANY_FK (COMPANY_ID) GDPR_APPLICATION_JOB_FK (GDPR_APP_JOB_ID) PUBLIC.APPLICATION * P APP_ID INTEGER * F JOB_ID INTEGER * F COMPANY_ID INTEGER * F APP_USER_ID INTEGER APP_SENT_DATE TIMESTAMP APP_HIRE_DATE TIMESTAMP APP_SOURCETYPE VARCHAR2 (50) APP_SOURCE VARCHAR2 (50) APP_MODIFIED TIMESTAMP APP_START_DATE TIMESTAMP * APP_CANDIDATE_ID INTEGER APP_FIRST_NAME VARCHAR2 (100) APP_LAST_NAME VARCHAR2 (100) APP_FULL_NAME VARCHAR2 (225) APP_EMAIL VARCHAR2 (100) APP_ADDRESS VARCHAR2 (100) APP_ADDRESS2 VARCHAR2 (100) APP_CITY VARCHAR2 (50) APP_STATE VARCHAR2 (50) APP_POSTAL_CODE VARCHAR2 (50) APP_COUNTRY VARCHAR2 (50) APP_DISPOSITION_NAME VARCHAR2 (100) APP_PHONE VARCHAR2 (25) APP_VETERAN_STATUS VARCHAR2 (50) APP_GENDER VARCHAR2 (50) APP_RACE VARCHAR2 (50) APP_WORK_STATUS VARCHAR2 (50) APP_TITLE VARCHAR2 (100) APP_WORKFLOW_STATE_ID INTEGER APP_WORKFLOW_STATE_NAME VARCHAR2 (150) APP_WORKFLOW_STATE_DATE TIMESTAMP APP_COMPANY VARCHAR2 (100) APP_COLLECTION_NAME VARCHAR2 (50) APP_WORKFLOW_STATE_PREV_DATE TIMESTAMP APP_WORKFLOW_STATE_PREV_NAME VARCHAR2 (100) APP_WORKFLOW_STATE_IN_DAYS INTEGER APP_TOTAL_DAYS_TO_HIRE INTEGER APP_DELETED CHAR (1) APP_JOBVITE_CHANNEL VARCHAR2 (50) APP_ENTERED_BY_USERID INTEGER APP_WORK_PHONE VARCHAR2 (25) APP_CELL_PHONE VARCHAR2 (25) APP_WORKFLOW_STATE_POSITION INTEGER APP_USER_ID_FROM_CANDIDATE_LOOKUP INTEGER APP_EID VARCHAR2 (50) APP_HIRE_LOCATION_NAME VARCHAR2 (150) APP_PREFERRED_LOCATION_LIST VARCHAR2 (65535) APP_CANDIDATE_EID VARCHAR2 (50) APP_COMMENTS VARCHAR2 (65535) APP_OFFER_ACCEPTED_DATE TIMESTAMP APP_JOB_ALERTS_ACTIVE CHAR (1) APP_STATUS_LEVEL INTEGER APP_GDPR_CONSENT_STATUS VARCHAR2 (100) APP_GDPR_CONSENT_DATE TIMESTAMP APP_GDPR_CONSENT_LAST_REQUESTED_DATE TIMESTAMP APP_GDPR_CONSENT_LOC_LAN VARCHAR2 (100) APP_GDPR_DELETION_DATE TIMESTAMP APP_GDPR_CONSENT_LINK VARCHAR2 (255) APP_GDPR_FORGOTTEN CHAR (1) APPLICATION_PK (APP_ID) APPLICATION_JOB_FK (JOB_ID) APPLICATION_COMPANY_FK (COMPANY_ID) APPLICATION_COMPANY_USER_FK (APP_USER_ID) PUBLIC.GDPR_ONBOARDING_ENTITY * P ONB_ENTITY_ID VARCHAR2 (30) * F COMPANY_ID INTEGER GDPR_ONB_ENTITY_REMOVED_TYPE INTEGER GDPR_ONB_ENTITY_REMOVED_DATE TIMESTAMP GDPR_ONB_ENTITY_REMOVE_INITIATOR_TYPE VARCHAR2 (20) GDPR_ONB_ENTITY_REMOVE_TYPE VARCHAR2 (10) GDPR_ONB_ENTITY_CONSENT_DATE TIMESTAMP GDPR_ONB_ENTITY_REMOVAL_INITIATOR_NAME VARCHAR2 (200) GDPR_ONB_ENTITY_REMOVAL_INITIATOR_EMAIL VARCHAR2 (100) GDPR_ONB_ENTITY_REMOVAL_INITIATOR_DEPARTMENT VARCHAR2 (50) * F GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID INTEGER GDPR_ONB_ENTITY_DELETED CHAR (1) GDPR_ONBOARDING_ENTITY_PK (ONB_ENTITY_ID) GDPR_ONBOARDING_ENTITY_COMPANY_FK (COMPANY_ID) GDPR_ONBOARDING_ENTITY_COMPANY_USER_FK (GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID) PUBLIC.ONBOARDING_PORTAL * ONB_PORTAL_ID VARCHAR2 (30) * F COMPANY_ID INTEGER ONB_PORTAL_DESCRIPTION VARCHAR2 (1000) ONB_PORTAL_EXTERNAL_NAME VARCHAR2 (256) ONB_PORTAL_INTERNAL_NAME VARCHAR2 (256) ONB_PORTAL_CREATED_DATE TIMESTAMP ONB_PORTAL_MODIFIED_DATE TIMESTAMP ONB_PORTAL_CREATED_BY_USER_ID INTEGER ONB_PORTAL_MODIFIED_BY_USER_ID INTEGER ONB_PORTAL_LIFE_CYCLE_STATUS VARCHAR2 (50) ONB_PORTAL_USED_IN_ONBOARDINGS INTEGER ONB_PORTAL_USED_IN_PROCESS INTEGER ONB_PORTAL_TRANSLATION_COMPLETE CHAR (1) ONB_PORTAL_WORKFLOW_STATUS VARCHAR2 (100) ONB_PORTAL_ENTITY_CODE VARCHAR2 (100) ONB_PORTAL_DELETED CHAR (1) ONBOARDING_PORTAL_COMPANY_FK (COMPANY_ID) ONBOARDING_PORTAL_COMPANY_FKv1 (COMPANY_ID) PUBLIC.AGENCY_JOB * P AGENCY_JOB_ID INTEGER * F JOB_ID INTEGER * F USER_ID INTEGER * F COMPANY_ID INTEGER AGENCY_JOB_SENT_DATE TIMESTAMP AGENCY_JOB_PK (AGENCY_JOB_ID) AGENCY_JOB_JOB_FK (JOB_ID) AGENCY_JOB_COMPANY_FK (COMPANY_ID) AGENCY_JOB_COMPANY_USER_FK (USER_ID) PUBLIC.ONBOARDING_PROCESS_TEMPLATE * P ONB_PROCESS_TEMPLATE_ID VARCHAR2 (30) * F COMPANY_ID INTEGER ONB_PROCESS_TEMPLATE_NAME VARCHAR2 (100) ONB_PROCESS_TEMPLATE_DESCRIPTION VARCHAR2 (1000) ONB_PROCESS_TEMPLATE_CODE VARCHAR2 (100) ONB_PROCESS_TEMPLATE_NUMBER_OF_TASKS INTEGER ONB_PROCESS_TEMPLATE_ORCHESTRATOR_ID INTEGER ONB_PROCESS_TEMPLATE_HAS_CORPORATE_ACCOUNT CHAR (1) ONB_PROCESS_TEMPLATE_PORTAL_ID VARCHAR2 (30) ONB_PROCESS_TEMPLATE_ORCHESTRATOR_TYPE VARCHAR2 (100) ONB_PROCESS_TEMPLATE_CREATED_DATE TIMESTAMP ONB_PROCESS_TEMPLATE_MODIFIED_DATE TIMESTAMP * F ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID INTEGER * F ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID INTEGER ONB_PROCESS_TEMPLATE_LIFE_CYCLE_STATUS VARCHAR2 (50) ONB_PROCESS_TEMPLATE_TRANSLATION_COMPLETE CHAR (1) ONB_PROCESS_TEMPLATE_WORKFLOW_STATUS VARCHAR2 (100) ONB_PROCESS_TEMPLATE_ENTITY_CODE VARCHAR2 (100) ONB_PROCESS_TEMPLATE_DELETED CHAR (1) ONBOARDING_PROCESS_TEMPLATE_PK (ONB_PROCESS_TEMPLATE_ID) ONBOARDING_PROCESS_TEMPLATE_COMPANY_FK (COMPANY_ID) ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FK (ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID) ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKv1 (ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID) PUBLIC.WORK_HISTORY * F APP_ID INTEGER * F COMPANY_ID INTEGER CANDIDATE_ID INTEGER WORK_HISTORY_COMPANY_NAME VARCHAR2 (100) WORK_HISTORY_TITLE VARCHAR2 (100) WORK_HISTORY_INDUSTRY VARCHAR2 (100) WORK_HISTORY_START_MONTH VARCHAR2 (2) WORK_HISTORY_START_YEAR VARCHAR2 (4) WORK_HISTORY_END_MONTH VARCHAR2 (2) WORK_HISTORY_END_YEAR VARCHAR2 (4) WORK_HISTORY_MODIFIED_DATE TIMESTAMP WORK_HISTORY_COMPANY_FK (COMPANY_ID) WORK_HISTORY_APPLICATION_FK (APP_ID) PUBLIC.INTERVIEW_EVALUATION * P INTERVIEW_EVALUATION_ID INTEGER * F COMPANY_ID INTEGER INTERVIEW_EVALUATION_MODIFIED_DATE TIMESTAMP INTERVIEW_EVALUATION_TYPE VARCHAR2 (50) INTERVIEW_EVALUATION_TITLE VARCHAR2 (256) INTERVIEW_EVALUATION_RATING VARCHAR2 (256) INTERVIEW_EVALUATION_COMMENTS VARCHAR2 (4096) INTERVIEW_EVALUATION_PK (INTERVIEW_EVALUATION_ID) INTERVIEW_EVALUATION_COMPANY_FK (COMPANY_ID) PUBLIC.JOB_OWNER * P JOB_OWNER_ID INTEGER * F JOB_ID INTEGER * F USER_ID INTEGER * F COMPANY_ID INTEGER IS_RECRUITER CHAR (1) JOB_OWNER_MODIFIED TIMESTAMP JOB_OWNER_PK (JOB_OWNER_ID) JOB_OWNER_JOB_FK (JOB_ID) JOB_OWNER_COMPANY_FK (COMPANY_ID) JOB_OWNER_COMPANY_USER_FK (USER_ID) PUBLIC.COMPANY_USER * P USER_ID INTEGER * F COMPANY_ID INTEGER USER_FIRST_NAME VARCHAR2 (100) USER_LAST_NAME VARCHAR2 (100) USER_FULL_NAME VARCHAR2 (210) USER_EMAIL VARCHAR2 (100) USER_TITLE VARCHAR2 (100) USER_ADDRESS VARCHAR2 (100) USER_CITY VARCHAR2 (50) USER_POSTALCODE VARCHAR2 (20) USER_STATE VARCHAR2 (100) USER_ROLE VARCHAR2 (200) USER_CREATED TIMESTAMP USER_HOMEPHONE VARCHAR2 (20) USER_WORKPHONE VARCHAR2 (20) USER_MOBILE VARCHAR2 (20) USER_IS_EMPLOYEE CHAR (1) USER_COUNTRY VARCHAR2 (50) USER_DISABLED CHAR (1) USER_ZIP VARCHAR2 (20) USER_DEPARTMENT VARCHAR2 (50) USER_LOCATION VARCHAR2 (50) USER_MODIFIED TIMESTAMP USER_LAST_LOGGED_IN TIMESTAMP USER_INVITATION_STATUS VARCHAR2 (100) USER_INVITATION_SENT_DATE TIMESTAMP USER_INVITATION_ACCEPTED_DATE TIMESTAMP USER_INVITATION_COMPANY_ID INTEGER USER_PUBLISHER_STATUS CHAR (1) USER_ACTIVE CHAR (1) USER_EMPLOYEE_ID VARCHAR2 (40) USER_LANGUAGE VARCHAR2 (150) USER_MANAGER_ID INTEGER USER_FACEBOOK_REQUIRES_REAUTHENTICATION CHAR (1) USER_FACEBOOK_REQUIRES_CONNECTION CHAR (1) USER_LINKEDIN_REQUIRES_REAUTHENTICATION CHAR (1) USER_LINKEDIN_REQUIRES_CONNECTION CHAR (1) USER_TWITTER_REQUIRES_REAUTHENTICATION CHAR (1) USER_TWITTER_REQUIRES_CONNECTION CHAR (1) USER_FACEBOOK_REQUIRES_STATUS_UPDATE_ENABLE CHAR (1) USER_LINKEDIN_REQUIRES_STATUS_UPDATE_ENABLE CHAR (1) USER_TWITTER_REQUIRES_STATUS_UPDATE_ENABLE CHAR (1) COMPANY_USER_PK (USER_ID) COMPANY_USER_COMPANY_FK (COMPANY_ID) PUBLIC.VIDEO_FORM_RESPONSE_QUESTION * VIDEO_FORM_RESPONSE_ID VARCHAR2 (24) * F VIDEO_FORM_ID VARCHAR2 (24) * F APP_ID INTEGER * F COMPANY_ID INTEGER F INTERVIEWEE_USER_ID INTEGER * F SENT_BY_USER_ID INTEGER CANDIDATE_ID INTEGER * F JOB_ID INTEGER * F VIDEO_QUESTION_ID VARCHAR2 (24) VIDEO_QUESTION_RESPONSE_DURATION INTEGER VIDEO_FORM_RESPONSE_UPDATE_DATE TIMESTAMP VIDEO_FORM_RESPONSE_QUESTION_VIDEO_FORM_FK (VIDEO_FORM_ID) VIDEO_FORM_RESPONSE_QUESTION_VIDEO_QUESTION_FK (VIDEO_QUESTION_ID) VIDEO_FORM_RESPONSE_QUESTION_COMPANY_FK (COMPANY_ID) VIDEO_FORM_RESPONSE_QUESTION_APPLICATION_FK (APP_ID) VIDEO_FORM_RESPONSE_QUESTION_JOB_FK (JOB_ID) VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FK (INTERVIEWEE_USER_ID) VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKv1 (SENT_BY_USER_ID) PUBLIC.EDUCATION * F APP_ID INTEGER * F COMPANY_ID INTEGER CANDIDATE_ID INTEGER EDUCATION_COLLEGE_NAME VARCHAR2 (200) EDUCATION_DEGREE_NAME VARCHAR2 (200) EDUCATION_MAJOR VARCHAR2 (200) EDUCATION_DEGREE_TYPE VARCHAR2 (50) EDUCATION_START_DATE VARCHAR2 (20) EDUCATION_END_DATE VARCHAR2 (20) EDUCATION_MODIFIED_DATE TIMESTAMP EDUCATION_APPLICATION_FK (APP_ID) EDUCATION_COMPANY_FK (COMPANY_ID) PUBLIC.ENGAGE_USER * P USER_ID INTEGER * F COMPANY_ID INTEGER ENGAGE_USER_PK (USER_ID) ENGAGE_USER_COMPANY_FK (COMPANY_ID)