Objects

Diagrams
1. Jobvite Data Exchange

Jobvite Data Exchange

Design Name	JobviteDataWarehouseERD
Version Date	18.05.2020 11:01:06
Version Comment
Model Name	Jobvite_QA_DataWarehouse

SubViews

SubView	Description	Notes	Object
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 Name	PUBLIC.AGENCY_JOB
Functional Name
Abbreviation
Classification Type Name
Object Type Name
MV Prebuilt
MV Query

Description
Notes

Number Of Columns	5
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	AGENCY_JOB_ID	P		Y	BIGINT	LT
2	JOB_ID		F	Y	BIGINT (38)	LT
3	USER_ID		F	Y	BIGINT	LT
4	COMPANY_ID		F	Y	BIGINT (38)	LT
5	AGENCY_JOB_SENT_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	AGENCY_JOB_ID	Agency Job ID
2	JOB_ID	Job ID
3	USER_ID	User ID (User who sent Agency Job) (COMPANY_USER.company_user_id)
4	COMPANY_ID	Company ID (Company associated with Job ID)
5	AGENCY_JOB_SENT_DATE	Agency Job Sent Date

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
AGENCY_JOB_PK	PK				AGENCY_JOB_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
AGENCY_JOB_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
AGENCY_JOB_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
AGENCY_JOB_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	11
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	AGENCY_USER_ID	P	F	Y	BIGINT	LT
2	AGENCY_INVITATION_COMPANY_ID				BIGINT	LT
3	AGENCY_FIRST_NAME				VARCHAR (100)	LT
4	AGENCY_LAST_NAME				VARCHAR (100)	LT
5	AGENCY_FULL_NAME				VARCHAR (210)	LT
6	AGENCY_EMAIL				VARCHAR (100)	LT
7	AGENCY_CREATED				Timestamp	LT
8	AGENCY_MODIFIED				Timestamp	LT
9	AGENCY_INVITATION_STATUS				VARCHAR (100)	LT
10	AGENCY_INVITATION_SENT_DATE				Timestamp	LT
11	AGENCY_INVITATION_ACCEPTED_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	AGENCY_USER_ID	Agency User ID (COMPANY_USER.company_user_id)
2	AGENCY_INVITATION_COMPANY_ID	Company ID who sent Agency Invitation
3	AGENCY_FIRST_NAME	Agency User first name
4	AGENCY_LAST_NAME	Agency User last name
5	AGENCY_FULL_NAME	Agency User full name
6	AGENCY_EMAIL	Agency user email address
7	AGENCY_CREATED	Agency created date
8	AGENCY_MODIFIED	Agency last updated date
9	AGENCY_INVITATION_STATUS	Agency invitation status
10	AGENCY_INVITATION_SENT_DATE	Agency invitation sent date
11	AGENCY_INVITATION_ACCEPTED_DATE	Agency invitation accepted date

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
AGENCY_USER_PK	PK				AGENCY_USER_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
AGENCY_USER_COMPANY_USER_FK	COMPANY_USER	Y	Y		AGENCY_USER_ID	USER_ID

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

Description
Notes

Number Of Columns	59
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	APP_ID	P		Y	BIGINT	LT
2	JOB_ID		F	Y	BIGINT (38)	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	APP_USER_ID		F	Y	BIGINT	LT
5	APP_SENT_DATE				Timestamp	LT
6	APP_HIRE_DATE				Timestamp	LT
7	APP_SOURCETYPE				VARCHAR (50)	LT
8	APP_SOURCE				VARCHAR (50)	LT
9	APP_MODIFIED				Timestamp	LT
10	APP_START_DATE				Timestamp	LT
11	APP_CANDIDATE_ID			Y	BIGINT	LT
12	APP_FIRST_NAME				VARCHAR (100)	LT
13	APP_LAST_NAME				VARCHAR (100)	LT
14	APP_FULL_NAME				VARCHAR (225)	LT
15	APP_EMAIL				VARCHAR (100)	LT
16	APP_ADDRESS				VARCHAR (100)	LT
17	APP_ADDRESS2				VARCHAR (100)	LT
18	APP_CITY				VARCHAR (50)	LT
19	APP_STATE				VARCHAR (50)	LT
20	APP_POSTAL_CODE				VARCHAR (50)	LT
21	APP_COUNTRY				VARCHAR (50)	LT
22	APP_DISPOSITION_NAME				VARCHAR (100)	LT
23	APP_PHONE				VARCHAR (25)	LT
24	APP_VETERAN_STATUS				VARCHAR (50)	LT
25	APP_GENDER				VARCHAR (50)	LT
26	APP_RACE				VARCHAR (50)	LT
27	APP_WORK_STATUS				VARCHAR (50)	LT
28	APP_TITLE				VARCHAR (100)	LT
29	APP_WORKFLOW_STATE_ID				BIGINT	LT
30	APP_WORKFLOW_STATE_NAME				VARCHAR (150)	LT
31	APP_WORKFLOW_STATE_DATE				Timestamp	LT
32	APP_COMPANY				VARCHAR (100)	LT
33	APP_COLLECTION_NAME				VARCHAR (50)	LT
34	APP_WORKFLOW_STATE_PREV_DATE				Timestamp	LT
35	APP_WORKFLOW_STATE_PREV_NAME				VARCHAR (100)	LT
36	APP_WORKFLOW_STATE_IN_DAYS				BIGINT	LT
37	APP_TOTAL_DAYS_TO_HIRE				BIGINT	LT
38	APP_DELETED				Boolean	LT
39	APP_JOBVITE_CHANNEL				VARCHAR (50)	LT
40	APP_ENTERED_BY_USERID				BIGINT	LT
41	APP_WORK_PHONE				VARCHAR (25)	LT
42	APP_CELL_PHONE				VARCHAR (25)	LT
43	APP_WORKFLOW_STATE_POSITION				BIGINT	LT
44	APP_USER_ID_FROM_CANDIDATE_LOOKUP				BIGINT	LT
45	APP_EID				VARCHAR (50)	LT
46	APP_HIRE_LOCATION_NAME				VARCHAR (150)	LT
47	APP_PREFERRED_LOCATION_LIST				VARCHAR (65535)	LT
48	APP_CANDIDATE_EID				VARCHAR (50)	LT
49	APP_COMMENTS				VARCHAR (65535)	LT
50	APP_OFFER_ACCEPTED_DATE				Timestamp	LT
51	APP_JOB_ALERTS_ACTIVE				Boolean	LT
52	APP_STATUS_LEVEL				BIGINT	LT
53	APP_GDPR_CONSENT_STATUS				VARCHAR (100)	LT
54	APP_GDPR_CONSENT_DATE				Timestamp	LT
55	APP_GDPR_CONSENT_LAST_REQUESTED_DATE				Timestamp	LT
56	APP_GDPR_CONSENT_LOC_LAN				VARCHAR (100)	LT
57	APP_GDPR_DELETION_DATE				Timestamp	LT
58	APP_GDPR_CONSENT_LINK				VARCHAR (255)	LT
59	APP_GDPR_FORGOTTEN				Boolean	LT

Columns Comments

No	Column Name	Description
1	APP_ID	Applicant ID
2	JOB_ID	Job ID
3	COMPANY_ID	Application Company ID
4	APP_USER_ID	Applicant User ID (COMPANY_USER.company_user_ID)
5	APP_SENT_DATE	Application sent date
6	APP_HIRE_DATE	Application hire date
7	APP_SOURCETYPE	Applicant source type
8	APP_SOURCE	Application source
9	APP_MODIFIED	Application last modified date
10	APP_START_DATE	Application start date
11	APP_CANDIDATE_ID	Applicant Candidate ID
12	APP_FIRST_NAME	Applicant first name
13	APP_LAST_NAME	Applicant last name
14	APP_FULL_NAME	Applicant full name
15	APP_EMAIL	Applicant email address
16	APP_ADDRESS	Applicant address
17	APP_ADDRESS2	Applicant address line 2
18	APP_CITY	Applicant city
19	APP_STATE	Applicant state
20	APP_POSTAL_CODE	Applicant postal code
21	APP_COUNTRY	Applicant country
22	APP_DISPOSITION_NAME	Application disposition name
23	APP_PHONE	Applicant phone number
24	APP_VETERAN_STATUS	Applicant veteran status
25	APP_GENDER	Applicant gender
26	APP_RACE	Applicant race
27	APP_WORK_STATUS	Applicant work status
28	APP_TITLE	Candidate's current job title
29	APP_WORKFLOW_STATE_ID	Application current workflow state ID
30	APP_WORKFLOW_STATE_NAME	Application current workflow state name
31	APP_WORKFLOW_STATE_DATE	Application current workflow state start date
32	APP_COMPANY	Application company
33	APP_COLLECTION_NAME	Application Collection name
34	APP_WORKFLOW_STATE_PREV_DATE	Application previous workflow state start date
35	APP_WORKFLOW_STATE_PREV_NAME	Application previous workflow state name
36	APP_WORKFLOW_STATE_IN_DAYS	Application current workflow duration in days (application current workflow state start date to today)
37	APP_TOTAL_DAYS_TO_HIRE	Application total days to hire (application sent date to hire date)
38	APP_DELETED	Application deleted ()
39	APP_JOBVITE_CHANNEL	Application jobvite origination type (email, Facebook, phone, etc.)
40	APP_ENTERED_BY_USERID	Application Entered by UserID
41	APP_WORK_PHONE	Applicant work phone
42	APP_CELL_PHONE	Applicant cell phone
43	APP_WORKFLOW_STATE_POSITION	Application workflow state position
44	APP_USER_ID_FROM_CANDIDATE_LOOKUP	Application User ID from Candidate lookup
45	APP_EID	Applicant Encrypted ID
46	APP_HIRE_LOCATION_NAME	Application Hire location name
47	APP_PREFERRED_LOCATION_LIST	Application preferred location list
48	APP_CANDIDATE_EID	Applicant Candidate Encrypted ID
49	APP_COMMENTS	Application internal comments
50	APP_OFFER_ACCEPTED_DATE	Application offer accepted date
51	APP_JOB_ALERTS_ACTIVE	Applicant job alerts active ()
52	APP_STATUS_LEVEL	Application status level ID
53	APP_GDPR_CONSENT_STATUS	Application GDPR consent status
54	APP_GDPR_CONSENT_DATE	Application GDPR consent date
55	APP_GDPR_CONSENT_LAST_REQUESTED_DATE	Application GDPR consent last requested date
56	APP_GDPR_CONSENT_LOC_LAN	Application GDPR consent location language
57	APP_GDPR_DELETION_DATE	Application GDPR deletion date
58	APP_GDPR_CONSENT_LINK	Application GDPR consent link
59	APP_GDPR_FORGOTTEN	Application GDPR record forgotten ()

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
APPLICATION_PK	PK				APP_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
APPLICATION_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
APPLICATION_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
APPLICATION_COMPANY_USER_FK	COMPANY_USER	Y	Y	APP_USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
APP_LOCATION_APPLICATION_FK	APP_LOCATION	Y	Y	APP_ID	APP_ID
APPLICATION_CUSTOM_FIELDS_APPLICATION_FK	APPLICATION_CUSTOM_FIELDS	Y	Y	APP_ID	APP_ID
APPLICATION_LOOKUP_APPLICATION_FK	APPLICATION_LOOKUP	Y	Y	APP_ID	APP_ID
APPLICATION_MESSAGE_APPLICATION_FK	APPLICATION_MESSAGE	Y	Y	APP_ID	APP_ID
APPLICATION_MESSAGE_RECIPIENT_APPLICATION_FK	APPLICATION_MESSAGE_RECIPIENT	Y	Y	APP_ID	APP_ID
CANDIDATE_MILESTONE_APPLICATION_FK	CANDIDATE_MILESTONE	Y	Y	APP_ID	APP_ID
CANDIDATE_WORKFLOW_APPLICATION_FK	CANDIDATE_WORKFLOW	Y	Y	APP_ID	APP_ID
COMPLIANCE_APPLICATION_FK	COMPLIANCE	Y	Y	APP_ID	APP_ID
EDUCATION_APPLICATION_FK	EDUCATION	Y	Y	APP_ID	APP_ID
GDPR_APPLICATION_APPLICATION_FK	GDPR_APPLICATION	Y	Y	APP_ID	APP_ID
INTERVIEW_APPLICATION_FK	INTERVIEW	Y	Y	APP_ID	APP_ID
LOOKUP_EID_APPLICATION_APPLICATION_FK	LOOKUP_EID_APPLICATION	Y	Y	APP_ID	APP_ID
ONBOARDING_NEW_HIRE_APPLICATION_FK	ONBOARDING_NEW_HIRE	Y	Y	APP_ID	APP_ID
SCREENING_FORM_APPLICATION_FK	SCREENING_FORM	Y	Y	APP_ID	APP_ID
SCREENING_FORM_VERIFY_APPLICATION_FK	SCREENING_FORM_VERIFY	Y	Y	APP_ID	APP_ID
VIDEO_FORM_EVALUATION_APPLICATION_FK	VIDEO_FORM_EVALUATION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_EVALUATION_QUESTION_APPLICATION_FK	VIDEO_FORM_EVALUATION_QUESTION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_RESPONSE_APPLICATION_FK	VIDEO_FORM_RESPONSE	Y	Y	APP_ID	APP_ID
VIDEO_FORM_RESPONSE_QUESTION_APPLICATION_FK	VIDEO_FORM_RESPONSE_QUESTION	Y	Y	APP_ID	APP_ID
WORK_HISTORY_APPLICATION_FK	WORK_HISTORY	Y	Y	APP_ID	APP_ID
WORK_HISTORY_PROFILE_APPLICATION_FK	WORK_HISTORY_PROFILE	Y	Y	APP_ID	APP_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	APPROVER_ID	P		Y	BIGINT	LT
2	ITEM_ID		F	Y	BIGINT	LT
3	ITEM_KIND				BIGINT	LT
4	USER_ID				BIGINT	LT
5	COMPANY_ID		F	Y	BIGINT (38)	LT
6	APPROVER_STATUS				VARCHAR (100)	LT
7	APPROVER_SUBMITTED				Timestamp	LT
8	APPROVER_UPDATED				Timestamp	LT
9	APPROVER_TIME_TO_UPDATE				BIGINT	LT
10	APPROVER_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	APPROVER_ID	Approver ID (Approval ID)
2	ITEM_ID	Job ID
3	ITEM_KIND	Item Kind (always Job, in this context)
4	USER_ID	Approver User ID (COMPANY_USER.company_user_id)
5	COMPANY_ID	Approver Company ID
6	APPROVER_STATUS	Approver Status Read Retracted Rejected Skipped Initial Replaced Approved
7	APPROVER_SUBMITTED	Approval request sent date timestamp
8	APPROVER_UPDATED	Approver Updated Date
9	APPROVER_TIME_TO_UPDATE	Duration in days between Approver_Submitted and Approver_Updated
10	APPROVER_DELETED	Approver Deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
APPROVER_PK	PK				APPROVER_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
APPROVER_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
APPROVER_JOB_FK	JOB	Y	Y		ITEM_ID	JOB_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	CAMPAIGN_CONTACT_ID	P		Y	BIGINT	LT
2	CAMPAIGN_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	CAMPAIGN_CONTACT_STATUS				VARCHAR (50)	LT
5	CAMPAIGN_CONTACT_LAST_CONTACTED_DATE				Timestamp	LT
6	CAMPAIGN_CONTACT_UNSUBSCRIBED_DATE				Timestamp	LT
7	CONTACT_ID		F	Y	BIGINT	LT
8	CAMPAIGN_CONTACT_CREATED_DATE				Timestamp	LT
9	CAMPAIGN_CONTACT_UPDATED_DATE				Timestamp	LT
10	CAMPAIGN_CONTACT_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	CAMPAIGN_CONTACT_ID	Campaign and Contact ID unique identifier
2	CAMPAIGN_ID	Campaign ID
3	COMPANY_ID	Company ID
4	CAMPAIGN_CONTACT_STATUS	Campaign Contact Status
5	CAMPAIGN_CONTACT_LAST_CONTACTED_DATE	Contact last contacted date
6	CAMPAIGN_CONTACT_UNSUBSCRIBED_DATE	Contact Unsubscribed Date
7	CONTACT_ID	Contact ID
8	CAMPAIGN_CONTACT_CREATED_DATE	Contact added to campaign date
9	CAMPAIGN_CONTACT_UPDATED_DATE	Campaign contact record updated date
10	CAMPAIGN_CONTACT_DELETED	Campaign contact deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
CAMPAIGN_CONTACT_PK	PK				CAMPAIGN_CONTACT_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
CAMPAIGN_CONTACT_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
CAMPAIGN_CONTACT_CAMPAIGN_FK	CAMPAIGN	Y	Y	CAMPAIGN_ID	CAMPAIGN_ID
CAMPAIGN_CONTACT_CONTACT_FK	CONTACT	Y	Y	CONTACT_ID	CONTACT_ID

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

Description	This 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 Columns	17
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	APP_ID		F	Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	APP_PREV_WORKFLOW_STATE_ITEM_ID				BIGINT	LT
4	APP_PREV_WORKFLOW_STATE_DATE				Timestamp	LT
5	APP_PREV_WORKFLOW_STATE_NAME				VARCHAR (100)	LT
6	APP_NEXT_WORKFLOW_STATE_ITEM_ID				BIGINT	LT
7	APP_NEXT_WORKFLOW_STATE_DATE				Timestamp	LT
8	APP_NEXT_WORKFLOW_STATE_NAME				VARCHAR (100)	LT
9	APP_WORKFLOW_STATE_IN_DAYS				BIGINT	LT
10	APP_MODIFIED				Timestamp	LT
11	APP_PREV_WORKFLOW_STATE_POSITION				BIGINT	LT
12	APP_NEXT_WORKFLOW_STATE_POSITION				BIGINT	LT
13	APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID		F		BIGINT	LT
14	APP_WORKFLOW_ACTION_USER_FULL_NAME				VARCHAR (100)	LT
15	APP_WORKFLOW_ACTION_USER_EMAIL				VARCHAR (100)	LT
16	APP_WORKFLOW_WORKFLOW_ID	P		Y	BIGINT	LT
17	APP_WORKFLOW_STATE_IN_DAYS_NEXT_STATE				BIGINT	LT

Columns Comments

No	Column Name	Description
1	APP_ID	Application ID
2	COMPANY_ID	Company ID
3	APP_PREV_WORKFLOW_STATE_ITEM_ID	Application previous workflow state item ID
4	APP_PREV_WORKFLOW_STATE_DATE	Application previous workflow state date timestamp
5	APP_PREV_WORKFLOW_STATE_NAME	Application previous workflow state name
6	APP_NEXT_WORKFLOW_STATE_ITEM_ID	Application next workflow state item ID
7	APP_NEXT_WORKFLOW_STATE_DATE	Application next workflow state date timestamp
8	APP_NEXT_WORKFLOW_STATE_NAME	Application next workflow state name
9	APP_WORKFLOW_STATE_IN_DAYS	Application workflow previous state in days
10	APP_MODIFIED	Application last modified date timestamp
11	APP_PREV_WORKFLOW_STATE_POSITION	Application previous workflow state position
12	APP_NEXT_WORKFLOW_STATE_POSITION	Application next workflow state position
13	APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID	Application next workflow state action user ID (next step owner)
14	APP_WORKFLOW_ACTION_USER_FULL_NAME	Application workflow action user full name (Workflow actor) (COMPANY_USER.company_user_id)
15	APP_WORKFLOW_ACTION_USER_EMAIL	Application workflow action user email address (Workflow actor)
16	APP_WORKFLOW_WORKFLOW_ID	Application workflow ID
17	APP_WORKFLOW_STATE_IN_DAYS_NEXT_STATE	Application workflow next state in days (app_next_workflow_state_date to today)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
CANDIDATE_WORKFLOW_PK	PK				APP_WORKFLOW_WORKFLOW_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
CANDIDATE_WORKFLOW_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
CANDIDATE_WORKFLOW_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
CANDIDATE_WORKFLOW_COMPANY_USER_FK	COMPANY_USER		Y	APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID	USER_ID

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

Description
Notes

Number Of Columns	42
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	USER_ID	P		Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	USER_FIRST_NAME				VARCHAR (100)	LT
4	USER_LAST_NAME				VARCHAR (100)	LT
5	USER_FULL_NAME				VARCHAR (210)	LT
6	USER_EMAIL				VARCHAR (100)	LT
7	USER_TITLE				VARCHAR (100)	LT
8	USER_ADDRESS				VARCHAR (100)	LT
9	USER_CITY				VARCHAR (50)	LT
10	USER_POSTALCODE				VARCHAR (20)	LT
11	USER_STATE				VARCHAR (100)	LT
12	USER_ROLE				VARCHAR (200)	LT
13	USER_CREATED				Timestamp	LT
14	USER_HOMEPHONE				VARCHAR (20)	LT
15	USER_WORKPHONE				VARCHAR (20)	LT
16	USER_MOBILE				VARCHAR (20)	LT
17	USER_IS_EMPLOYEE				Boolean	LT
18	USER_COUNTRY				VARCHAR (50)	LT
19	USER_DISABLED				Boolean	LT
20	USER_ZIP				VARCHAR (20)	LT
21	USER_DEPARTMENT				VARCHAR (50)	LT
22	USER_LOCATION				VARCHAR (50)	LT
23	USER_MODIFIED				Timestamp	LT
24	USER_LAST_LOGGED_IN				Timestamp	LT
25	USER_INVITATION_STATUS				VARCHAR (100)	LT
26	USER_INVITATION_SENT_DATE				Timestamp	LT
27	USER_INVITATION_ACCEPTED_DATE				Timestamp	LT
28	USER_INVITATION_COMPANY_ID				BIGINT	LT
29	USER_PUBLISHER_STATUS				Boolean	LT
30	USER_ACTIVE				Boolean	LT
31	USER_EMPLOYEE_ID				VARCHAR (40)	LT
32	USER_LANGUAGE				VARCHAR (150)	LT
33	USER_MANAGER_ID				BIGINT	LT
34	USER_FACEBOOK_REQUIRES_REAUTHENTICATION				Boolean	LT
35	USER_FACEBOOK_REQUIRES_CONNECTION				Boolean	LT
36	USER_LINKEDIN_REQUIRES_REAUTHENTICATION				Boolean	LT
37	USER_LINKEDIN_REQUIRES_CONNECTION				Boolean	LT
38	USER_TWITTER_REQUIRES_REAUTHENTICATION				Boolean	LT
39	USER_TWITTER_REQUIRES_CONNECTION				Boolean	LT
40	USER_FACEBOOK_REQUIRES_STATUS_UPDATE_ENABLE				Boolean	LT
41	USER_LINKEDIN_REQUIRES_STATUS_UPDATE_ENABLE				Boolean	LT
42	USER_TWITTER_REQUIRES_STATUS_UPDATE_ENABLE				Boolean	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID
2	COMPANY_ID	Company ID
3	USER_FIRST_NAME	User first name
4	USER_LAST_NAME	User last name
5	USER_FULL_NAME	User full name
6	USER_EMAIL	User email address
7	USER_TITLE	User title
8	USER_ADDRESS	User address
9	USER_CITY	User city
10	USER_POSTALCODE	User postal code
11	USER_STATE	User state
12	USER_ROLE	User role
13	USER_CREATED	User created date timestamp
14	USER_HOMEPHONE	User home phone number
15	USER_WORKPHONE	User workphone number
16	USER_MOBILE	User mobile phone number
17	USER_IS_EMPLOYEE	User is employee flag - used to differentiate candidates from employee users (TRUE/FALSE)
18	USER_COUNTRY	User country
19	USER_DISABLED	User disabled flag - no longer active (TRUE/FALSE)
20	USER_ZIP	User zip code
21	USER_DEPARTMENT	User department
22	USER_LOCATION	User location
23	USER_MODIFIED	User last modified date timestamp
25	USER_INVITATION_STATUS	User invitation status
26	USER_INVITATION_SENT_DATE	User invitation sent date
27	USER_INVITATION_ACCEPTED_DATE	User invitation accepted date
28	USER_INVITATION_COMPANY_ID	User invitation company ID
29	USER_PUBLISHER_STATUS	User publisher status
30	USER_ACTIVE	User active (TRUE/FALSE)
31	USER_EMPLOYEE_ID	User employee ID
32	USER_LANGUAGE	User default language
33	USER_MANAGER_ID	User manager ID
34	USER_FACEBOOK_REQUIRES_REAUTHENTICATION	User - Facebook requires re-authentication (TRUE/FALSE)
35	USER_FACEBOOK_REQUIRES_CONNECTION	User - Facebook requires connection (TRUE/FALSE)
36	USER_LINKEDIN_REQUIRES_REAUTHENTICATION	User - LinkedIn requires re-authentication (TRUE/FALSE)
37	USER_LINKEDIN_REQUIRES_CONNECTION	User - LinkedIn requires connection (TRUE/FALSE)
38	USER_TWITTER_REQUIRES_REAUTHENTICATION	User - Twitter requires re-authentication (TRUE/FALSE)
39	USER_TWITTER_REQUIRES_CONNECTION	User - Twitter requires connection (TRUE/FALSE)
40	USER_FACEBOOK_REQUIRES_STATUS_UPDATE_ENABLE	User - Facebook requires status updated enabled (TRUE/FALSE)
41	USER_LINKEDIN_REQUIRES_STATUS_UPDATE_ENABLE	User - LinkedIn requires status updated enabled (TRUE/FALSE)
42	USER_TWITTER_REQUIRES_STATUS_UPDATE_ENABLE	User - Twitter requires status updated enabled (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
COMPANY_USER_PK	PK				USER_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
COMPANY_USER_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
AGENCY_JOB_COMPANY_USER_FK	AGENCY_JOB	Y	Y	USER_ID	USER_ID
AGENCY_USER_COMPANY_USER_FK	AGENCY_USER	Y	Y	AGENCY_USER_ID	USER_ID
APPLICATION_COMPANY_USER_FK	APPLICATION	Y	Y	APP_USER_ID	USER_ID
APPLICATION_MESSAGE_COMPANY_USER_FK	APPLICATION_MESSAGE	Y	Y	USER_ID	USER_ID
CAMPAIGN_COMPANY_USER_FK	CAMPAIGN	Y	Y	USER_ID	USER_ID
CANDIDATE_WORKFLOW_COMPANY_USER_FK	CANDIDATE_WORKFLOW		Y	APP_NEXT_WORKFLOW_STATE_ACTION_USER_ID	USER_ID
COMPANY_USER_CUSTOM_FIELDS_COMPANY_USER_FK	COMPANY_USER_CUSTOM_FIELDS	Y	Y	USER_ID	USER_ID
COMPANY_USER_ROLES_COMPANY_USER_FK	COMPANY_USER_ROLES	Y	Y	USER_ID	USER_ID
CONTACT_COMPANY_USER_FK	CONTACT	Y	Y	USER_ID	USER_ID
CONTACT_STATUS_HISTORY_COMPANY_USER_FK	CONTACT_STATUS_HISTORY	Y	Y	USER_ID	USER_ID
GDPR_ONBOARDING_ENTITY_COMPANY_USER_FK	GDPR_ONBOARDING_ENTITY	Y	Y	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID	USER_ID
INTERVIEW_COMPANY_USER_FK	INTERVIEW	Y	Y	USER_ID	USER_ID
JOB_MESSAGE_COMPANY_USER_FK	JOB_MESSAGE	Y	Y	USER_ID	USER_ID
JOB_OWNER_APPROVER_COMPANY_USER_FK	JOB_OWNER_APPROVER	Y	Y	USER_ID	USER_ID
JOB_OWNER_COMPANY_USER_FK	JOB_OWNER	Y	Y	USER_ID	USER_ID
OFCCP_SEARCH_COMPANY_USER_FK	OFCCP_SEARCH	Y	Y	USER_ID	USER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FK	ONBOARDING_NEW_HIRE	Y	Y	ONB_NEW_HIRE_CREATED_BY_USER_ID	USER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv1	ONBOARDING_NEW_HIRE	Y	Y	ONB_NEW_HIRE_HIRING_MANAGER_USER_ID	USER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv2	ONBOARDING_NEW_HIRE	Y	Y	ONB_NEW_HIRE_MODIFIED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_COMPANY_USER_FK	ONBOARDING_PROCESS	Y	Y	ONB_PROCESS_MODIFIED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv1	ONBOARDING_PROCESS	Y	Y	ONB_PROCESS_CREATED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv2	ONBOARDING_PROCESS	Y	Y	ONB_HIRING_MANAGER_USER_ID	USER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FK	ONBOARDING_PROCESS_TEMPLATE	Y	Y	ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKv1	ONBOARDING_PROCESS_TEMPLATE	Y	Y	ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID	USER_ID
ONBOARDING_TASK_COMPANY_USER_FK	ONBOARDING_TASK	Y	Y	ONB_TASK_ASSIGNEE_USER_ID	USER_ID
ONBOARDING_TASK_COMPANY_USER_FKv1	ONBOARDING_TASK	Y	Y	ONB_TASK_CREATED_BY_USER_ID	USER_ID
ONBOARDING_TASK_COMPANY_USER_FKv2	ONBOARDING_TASK	Y	Y	ONB_TASK_MODIFIED_BY_USER_ID	USER_ID
REQUISITION_ACCESS_COMPANY_USER_FK	REQUISITION_ACCESS	Y	Y	USER_ID	USER_ID
SOURCE_DATA_COMPANY_USER_FK	SOURCE_DATA	Y	Y	USER_ID	USER_ID
USER_ACTIVITY_COMPANY_USER_FK	USER_ACTIVITY	Y	Y	USER_ID	USER_ID
USER_ASSIGNED_JOB_ID_TO_JOB_CAT_COMPANY_USER_FK	USER_ASSIGNED_JOB_ID_TO_JOB_CAT	Y	Y	USER_ID	USER_ID
USER_JOBVITE_ACTIVITY_COMPANY_USER_FK	USER_JOBVITE_ACTIVITY	Y	Y	USER_ID	USER_ID
VIDEO_FORM_EVALUATION_COMPANY_USER_FK	VIDEO_FORM_EVALUATION	Y	Y	USER_ID	USER_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_USER_FK	VIDEO_FORM_EVALUATION_QUESTION	Y	Y	USER_ID	USER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FK	VIDEO_FORM_RESPONSE	Y	Y	SENT_BY_USER_ID	USER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKv1	VIDEO_FORM_RESPONSE		Y	INTERVIEWEE_USER_ID	USER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FK	VIDEO_FORM_RESPONSE_QUESTION		Y	INTERVIEWEE_USER_ID	USER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKv1	VIDEO_FORM_RESPONSE_QUESTION	Y	Y	SENT_BY_USER_ID	USER_ID
VIDEO_QUESTION_COMPANY_USER_FK	VIDEO_QUESTION	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	40
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	COMPLIANCE_ID	P		Y	BIGINT	LT
2	APP_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	COMPLIANCE_PREOFFER_GENDER				VARCHAR (30)	LT
5	COMPLIANCE_POSTOFFER_GENDER				VARCHAR (30)	LT
6	COMPLIANCE_PREOFFER_ETHNICITY				VARCHAR (30)	LT
7	COMPLIANCE_POSTOFFER_ETHNICITY				VARCHAR (30)	LT
8	COMPLIANCE_PREOFFER_EEOFORM_FULLNAME				VARCHAR (100)	LT
9	COMPLIANCE_POSTOFFER_EEOFORM_FULLNAME				VARCHAR (100)	LT
10	COMPLIANCE_PREOFFER_EEOFORM_SUBMITDATE				Timestamp	LT
11	COMPLIANCE_POSTOFFER_EEOFORM_SUBMITDATE				Timestamp	LT
12	COMPLIANCE_PREOFFER_RACE				VARCHAR (30)	LT
13	COMPLIANCE_POSTOFFER_RACE				VARCHAR (30)	LT
14	COMPLIANCE_POSTOFFER_DISABLEDVETERAN				Boolean	LT
15	COMPLIANCE_POSTOFFER_RECENTLYSEPERATED				Boolean	LT
16	COMPLIANCE_POSTOFFER_ARMEDFORCESSERVICEMEDALVETERAN				Boolean	LT
17	COMPLIANCE_PREOFFER_PROTECTEDVETERAN				Boolean	LT
18	COMPLIANCE_POSTOFFER_PROTECTEDVETERAN				Boolean	LT
19	COMPLIANCE_PREOFFER_NOTPROTECTEDVETERAN				Boolean	LT
20	COMPLIANCE_POSTOFFER_NOTPROTECTEDVETERAN				Boolean	LT
21	COMPLIANCE_POSTOFFER_ACTIVEWARTIMEORCAMPAIGNBADGEVETERAN				Boolean	LT
22	COMPLIANCE_PREOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS				Boolean	LT
23	COMPLIANCE_POSTOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS				Boolean	LT
24	COMPLIANCE_PREOFFER_VETERANFORM_FULLNAME				VARCHAR (100)	LT
25	COMPLIANCE_POSTOFFER_VETERANFORM_FULLNAME				VARCHAR (100)	LT
26	COMPLIANCE_PREOFFER_VETERANFORM_SUBMITDATE				Timestamp	LT
27	COMPLIANCE_POSTOFFER_VETERANFORM_SUBMITDATE				Timestamp	LT
28	COMPLIANCE_PREOFFER_DISABILITYSTATUS				VARCHAR (20)	LT
29	COMPLIANCE_POSTOFFER_DISABILITYSTATUS				VARCHAR (20)	LT
30	COMPLIANCE_PREOFFER_DISABILITYFORM_FULLNAME				VARCHAR (100)	LT
31	COMPLIANCE_POSTOFFER_DISABILITYFORM_FULLNAME				VARCHAR (100)	LT
32	COMPLIANCE_PREOFFER_DISABILITYFORM_SUBMITDATE				Timestamp	LT
33	COMPLIANCE_POSTOFFER_DISABILITYFORM_SUBMITDATE				Timestamp	LT
34	COMPLIANCE_PREOFFER_FORM_SENT_DATE				Timestamp	LT
35	COMPLIANCE_PREOFFER_FORM_STATUS				VARCHAR (10)	LT
36	COMPLIANCE_POSTOFFER_FORM_SENT_DATE				Timestamp	LT
37	COMPLIANCE_POSTOFFER_FORM_STATUS				VARCHAR (10)	LT
38	COMPLIANCE_UPDATEDATE				Timestamp	LT
39	COMPLIANCE_PREOFFER_FORM_COMPLETED_DATE				Timestamp	LT
40	COMPLIANCE_POSTOFFER_FORM_COMPLETED_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	COMPLIANCE_ID	Compliance record ID
2	APP_ID	Application ID
3	COMPANY_ID	Company ID
4	COMPLIANCE_PREOFFER_GENDER	Preoffer Gender
5	COMPLIANCE_POSTOFFER_GENDER	Post offer Gender
6	COMPLIANCE_PREOFFER_ETHNICITY	Preoffer Ethnicity
7	COMPLIANCE_POSTOFFER_ETHNICITY	Post offer Ethnicity
8	COMPLIANCE_PREOFFER_EEOFORM_FULLNAME	Preoffer EEO Form full name
9	COMPLIANCE_POSTOFFER_EEOFORM_FULLNAME	Post offer EEO Form full name
10	COMPLIANCE_PREOFFER_EEOFORM_SUBMITDATE	Preoffer EEO Form submitted date
11	COMPLIANCE_POSTOFFER_EEOFORM_SUBMITDATE	Post offer EEO Form submitted date
12	COMPLIANCE_PREOFFER_RACE	Pre offer Race
13	COMPLIANCE_POSTOFFER_RACE	Post offer Race
14	COMPLIANCE_POSTOFFER_DISABLEDVETERAN	Post offer Disabled Veteran status (TRUE/FALSE)
15	COMPLIANCE_POSTOFFER_RECENTLYSEPERATED	Post offer Recently Separated Veteran status (TRUE/FALSE)
16	COMPLIANCE_POSTOFFER_ARMEDFORCESSERVICEMEDALVETERAN	Post offer Armed Forces Service Medal Veteran status (TRUE/FALSE)
17	COMPLIANCE_PREOFFER_PROTECTEDVETERAN	Preoffer Protected Veteran status (TRUE/FALSE)
18	COMPLIANCE_POSTOFFER_PROTECTEDVETERAN	Post offer Protected Veteran status (TRUE/FALSE)
19	COMPLIANCE_PREOFFER_NOTPROTECTEDVETERAN	Preoffer Not a Protected Veteran status (TRUE/FALSE)
20	COMPLIANCE_POSTOFFER_NOTPROTECTEDVETERAN	Post offer Not a Protected Veteran status (TRUE/FALSE)
21	COMPLIANCE_POSTOFFER_ACTIVEWARTIMEORCAMPAIGNBADGEVETERAN	Post offer Active Wartime or Campaign Veteran status (TRUE/FALSE)
22	COMPLIANCE_PREOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS	Preoffer decline to self identify Veteran status (TRUE/FALSE)
23	COMPLIANCE_POSTOFFER_DECLINETOSELFIDENTIFYVETERANSTATUS	Post offer decline to self identify Veteran status (TRUE/FALSE)
24	COMPLIANCE_PREOFFER_VETERANFORM_FULLNAME	Preoffer Veteran Form full name
25	COMPLIANCE_POSTOFFER_VETERANFORM_FULLNAME	Post offer Veteran Form full name
26	COMPLIANCE_PREOFFER_VETERANFORM_SUBMITDATE	Preoffer Veteran Form submit date
27	COMPLIANCE_POSTOFFER_VETERANFORM_SUBMITDATE	Post offer Veteran Form submit date
28	COMPLIANCE_PREOFFER_DISABILITYSTATUS	Preoffer disability status
29	COMPLIANCE_POSTOFFER_DISABILITYSTATUS	Post offer disability status
30	COMPLIANCE_PREOFFER_DISABILITYFORM_FULLNAME	Preoffer disability form full name
31	COMPLIANCE_POSTOFFER_DISABILITYFORM_FULLNAME	Post offer disability form full name
32	COMPLIANCE_PREOFFER_DISABILITYFORM_SUBMITDATE	Preoffer disability form submitted date
33	COMPLIANCE_POSTOFFER_DISABILITYFORM_SUBMITDATE	Post offer disability form submitted date
34	COMPLIANCE_PREOFFER_FORM_SENT_DATE	Preoffer form sent date
35	COMPLIANCE_PREOFFER_FORM_STATUS	Preoffer form status
36	COMPLIANCE_POSTOFFER_FORM_SENT_DATE	Post offer form sent date
37	COMPLIANCE_POSTOFFER_FORM_STATUS	Post offer form status
38	COMPLIANCE_UPDATEDATE	Compliance record last updated date
39	COMPLIANCE_PREOFFER_FORM_COMPLETED_DATE	Preoffer form completed date
40	COMPLIANCE_POSTOFFER_FORM_COMPLETED_DATE	Postoffer form completed date

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
COMPLIANCE_PK	PK				COMPLIANCE_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
COMPLIANCE_APPLICATION_FK	APPLICATION	Y	Y		APP_ID	APP_ID
COMPLIANCE_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	53
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	CONTACT_ID	P		Y	BIGINT	LT
2	USER_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	CONTACT_CREATED_DATE				Timestamp	LT
5	CONTACT_MODIFIED_DATE				Timestamp	LT
6	CONTACT_FIRST_NAME				VARCHAR (100)	LT
7	CONTACT_LAST_NAME				VARCHAR (100)	LT
8	CONTACT_MIDDLE_NAME				VARCHAR (100)	LT
9	CONTACT_FULL_NAME				VARCHAR (200)	LT
10	CONTACT_JOB_TITLE				VARCHAR (100)	LT
11	CONTACT_COMPANY_NAME				VARCHAR (100)	LT
12	CONTACT_DEPARTMENT_NAME				VARCHAR (100)	LT
13	CONTACT_SOURCE_NAME				VARCHAR (100)	LT
14	CONTACT_GENDER				VARCHAR (20)	LT
15	CONTACT_RACE				VARCHAR (20)	LT
16	CONTACT_STATUS_ID				BIGINT	LT
17	CONTACT_STATUS				VARCHAR (50)	LT
18	CONTACT_ASSIGNED_TO				BIGINT	LT
19	CONTACT_ADDRESS1				VARCHAR (100)	LT
20	CONTACT_ADDRESS2				VARCHAR (50)	LT
21	CONTACT_ADDRESS3				VARCHAR (50)	LT
22	CONTACT_CITY				VARCHAR (50)	LT
23	CONTACT_STATE				VARCHAR (50)	LT
24	CONTACT_ZIP				VARCHAR (10)	LT
25	CONTACT_COUNTRY				VARCHAR (50)	LT
26	CONTACT_EMAIL_STATUS				VARCHAR (50)	LT
27	CONTACT_TAGS				VARCHAR (65535)	LT
28	CONTACT_NOTES				VARCHAR (65535)	LT
29	CONTACT_ADDRESS_NOTES				VARCHAR (100)	LT
30	CONTACT_ADDRESS_TYPE				VARCHAR (50)	LT
31	CONTACT_PRIMARY_PHONE				VARCHAR (20)	LT
32	CONTACT_PRIMARY_EMAIL				VARCHAR (50)	LT
33	CONTACT_CUSTOM_DATA				VARCHAR (65535)	LT
34	CONTACT_SOCIAL_NETWORK_URLS				VARCHAR (200)	LT
35	CONTACT_WEBSITES				VARCHAR (200)	LT
36	CONTACT_NOTES_LAST_UPDATED				Timestamp	LT
37	CONTACT_NOTES_LAST_UPDATED_BY				BIGINT	LT
38	CONTACT_DELETED				Boolean	LT
39	CONTACT_SOURCE_TYPE_ID				BIGINT	LT
40	CONTACT_SOURCE_TYPE				VARCHAR (128)	LT
41	CANDIDATE_ID				BIGINT	LT
42	CONTACT_JOB_ALERTS_SUBSCRIBED				Boolean	LT
43	CONTACT_JOB_ALERTS_ACTIVE				Boolean	LT
44	CONTACT_GDPR_CONSENT_DATE				Timestamp	LT
45	CONTACT_GDPR_CONSENT_LAST_REQUESTED_DATE				Timestamp	LT
46	CONTACT_GDPR_CONSENT_LOC_LAN				VARCHAR (100)	LT
47	CONTACT_GDPR_DELETION_DATE				Timestamp	LT
48	CONTACT_GDPR_CONSENT_LINK				VARCHAR (255)	LT
49	CONTACT_GDPR_FORGOTTEN				Boolean	LT
50	CONTACT_GDPR_CONSENT_STATUS				VARCHAR (100)	LT
51	CONTACT_EID				VARCHAR (50)	LT
52	COMPANY_DOUBLE_EID				VARCHAR (100)	LT
53	CONTACT_CONSENT_URL				VARCHAR (500)	LT

Columns Comments

No	Column Name	Description
1	CONTACT_ID	Contact ID
2	USER_ID	User ID
3	COMPANY_ID	Company ID
4	CONTACT_CREATED_DATE	Contact created date timestamp
5	CONTACT_MODIFIED_DATE	Contact last modified date timestamp
6	CONTACT_FIRST_NAME	Contact first name
7	CONTACT_LAST_NAME	Contact last name
8	CONTACT_MIDDLE_NAME	Contact middle name
9	CONTACT_FULL_NAME	Contact full name
10	CONTACT_JOB_TITLE	Contact job title
11	CONTACT_COMPANY_NAME	Contact company name
12	CONTACT_DEPARTMENT_NAME	Contact department name
13	CONTACT_SOURCE_NAME	Contact source name
14	CONTACT_GENDER	Contact gender
15	CONTACT_RACE	Contact race
16	CONTACT_STATUS_ID	Contact status ID
17	CONTACT_STATUS	Contact Status Alumni Available Candidate Contacted Do Not Contact Do Not Hire Employy Future New Newly Hired Not Interested Warm
18	CONTACT_ASSIGNED_TO	Contact assigned to user (Contact ID)
19	CONTACT_ADDRESS1	Contact address line 1
20	CONTACT_ADDRESS2	Contact address line 2
21	CONTACT_ADDRESS3	Contact address line 3
22	CONTACT_CITY	Contact city
23	CONTACT_STATE	Contact state
24	CONTACT_ZIP	Contact zip code
25	CONTACT_COUNTRY	Contact country
26	CONTACT_EMAIL_STATUS	Contact email status Has not opted out Opted out Limited Bounced
27	CONTACT_TAGS	Contact Tags
28	CONTACT_NOTES	Contact notes
29	CONTACT_ADDRESS_NOTES	Contact address notes
30	CONTACT_ADDRESS_TYPE	Contact address type
31	CONTACT_PRIMARY_PHONE	Contact primary phone number
32	CONTACT_PRIMARY_EMAIL	Contact primary email address
33	CONTACT_CUSTOM_DATA	Contact custom data
34	CONTACT_SOCIAL_NETWORK_URLS	Contact social network URLs
35	CONTACT_WEBSITES	Contact websites
36	CONTACT_NOTES_LAST_UPDATED	Contact notes last updated date timestamp
37	CONTACT_NOTES_LAST_UPDATED_BY	Contact notes last update by (UserID)
38	CONTACT_DELETED	Contact deleted (TRUE/FALSE)
39	CONTACT_SOURCE_TYPE_ID	Contact source type ID
40	CONTACT_SOURCE_TYPE	Contact source type Agency Campaing Career Site Email Employee Hiring Manager Import Internal Internal Transfer Job Board Job Notification Recruiter Resume Search Web Search
41	CANDIDATE_ID	Candidate ID
42	CONTACT_JOB_ALERTS_SUBSCRIBED	Contact is subscribed to job alerts (TRUE/FALSE)
43	CONTACT_JOB_ALERTS_ACTIVE	Contact signed up for active job alerts (TRUE/FALSE)
44	CONTACT_GDPR_CONSENT_DATE	Contact GDPR consent given date timestamp
45	CONTACT_GDPR_CONSENT_LAST_REQUESTED_DATE	Contact GDPR last consent requested date timestamp
46	CONTACT_GDPR_CONSENT_LOC_LAN	Contact GDPR consent location language
47	CONTACT_GDPR_DELETION_DATE	Contact GDPR deletion date
48	CONTACT_GDPR_CONSENT_LINK	Contact GDPR consent link
49	CONTACT_GDPR_FORGOTTEN	Contact GDPR forgotten (TRUE/FALSE)
50	CONTACT_GDPR_CONSENT_STATUS	Contact GDPR Consent status Not requested Requested Consented Declined
51	CONTACT_EID	Contact encrypted ID
52	COMPANY_DOUBLE_EID	Contact double encrypted ID
53	CONTACT_CONSENT_URL	Contact consent URL

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
CONTACT_PK	PK				CONTACT_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
CONTACT_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
CONTACT_COMPANY_USER_FK	COMPANY_USER	Y	Y		USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
CAMPAIGN_CONTACT_CONTACT_FK	CAMPAIGN_CONTACT	Y	Y	CONTACT_ID	CONTACT_ID
CONTACT_CUSTOM_FIELDS_CONTACT_FK	CONTACT_CUSTOM_FIELDS	Y	Y	CONTACT_ID	CONTACT_ID
CONTACT_STATUS_HISTORY_CONTACT_FK	CONTACT_STATUS_HISTORY	Y	Y	CONTACT_ID	CONTACT_ID
CONTACT_URL_CONTACT_FK	CONTACT_URL	Y	Y	CONTACT_ID	CONTACT_ID
EMAIL_CAMPAIGN_CONTACT_CONTACT_FK	EMAIL_CAMPAIGN_CONTACT	Y	Y	CONTACT_ID	CONTACT_ID
GDPR_CONTACT_CONTACT_FK	GDPR_CONTACT	Y	Y	CONTACT_ID	CONTACT_ID
LOOKUP_EID_CONTACT_CONTACT_FK	LOOKUP_EID_CONTACT	Y	Y	CONTACT_ID	CONTACT_ID
LOOKUP_EID_DOUBLE_ENCRYPTED_CONTACT_CONTACT_FK	LOOKUP_EID_DOUBLE_ENCRYPTED_CONTACT	Y	Y	CONTACT_ID	CONTACT_ID

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

Description
Notes

Number Of Columns	13
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	CONTACT_STATUS_HISTORY_ID	P		Y	BIGINT	LT
2	USER_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	CONTACT_ID		F	Y	BIGINT	LT
5	CONTACT_STATUS_HISTORY_CREATED_DATE				Timestamp	LT
6	CONTACT_STATUS_HISTORY_MODIFIED_DATE				Timestamp	LT
7	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_ID				BIGINT	LT
8	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS				VARCHAR (50)	LT
9	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_DATE				Timestamp	LT
10	CONTACT_STATUS_HISTORY_NEXT_STATUS_ID				BIGINT	LT
11	CONTACT_STATUS_HISTORY_NEXT_STATUS				VARCHAR (50)	LT
12	CONTACT_STATUS_HISTORY_NEXT_STATUS_DATE				Timestamp	LT
13	CONTACT_STATUS_HISTORY_STATUS_IN_DAYS				BIGINT	LT

Columns Comments

No	Column Name	Description
1	CONTACT_STATUS_HISTORY_ID	Contact status history record ID
2	USER_ID	User ID
3	COMPANY_ID	Company ID
4	CONTACT_ID	Contact ID
5	CONTACT_STATUS_HISTORY_CREATED_DATE	Contact status history record created date timestamp
6	CONTACT_STATUS_HISTORY_MODIFIED_DATE	Contact status history record last modified date timestamp
7	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_ID	Contact previous status record ID
8	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS	Contact previous status
9	CONTACT_STATUS_HISTORY_PREVIOUS_STATUS_DATE	Contact previous status start date timestamp
10	CONTACT_STATUS_HISTORY_NEXT_STATUS_ID	Contact next status record ID
11	CONTACT_STATUS_HISTORY_NEXT_STATUS	Contact next status
12	CONTACT_STATUS_HISTORY_NEXT_STATUS_DATE	Contact next status start date timestamp
13	CONTACT_STATUS_HISTORY_STATUS_IN_DAYS	Contact history status in days (Previous status date to next status date)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
CONTACT_STATUS_HISTORY_PK	PK				CONTACT_STATUS_HISTORY_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
CONTACT_STATUS_HISTORY_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
CONTACT_STATUS_HISTORY_CONTACT_FK	CONTACT	Y	Y	CONTACT_ID	CONTACT_ID
CONTACT_STATUS_HISTORY_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	APP_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	CANDIDATE_ID			BIGINT	LT
4	EDUCATION_COLLEGE_NAME			VARCHAR (200)	LT
5	EDUCATION_DEGREE_NAME			VARCHAR (200)	LT
6	EDUCATION_MAJOR			VARCHAR (200)	LT
7	EDUCATION_DEGREE_TYPE			VARCHAR (50)	LT
8	EDUCATION_START_DATE			VARCHAR (20)	LT
9	EDUCATION_END_DATE			VARCHAR (20)	LT
10	EDUCATION_MODIFIED_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	APP_ID	Application ID
2	COMPANY_ID	Company ID
3	CANDIDATE_ID	Candidate ID
4	EDUCATION_COLLEGE_NAME	Education College name
5	EDUCATION_DEGREE_NAME	Education degree name
6	EDUCATION_MAJOR	Education major
7	EDUCATION_DEGREE_TYPE	Education Degree type
8	EDUCATION_START_DATE	Education start date
9	EDUCATION_END_DATE	Education end date
10	EDUCATION_MODIFIED_DATE	Education record last modified date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
EDUCATION_APPLICATION_FK	APPLICATION	Y	Y		APP_ID	APP_ID
EDUCATION_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	2
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind	Domain Name	Formula (Default Value)	Security	Abbreviation
1	USER_ID	P		Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT

Columns Comments

No	Column Name	Description	Notes
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ENGAGE_USER_PK	PK				USER_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ENGAGE_USER_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_CONTACT_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_CONTACT	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_CONTACT_STATUS_HISTORY_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_CONTACT_STATUS_HISTORY	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_JOB_MESSAGE_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_JOB_MESSAGE	Y	Y	USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_TASK_ENGAGE_USER_FK	ENGAGE_USER_ACTIVITY_TASK	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	41
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	USER_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	USER_ACTIVITY_DATE			Timestamp	LT
4	USER_MESSAGES_SENT_TO_CONTACTS			BIGINT	LT
5	USER_SHARE_CONTACT_COUNT			BIGINT	LT
6	USER_REQUISITION_COUNT			BIGINT	LT
7	USER_ASSIGNED_CONTACTS			BIGINT	LT
8	USER_CONTACTS_ADDED			BIGINT	LT
9	USER_ACTIVE_EMAIL_CAMPAIGNS			BIGINT	LT
10	USER_ACTIVE_SOCIAL_CAMPAIGNS			BIGINT	LT
11	USER_ACTIVE_WEBPAGE_CAMPAIGNS			BIGINT	LT
12	USER_CONTACTS_MOVED			BIGINT	LT
13	USER_SOCIAL_CAMPAIGN_MESSAGES_SENT			BIGINT	LT
14	USER_EMAIL_CAMPAIGN_MESSAGES_SENT			BIGINT	LT
15	USER_TASK_CREATED			BIGINT	LT
16	USER_TASK_COMPLETED			BIGINT	LT
17	USER_TASK_INCOMPLETE			BIGINT	LT
18	USER_TASK_OVERDUE			BIGINT	LT
19	USER_JOBVITE_RECEIVE			BIGINT	LT
20	USER_JOBVITE_SEND			BIGINT	LT
21	USER_JOBVITE_BROADCAST			BIGINT	LT
22	USER_JOBVITE_VIEW			BIGINT	LT
23	USER_JOBVITE_CLICK_TO_APPLY			BIGINT	LT
24	USER_JOBVITE_FORWARD			BIGINT	LT
25	USER_JOBVITE_APPLY			BIGINT	LT
26	USER_JOBVITE_HIRE			BIGINT	LT
27	USER_JOBVITE_EMAIL_DIRECT			BIGINT	LT
28	USER_JOBVITE_LINKEDIN_DIRECT			BIGINT	LT
29	USER_JOBVITE_LINKEDIN_BROADCAST			BIGINT	LT
30	USER_JOBVITE_FACEBOOK_BROADCAST			BIGINT	LT
31	USER_JOBVITE_TWITTER_BROADCAST			BIGINT	LT
32	USER_JOBVITE_JOBLINK_BROADCAST			BIGINT	LT
33	USER_CANDIDATES_ADDED			BIGINT	LT
34	USER_CONTACTS_MOVED_CONTACTED			BIGINT	LT
35	USER_CONTACTS_MOVED_HIRED			BIGINT	LT
36	USER_ACTIVE_CAMPAIGNS			BIGINT	LT
37	USER_PUBLISHER_STATUS			Boolean	LT
38	USER_CONTACTS_EVER_MOVED_CANDIDATE_STATUS			BIGINT	LT
39	USER_CONTACTS_EVER_MOVED_CONTACTED_STATUS			BIGINT	LT
40	USER_CONTACTS_EVER_MOVED_HIRED_STATUS			BIGINT	LT
41	USER_NOTES_ADDED			BIGINT	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID
3	USER_ACTIVITY_DATE	User activity date timestamp
4	USER_MESSAGES_SENT_TO_CONTACTS	Number of messages sent to contacts
5	USER_SHARE_CONTACT_COUNT	Share contact count
6	USER_REQUISITION_COUNT	Requisition count
7	USER_ASSIGNED_CONTACTS	Number of assigned contacts
8	USER_CONTACTS_ADDED	Number of contacts added
9	USER_ACTIVE_EMAIL_CAMPAIGNS	Number of active email campaigns
10	USER_ACTIVE_SOCIAL_CAMPAIGNS	Number of active social campaigns
11	USER_ACTIVE_WEBPAGE_CAMPAIGNS	Number of active webpage campaigns
12	USER_CONTACTS_MOVED	Number of contacts moved
13	USER_SOCIAL_CAMPAIGN_MESSAGES_SENT	Number of social campaign messages sent
14	USER_EMAIL_CAMPAIGN_MESSAGES_SENT	Number of email campaign messages sent
15	USER_TASK_CREATED	Number of tasks created
16	USER_TASK_COMPLETED	Number of tasks completed
17	USER_TASK_INCOMPLETE	Number of incomplete tasks
18	USER_TASK_OVERDUE	Number of overdue tasks
19	USER_JOBVITE_RECEIVE	Number of Jobvites received
20	USER_JOBVITE_SEND	Number of Jobvites sent
21	USER_JOBVITE_BROADCAST	Number of Jobvites broadcasted
22	USER_JOBVITE_VIEW	Number of Jobvites viewed
23	USER_JOBVITE_CLICK_TO_APPLY	Number of Jobvite apply clicks
24	USER_JOBVITE_FORWARD	Number of Jobvites forwarded
25	USER_JOBVITE_APPLY	Number of Jobvite applies
26	USER_JOBVITE_HIRE	Number of Jobvite hires
27	USER_JOBVITE_EMAIL_DIRECT	Number of Jobvite direct emails
28	USER_JOBVITE_LINKEDIN_DIRECT	Number of Jobvite LinkedIn direct messages
29	USER_JOBVITE_LINKEDIN_BROADCAST	Number of Jobvite LinkedIn broadcasts
30	USER_JOBVITE_FACEBOOK_BROADCAST	Number of Jobvite Facebook broadcasts
31	USER_JOBVITE_TWITTER_BROADCAST	Number of Jobvite Twitter broadcasts
32	USER_JOBVITE_JOBLINK_BROADCAST	Number of Jobvite JobLinks broadcast
33	USER_CANDIDATES_ADDED	Number of candidates added
34	USER_CONTACTS_MOVED_CONTACTED	Number of contacts moved to Contacted status
35	USER_CONTACTS_MOVED_HIRED	Number of contacts moved to Hired status
36	USER_ACTIVE_CAMPAIGNS	Total number of active campaigns
37	USER_PUBLISHER_STATUS	User has publisher status (TRUE/FALSE)
38	USER_CONTACTS_EVER_MOVED_CANDIDATE_STATUS	Total number of contacts ever moved into Candidate status
39	USER_CONTACTS_EVER_MOVED_CONTACTED_STATUS	Total number of contacts ever moved into Contacted status
40	USER_CONTACTS_EVER_MOVED_HIRED_STATUS	Total number of contacts ever moved into Hired status
41	USER_NOTES_ADDED	Number of user notes added

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ENGAGE_USER_ACTIVITY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
ENGAGE_USER_ACTIVITY_ENGAGE_USER_FK	ENGAGE_USER	Y	Y		USER_ID	USER_ID

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

Description
Notes

Number Of Columns	7
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	USER_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	USER_ACTIVITY_DATE			Timestamp	LT
4	USER_ACTIVE_EMAIL_CAMPAIGNS			BIGINT	LT
5	USER_ACTIVE_SOCIAL_CAMPAIGNS			BIGINT	LT
6	USER_ACTIVE_WEBPAGE_CAMPAIGNS			BIGINT	LT
7	USER_ACTIVE_CAMPAIGNS			BIGINT	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID
3	USER_ACTIVITY_DATE	Active campaign activity record date timestamp
4	USER_ACTIVE_EMAIL_CAMPAIGNS	Number of active email campaigns
5	USER_ACTIVE_SOCIAL_CAMPAIGNS	Number of active social campaigns
6	USER_ACTIVE_WEBPAGE_CAMPAIGNS	Number of active webpage campaigns
7	USER_ACTIVE_CAMPAIGNS	Total number of active campaigns

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
ENGAGE_USER_ACTIVITY_ACTIVE_CAMPAIGN_ENGAGE_USER_FK	ENGAGE_USER	Y	Y		USER_ID	USER_ID

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

Description
Notes

Number Of Columns	5
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	USER_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	USER_ACTIVITY_DATE			Timestamp	LT
4	USER_SOCIAL_CAMPAIGN_MESSAGES_SENT			BIGINT	LT
5	USER_EMAIL_CAMPAIGN_MESSAGES_SENT			BIGINT	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID
3	USER_ACTIVITY_DATE	Campaign message activity date timestamp
4	USER_SOCIAL_CAMPAIGN_MESSAGES_SENT	Number of social campaign messages sent
5	USER_EMAIL_CAMPAIGN_MESSAGES_SENT	Number of email campaign messages sent

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_ENGAGE_USER_FK	ENGAGE_USER	Y	Y		USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_CAMPAIGN_MESSAGE_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	USER_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	USER_ACTIVITY_DATE			Timestamp	LT
4	USER_ASSIGNED_CONTACTS			BIGINT	LT
5	USER_CONTACTS_MOVED			BIGINT	LT
6	USER_CONTACTS_ADDED			BIGINT	LT
7	USER_CANDIDATES_ADDED			BIGINT	LT
8	USER_CONTACTS_MOVED_CONTACTED			BIGINT	LT
9	USER_CONTACTS_MOVED_HIRED			BIGINT	LT
10	USER_NOTES_ADDED			BIGINT	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID
3	USER_ACTIVITY_DATE	Contact activity record date timestamp
4	USER_ASSIGNED_CONTACTS	Number of assigned contacts
5	USER_CONTACTS_MOVED	Number of contacts moved
6	USER_CONTACTS_ADDED	Number of contacts added
7	USER_CANDIDATES_ADDED	Number of candidates added
8	USER_CONTACTS_MOVED_CONTACTED	Number of contacts moved to Contacted status
9	USER_CONTACTS_MOVED_HIRED	Number of contacts moved to Hired status
10	USER_NOTES_ADDED	Number of notes added

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ENGAGE_USER_ACTIVITY_CONTACT_ENGAGE_USER_FK	ENGAGE_USER	Y	Y		USER_ID	USER_ID
ENGAGE_USER_ACTIVITY_CONTACT_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	19
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	APP_ID	F	Y	BIGINT	LT
2	APP_EID			VARCHAR (50)	LT
3	COMPANY_ID	F	Y	BIGINT (38)	LT
4	GDPR_APP_SENT_DATE			Timestamp	LT
5	GDPR_APP_REMOVED_DATE			Timestamp	LT
6	GDPR_APP_REMOVE_INITIATOR_TYPE			VARCHAR (20)	LT
7	GDPR_APP_REMOVE_TYPE			VARCHAR (10)	LT
8	GDPR_APP_CONSENT_DATE			Timestamp	LT
9	GDPR_APP_CONSENT_LOC_LAN			VARCHAR (100)	LT
10	GDPR_APP_REMOVAL_REASON			VARCHAR (200)	LT
11	GDPR_APP_REMOVAL_INITIATOR_NAME			VARCHAR (200)	LT
12	GDPR_APP_REMOVAL_INITIATOR_EMAIL			VARCHAR (100)	LT
13	GDPR_APP_REMOVAL_INITIATOR_DEPARTMENT			VARCHAR (50)	LT
14	GDPR_APP_REMOVAL_INITIATOR_USERID			BIGINT	LT
15	GDPR_APP_JOB_ID	F	Y	BIGINT	LT
16	GDPR_APP_JOB_LOCATION_NAME			VARCHAR (150)	LT
17	GDPR_APP_JOB_LOCATION_COUNTRY			VARCHAR (100)	LT
18	GDPR_APP_JOB_TITLE			VARCHAR (150)	LT
19	GDPR_APP_JOB_REGION_NAME			VARCHAR (150)	LT

Columns Comments

No	Column Name	Description
1	APP_ID	Application ID
2	APP_EID	Application encrypted ID
3	COMPANY_ID	Company ID
4	GDPR_APP_SENT_DATE	GDPR application sent date timestamp
5	GDPR_APP_REMOVED_DATE	GDPR application removed date timestamp
6	GDPR_APP_REMOVE_INITIATOR_TYPE	GDPR application removal initiator type
7	GDPR_APP_REMOVE_TYPE	GDPR application removal type
8	GDPR_APP_CONSENT_DATE	GDPR application consent date
9	GDPR_APP_CONSENT_LOC_LAN	GDPR application consent location language
10	GDPR_APP_REMOVAL_REASON	GDPR application removal reason
11	GDPR_APP_REMOVAL_INITIATOR_NAME	GDPR application removal initiator name
12	GDPR_APP_REMOVAL_INITIATOR_EMAIL	GDPR application removal initiator email
13	GDPR_APP_REMOVAL_INITIATOR_DEPARTMENT	GDPR application removal initiator department
14	GDPR_APP_REMOVAL_INITIATOR_USERID	GDPR application removal initiator user ID
15	GDPR_APP_JOB_ID	Application job ID
16	GDPR_APP_JOB_LOCATION_NAME	Application job location name
17	GDPR_APP_JOB_LOCATION_COUNTRY	Application job location country
18	GDPR_APP_JOB_TITLE	Application job title
19	GDPR_APP_JOB_REGION_NAME	Application job region name

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
GDPR_APPLICATION_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
GDPR_APPLICATION_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
GDPR_APPLICATION_JOB_FK	JOB	Y	Y	GDPR_APP_JOB_ID	JOB_ID

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

Description
Notes

Number Of Columns	14
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	CONTACT_ID	F	Y	BIGINT	LT
2	CONTACT_EID			VARCHAR (50)	LT
3	COMPANY_ID	F	Y	BIGINT (38)	LT
4	GDPR_CONTACT_CREATED_DATE			Timestamp	LT
5	GDPR_CONTACT_REMOVED_DATE			Timestamp	LT
6	GDPR_CONTACT_REMOVE_INITIATOR_TYPE			VARCHAR (20)	LT
7	GDPR_CONTACT_REMOVE_TYPE			VARCHAR (10)	LT
8	GDPR_CONTACT_CONSENT_DATE			Timestamp	LT
9	GDPR_CONTACT_CONSENT_LOC_LAN			VARCHAR (100)	LT
10	GDPR_CONTACT_REMOVAL_REASON			VARCHAR (200)	LT
11	GDPR_CONTACT_REMOVAL_INITIATOR_NAME			VARCHAR (200)	LT
12	GDPR_CONTACT_REMOVAL_INITIATOR_EMAIL			VARCHAR (100)	LT
13	GDPR_CONTACT_REMOVAL_INITIATOR_DEPARTMENT			VARCHAR (50)	LT
14	GDPR_CONTACT_REMOVAL_INITIATOR_USERID			BIGINT	LT

Columns Comments

No	Column Name	Description
1	CONTACT_ID	Contact ID
2	CONTACT_EID	Contact encrypted ID
3	COMPANY_ID	Company ID
4	GDPR_CONTACT_CREATED_DATE	GDPR contact created date timestamp
5	GDPR_CONTACT_REMOVED_DATE	GDPR contact removed date timestamp
6	GDPR_CONTACT_REMOVE_INITIATOR_TYPE	GDPR contact removal initiator type
7	GDPR_CONTACT_REMOVE_TYPE	GDPR contact removal type
8	GDPR_CONTACT_CONSENT_DATE	GDPR contact consent date
9	GDPR_CONTACT_CONSENT_LOC_LAN	GDPR contact consent location language
10	GDPR_CONTACT_REMOVAL_REASON	GDPR contact removal reason
11	GDPR_CONTACT_REMOVAL_INITIATOR_NAME	GDPR contact removal initiator name
13	GDPR_CONTACT_REMOVAL_INITIATOR_DEPARTMENT	GDPR removal initiator department
14	GDPR_CONTACT_REMOVAL_INITIATOR_USERID	GDPR contact removal inititator UserID

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
GDPR_CONTACT_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
GDPR_CONTACT_CONTACT_FK	CONTACT	Y	Y		CONTACT_ID	CONTACT_ID

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

Description
Notes

Number Of Columns	12
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_ENTITY_ID	P		Y	VARCHAR (30)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	GDPR_ONB_ENTITY_REMOVED_TYPE				BIGINT	LT
4	GDPR_ONB_ENTITY_REMOVED_DATE				Timestamp	LT
5	GDPR_ONB_ENTITY_REMOVE_INITIATOR_TYPE				VARCHAR (20)	LT
6	GDPR_ONB_ENTITY_REMOVE_TYPE				VARCHAR (10)	LT
7	GDPR_ONB_ENTITY_CONSENT_DATE				Timestamp	LT
8	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_NAME				VARCHAR (200)	LT
9	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_EMAIL				VARCHAR (100)	LT
10	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_DEPARTMENT				VARCHAR (50)	LT
11	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID		F	Y	BIGINT	LT
12	GDPR_ONB_ENTITY_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_ENTITY_ID	Onboarding entity ID
2	COMPANY_ID	Company ID
3	GDPR_ONB_ENTITY_REMOVED_TYPE	GDPR onboarding entity removal type
4	GDPR_ONB_ENTITY_REMOVED_DATE	GDPR onboarding entity removed date timestamp
5	GDPR_ONB_ENTITY_REMOVE_INITIATOR_TYPE	GDPR onboarding entity removal intiator type
6	GDPR_ONB_ENTITY_REMOVE_TYPE	GDPR onboarding entity removal type
7	GDPR_ONB_ENTITY_CONSENT_DATE	GDPR onboarding entity consent date
8	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_NAME	GDPR onboarding entity removal initiator name
9	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_EMAIL	GDPR onboarding entity removal initiator email
10	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_DEPARTMENT	GDPR onboarding entity removal initiator department
11	GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID	GDPR onboarding entity removal initiator user ID (COMPANY_USER.company_user_id)
12	GDPR_ONB_ENTITY_DELETED	GDPR onboarding entity deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
GDPR_ONBOARDING_ENTITY_PK	PK				ONB_ENTITY_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
GDPR_ONBOARDING_ENTITY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
GDPR_ONBOARDING_ENTITY_COMPANY_USER_FK	COMPANY_USER	Y	Y		GDPR_ONB_ENTITY_REMOVAL_INITIATOR_USERID	USER_ID

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

Description
Notes

Number Of Columns	21
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	INTERVIEW_ID	P		Y	BIGINT	LT
2	USER_ID		F	Y	BIGINT	LT
3	APP_ID		F	Y	BIGINT	LT
4	COMPANY_ID		F	Y	BIGINT (38)	LT
5	INTERVIEW_TYPE				VARCHAR (100)	LT
6	INTERVIEW_CREATED_DATE				Timestamp	LT
7	INTERVIEW_SCHEDULED_DATE				Timestamp	LT
8	INTERVIEW_SCHEDULED_UTC_DATE				Timestamp	LT
9	INTERVIEW_SUMMARY				VARCHAR (100)	LT
10	INTERVIEW_COMPLETED				Boolean	LT
11	INTERVIEW_COMPLETED_BY				BIGINT	LT
12	INTERVIEW_FLAGS				BIGINT	LT
13	INTERVIEW_CANCELLED				Boolean	LT
14	INTERVIEW_MODIFIED				Timestamp	LT
15	INTERVIEW_COMPLETED_DATE				Timestamp	LT
16	INTERVIEW_STATUS				VARCHAR (25)	LT
17	INTERVIEW_SUBMITTED_DATE				Timestamp	LT
18	INTERVIEW_HR_RESTRICTED				Boolean	LT
19	INTERVIEW_SCHEDULED_BY_USER_ID				BIGINT	LT
20	INTERVIEW_LOCATION				VARCHAR (50)	LT
21	INTERVIEW_LOCATION_EMAIL				VARCHAR (50)	LT

Columns Comments

No	Column Name	Description
1	INTERVIEW_ID	Interview ID
2	USER_ID	User ID (COMPANY_USER.company_user_id)
3	APP_ID	Application ID
4	COMPANY_ID	Company ID
5	INTERVIEW_TYPE	Interview type
6	INTERVIEW_CREATED_DATE	Interview created date timestamp
7	INTERVIEW_SCHEDULED_DATE	Interview scheduled date timestamp
8	INTERVIEW_SCHEDULED_UTC_DATE	Interview scheduled date timestamp (UTC)
9	INTERVIEW_SUMMARY	Interview summary
10	INTERVIEW_COMPLETED	Interview completed (TRUE/FALSE)
11	INTERVIEW_COMPLETED_BY	Interview completed by UserID (COMPANY_USER.company_user_id)
12	INTERVIEW_FLAGS	Interview flags
13	INTERVIEW_CANCELLED	Interview cancelled (TRUE/FALSE)
14	INTERVIEW_MODIFIED	Interview last modified date timestamp
15	INTERVIEW_COMPLETED_DATE	Interview completed date timestamp
16	INTERVIEW_STATUS	Interview status
17	INTERVIEW_SUBMITTED_DATE	Interview submitted date timestamp
18	INTERVIEW_HR_RESTRICTED	Interview HR restricted (TRUE/FALSE)
19	INTERVIEW_SCHEDULED_BY_USER_ID	Interview scheduled by UserID (COMPANY_USER.company_user_id)
20	INTERVIEW_LOCATION	Interview location
21	INTERVIEW_LOCATION_EMAIL	Interview location email address

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
INTERVIEW_PK	PK				INTERVIEW_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
INTERVIEW_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
INTERVIEW_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
INTERVIEW_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	7
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	INTERVIEW_EVALUATION_ID	P		Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	INTERVIEW_EVALUATION_MODIFIED_DATE				Timestamp	LT
4	INTERVIEW_EVALUATION_TYPE				VARCHAR (50)	LT
5	INTERVIEW_EVALUATION_TITLE				VARCHAR (256)	LT
6	INTERVIEW_EVALUATION_RATING				VARCHAR (256)	LT
7	INTERVIEW_EVALUATION_COMMENTS				VARCHAR (4096)	LT

Columns Comments

No	Column Name	Description
1	INTERVIEW_EVALUATION_ID	Interview evaluation record ID
2	COMPANY_ID	Company ID
3	INTERVIEW_EVALUATION_MODIFIED_DATE	Interview evaluation last modified date timestamp
4	INTERVIEW_EVALUATION_TYPE	Interview evaluation type
5	INTERVIEW_EVALUATION_TITLE	Interview evaluation title
6	INTERVIEW_EVALUATION_RATING	Interview evaluation rating
7	INTERVIEW_EVALUATION_COMMENTS	Interview evaluation comments

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
INTERVIEW_EVALUATION_PK	PK				INTERVIEW_EVALUATION_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
INTERVIEW_EVALUATION_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	71
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	JOB_ID	P		Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	JOB_TITLE				VARCHAR (150)	LT
4	JOB_SENT_DATE				Timestamp	LT
5	JOB_CATEGORY				VARCHAR (60)	LT
6	JOB_CLOSE_DATE				Timestamp	LT
7	JOB_MODIFIED_DATE				Timestamp	LT
8	JOB_OPEN_DATE				Timestamp	LT
9	JOB_AVAILABLE_TO				BIGINT	LT
10	JOB_REQUISITION_ID				VARCHAR (50)	LT
11	JOB_CREATED_BY				VARCHAR (200)	LT
12	JOB_BRIEF_DESCRIPTION				VARCHAR (2000)	LT
13	JOB_OPENINGS				BIGINT	LT
14	JOB_FILLED_ON				Timestamp	LT
15	JOB_CAREER_SITE				Boolean	LT
16	JOB_COMPANY_NAME				VARCHAR (50)	LT
17	JOB_COUNTRY				VARCHAR (50)	LT
18	JOB_PRIVATE				Boolean	LT
19	JOB_NOTIFIED				Boolean	LT
20	JOB_APPROVE_DATE				Timestamp	LT
21	JOB_FILLED_ON2				Timestamp	LT
22	JOB_NOTIFICATION				VARCHAR (10)	LT
23	JOB_START_DATE				Timestamp	LT
24	JOB_END_DATE				Timestamp	LT
25	JOB_PUT_ON_HOLD_DATE				Timestamp	LT
26	JOB_HOLD_TIME_SPAN				BIGINT	LT
27	JOB_LOCATION_NAME				VARCHAR (150)	LT
28	JOB_LOCATION_ADDRESS				VARCHAR (100)	LT
29	JOB_LOCATION_POSTAL_CODE				VARCHAR (10)	LT
30	JOB_LOCATION_CITY				VARCHAR (100)	LT
31	JOB_LOCATION_STATE				VARCHAR (100)	LT
32	JOB_LOCATION_COUNTRY				VARCHAR (100)	LT
33	JOB_LOCATION_ADDRESS2				VARCHAR (50)	LT
34	JOB_REGION_NAME				VARCHAR (150)	LT
35	JOB_SUBSIDIARY_NAME				VARCHAR (100)	LT
36	JOB_DEPARTMENT_NAME				VARCHAR (150)	LT
37	JOB_WORKFLOW_TITLE				VARCHAR (50)	LT
38	JOB_JOBTYPE_NAME				VARCHAR (100)	LT
39	JOB_DAYS_OPEN				BIGINT	LT
40	JOB_EVALUATION_NAME				VARCHAR (100)	LT
41	JOB_PRE_INTERVIEW_FORM				VARCHAR (150)	LT
42	JOB_TIME_TO_FILL				BIGINT	LT
43	JOB_TIME_TO_APPROVE				BIGINT	LT
44	JOB_CREATED_USER_FIRST_NAME				VARCHAR (100)	LT
45	JOB_CREATED_USER_LAST_NAME				VARCHAR (100)	LT
46	JOB_CREATED_USER_EMAIL				VARCHAR (100)	LT
47	JOB_STATUS				VARCHAR (25)	LT
48	JOB_EEOCATEGORY				VARCHAR (100)	LT
49	JOB_PUBLISH_OPTION				VARCHAR (100)	LT
50	JOB_DELETED				Boolean	LT
51	JOB_LINK_URL				VARCHAR (256)	LT
52	JOB_R_FULL_NAME_GROUP				VARCHAR (65535)	LT
53	JOB_HM_FULL_NAME_GROUP				VARCHAR (65535)	LT
54	JOB_CREATED_BY_USERID				BIGINT	LT
55	JOB_PRIMARY_HM_FIRST_NAME				VARCHAR (100)	LT
56	JOB_PRIMARY_HM_LAST_NAME				VARCHAR (100)	LT
57	JOB_PRIMARY_HM_FULL_NAME				VARCHAR (202)	LT
58	JOB_PRIMARY_HM_EMAIL				VARCHAR (100)	LT
59	JOB_AGENCY_LIST				VARCHAR (65535)	LT
60	JOB_BONUS				BIGINT	LT
61	JOB_EID				VARCHAR (50)	LT
62	JOB_LOCATION_LIST				VARCHAR (65535)	LT
63	JOB_REMAINING_OPENINGS				BIGINT	LT
64	JOB_MOST_RECENT_OPEN_DATE				Timestamp	LT
65	JOB_PRIMARY_RECRUITER_FIRST_NAME				VARCHAR (100)	LT
66	JOB_PRIMARY_RECRUITER_LAST_NAME				VARCHAR (100)	LT
67	JOB_PRIMARY_RECRUITER_FULL_NAME				VARCHAR (202)	LT
68	JOB_PRIMARY_RECRUITER_EMAIL				VARCHAR (100)	LT
69	JOB_APPLY_FORM				VARCHAR (256)	LT
70	JOB_FURTHEST_CANDIDATE_STATUS				VARCHAR (150)	LT
71	JOB_EMAIL_LANG				VARCHAR (100)	LT

Columns Comments

No	Column Name	Description
1	JOB_ID	Job ID
2	COMPANY_ID	Company ID
3	JOB_TITLE	Job title
4	JOB_SENT_DATE	Job sent date timestamp
5	JOB_CATEGORY	Job category
6	JOB_CLOSE_DATE	Job closed date timestamp
7	JOB_MODIFIED_DATE	Job last modified date timestamp
8	JOB_OPEN_DATE	Job open date timestamp
9	JOB_AVAILABLE_TO	Number of individuals job is available to
10	JOB_REQUISITION_ID	Requisition ID
11	JOB_CREATED_BY	Job created by user full name
12	JOB_BRIEF_DESCRIPTION	Job brief description
13	JOB_OPENINGS	Number of job openings
14	JOB_FILLED_ON	Job filled on date timestamp
15	JOB_CAREER_SITE	Job listed on a career site (TRUE/FALSE)
16	JOB_COMPANY_NAME	Job company name
17	JOB_COUNTRY	Job location country
18	JOB_PRIVATE	Job marked private (TRUE/FALSE)
19	JOB_NOTIFIED	Job notification (TRUE/FALSE)
20	JOB_APPROVE_DATE	Job approval date timestamp
21	JOB_FILLED_ON2	Job filled on date timestamp
22	JOB_NOTIFICATION	Job notification
23	JOB_START_DATE	Job start date timestamp
24	JOB_END_DATE	Job end date timestamp
25	JOB_PUT_ON_HOLD_DATE	Job put on hold date timestamp
26	JOB_HOLD_TIME_SPAN	Job hold time span (in days)
27	JOB_LOCATION_NAME	Job location name
28	JOB_LOCATION_ADDRESS	Job loction address
29	JOB_LOCATION_POSTAL_CODE	Job location postal code
30	JOB_LOCATION_CITY	Job location city
31	JOB_LOCATION_STATE	Job location state
32	JOB_LOCATION_COUNTRY	Job location country
33	JOB_LOCATION_ADDRESS2	Job location address line 2
34	JOB_REGION_NAME	Job region name
35	JOB_SUBSIDIARY_NAME	Job subsidiary name
36	JOB_DEPARTMENT_NAME	Job department name
37	JOB_WORKFLOW_TITLE	Job workflow title
38	JOB_JOBTYPE_NAME	Job type name Full-time Part-time Contractor Intern
39	JOB_DAYS_OPEN	Job days open
40	JOB_EVALUATION_NAME	Job evaluation name
41	JOB_PRE_INTERVIEW_FORM	Job pre-interview form
42	JOB_TIME_TO_FILL	Job time-to-fill (days)
43	JOB_TIME_TO_APPROVE	Job time to approve (days)
44	JOB_CREATED_USER_FIRST_NAME	Job creator first name
45	JOB_CREATED_USER_LAST_NAME	Job creator last name
46	JOB_CREATED_USER_EMAIL	Job creator email address
47	JOB_STATUS	Job Status
48	JOB_EEOCATEGORY	Job EEO category
49	JOB_PUBLISH_OPTION	Job publish option Limited Access All empoyees (Internal) Everyone (External)
50	JOB_DELETED	Job has been deleted (TRUE/FALSE)
51	JOB_LINK_URL	Job link URL
52	JOB_R_FULL_NAME_GROUP	Job recruiters (full name)
53	JOB_HM_FULL_NAME_GROUP	Job hiring managers (full name)
54	JOB_CREATED_BY_USERID	Job creator user ID (COMPANY_USER.company_user_id)
55	JOB_PRIMARY_HM_FIRST_NAME	Primary hiring manager first name
56	JOB_PRIMARY_HM_LAST_NAME	Primary hiring manager last name
57	JOB_PRIMARY_HM_FULL_NAME	Primary hiring manager full name
58	JOB_PRIMARY_HM_EMAIL	Primary hiring manager email address
59	JOB_AGENCY_LIST	Job agency list
60	JOB_BONUS	Job referal bonus
61	JOB_EID	Job encrypted ID
62	JOB_LOCATION_LIST	Job location list
63	JOB_REMAINING_OPENINGS	Job openings remaining
64	JOB_MOST_RECENT_OPEN_DATE	Most recent open date timestamp
65	JOB_PRIMARY_RECRUITER_FIRST_NAME	Job primary recruiter first name
66	JOB_PRIMARY_RECRUITER_LAST_NAME	Job primary recruiter last name
67	JOB_PRIMARY_RECRUITER_FULL_NAME	Job primary recruiter full name
68	JOB_PRIMARY_RECRUITER_EMAIL	Job primary recruiter email address
69	JOB_APPLY_FORM	Job apply form
70	JOB_FURTHEST_CANDIDATE_STATUS	Job furthest candidate status
71	JOB_EMAIL_LANG	Job associated email language

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
JOB_PK	PK				JOB_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
JOB_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
AGENCY_JOB_JOB_FK	AGENCY_JOB	Y	Y	JOB_ID	JOB_ID
APPLICATION_JOB_FK	APPLICATION	Y	Y	JOB_ID	JOB_ID
APPLICATION_LOOKUP_JOB_FK	APPLICATION_LOOKUP	Y	Y	JOB_ID	JOB_ID
APPROVER_JOB_FK	APPROVER	Y	Y	ITEM_ID	JOB_ID
CANDIDATE_MILESTONE_JOB_FK	CANDIDATE_MILESTONE	Y	Y	JOB_ID	JOB_ID
GDPR_APPLICATION_JOB_FK	GDPR_APPLICATION	Y	Y	GDPR_APP_JOB_ID	JOB_ID
JOB_CATEGORY_BENCHMARKS_JOB_FK	JOB_CATEGORY_BENCHMARKS	Y	Y	JOB_ID	JOB_ID
JOB_CUSTOM_FIELDS_JOB_FK	JOB_CUSTOM_FIELDS	Y	Y	JOB_ID	JOB_ID
JOB_DESC_DETAILS_JOB_FK	JOB_DESC_DETAILS	Y	Y	JOB_ID	JOB_ID
JOB_ID_TO_CWSMETRICS_BENCHMARKS_JOB_FK	JOB_ID_TO_CWSMETRICS_BENCHMARKS	Y	Y	JOB_ID	JOB_ID
JOB_ID_TO_CWSMETRICS_PAGE_VIEWS_JOB_FK	JOB_ID_TO_CWSMETRICS_PAGE_VIEWS	Y	Y	JOB_ID	JOB_ID
JOB_ID_TO_JOB_CAT_JOB_FK	JOB_ID_TO_JOB_CAT	Y	Y	JOB_ID	JOB_ID
JOB_ID_TO_JOB_CAT_PROD_JOB_FK	JOB_ID_TO_JOB_CAT_PROD	Y	Y	JOB_ID	JOB_ID
JOB_ID_TO_JOB_TAXONOMY_JOB_FK	JOB_ID_TO_JOB_TAXONOMY	Y	Y	JOB_ID	JOB_ID
JOB_JOBVITE_ACTIVITY_JOB_FK	JOB_JOBVITE_ACTIVITY	Y	Y	JOB_ID	JOB_ID
JOB_OPEN_HISTORY_JOB_FK	JOB_OPEN_HISTORY	Y	Y	JOB_ID	JOB_ID
JOB_OWNER_APPROVER_JOB_FK	JOB_OWNER_APPROVER	Y	Y	JOB_ID	JOB_ID
JOB_OWNER_JOB_FK	JOB_OWNER	Y	Y	JOB_ID	JOB_ID
LOOKUP_EID_JOB_JOB_FK	LOOKUP_EID_JOB	Y	Y	JOB_ID	JOB_ID
OFCCP_SEARCH_JOB_FK	OFCCP_SEARCH	Y	Y	JOB_ID	JOB_ID
ONBOARDING_NEW_HIRE_JOB_FK	ONBOARDING_NEW_HIRE	Y	Y	JOB_ID	JOB_ID
REQUISITION_ACCESS_JOB_FK	REQUISITION_ACCESS	Y	Y	JOB_ID	JOB_ID
SOURCE_DATA_JOB_FK	SOURCE_DATA	Y	Y	JOB_ID	JOB_ID
UNFILLED_JOB_FUNNEL_SNAPSHOT_JOB_FK	UNFILLED_JOB_FUNNEL_SNAPSHOT	Y	Y	JOB_ID	JOB_ID
USER_ACTIVITY_JOB_FK	USER_ACTIVITY	Y	Y	JOB_ID	JOB_ID
USER_ASSIGNED_JOB_ID_TO_JOB_CAT_JOB_FK	USER_ASSIGNED_JOB_ID_TO_JOB_CAT	Y	Y	JOB_ID	JOB_ID
VIDEO_FORM_RESPONSE_JOB_FK	VIDEO_FORM_RESPONSE	Y	Y	JOB_ID	JOB_ID
VIDEO_FORM_RESPONSE_QUESTION_JOB_FK	VIDEO_FORM_RESPONSE_QUESTION	Y	Y	JOB_ID	JOB_ID

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

Description
Notes

Number Of Columns	16
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	JOB_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	JOB_JOBVITE_SEND			BIGINT	LT
4	JOB_JOBVITE_BROADCAST			BIGINT	LT
5	JOB_JOBVITE_VIEW			BIGINT	LT
6	JOB_JOBVITE_CLICK_TO_APPLY			BIGINT	LT
7	JOB_JOBVITE_FORWARD			BIGINT	LT
8	JOB_JOBVITE_APPLY			BIGINT	LT
9	JOB_JOBVITE_HIRE			BIGINT	LT
10	JOB_JOBVITE_EMAIL_DIRECT			BIGINT	LT
11	JOB_JOBVITE_LINKEDIN_DIRECT			BIGINT	LT
12	JOB_JOBVITE_LINKEDIN_BROADCAST			BIGINT	LT
13	JOB_JOBVITE_FACEBOOK_BROADCAST			BIGINT	LT
14	JOB_JOBVITE_TWITTER_BROADCAST			BIGINT	LT
15	JOB_JOBVITE_JOBLINK_BROADCAST			BIGINT	LT
16	JOB_JOBVITE_ACTIVITY_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	JOB_ID	Job ID
2	COMPANY_ID	Company ID
3	JOB_JOBVITE_SEND	Number of Jobvites sent
4	JOB_JOBVITE_BROADCAST	Number of Jobvites broadcast
5	JOB_JOBVITE_VIEW	Number of Jobvites viewed
6	JOB_JOBVITE_CLICK_TO_APPLY	Number of Jobvites apply starts
7	JOB_JOBVITE_FORWARD	Number of Jobvites forwarded
8	JOB_JOBVITE_APPLY	Number of Jobvites applies complete
9	JOB_JOBVITE_HIRE	Number of Jobvites resulting in hires
10	JOB_JOBVITE_EMAIL_DIRECT	Number of Jobvites emailed directly
11	JOB_JOBVITE_LINKEDIN_DIRECT	Number of Jobvites shared directly on LinkedIn
12	JOB_JOBVITE_LINKEDIN_BROADCAST	Number of Jobvites brodcast to LinkedIn
13	JOB_JOBVITE_FACEBOOK_BROADCAST	Number of Jobvites brodcast to Facebook
14	JOB_JOBVITE_TWITTER_BROADCAST	Number of Jobvites brodcast to Twitter
15	JOB_JOBVITE_JOBLINK_BROADCAST	Number of Jobvites brodcast to Joblink
16	JOB_JOBVITE_ACTIVITY_DATE	Jobvite activity record date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
JOB_JOBVITE_ACTIVITY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
JOB_JOBVITE_ACTIVITY_JOB_FK	JOB	Y	Y		JOB_ID	JOB_ID

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

Description
Notes

Number Of Columns	6
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	JOB_ID		F	Y	BIGINT	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	JOB_OPEN_FROM_DATE				Timestamp	LT
4	JOB_OPEN_TO_DATE				Timestamp	LT
5	JOB_OPEN_MODIFIED_DATE				Timestamp	LT
6	JOB_OPEN_PRIMARY_KEY	P		Y	BIGINT	LT

Columns Comments

No	Column Name	Description
1	JOB_ID	Job ID
2	COMPANY_ID	Company ID
3	JOB_OPEN_FROM_DATE	Job open from (start) date timestamp
4	JOB_OPEN_TO_DATE	Job open to (end) date timestamp
5	JOB_OPEN_MODIFIED_DATE	Job open last modified date timestamp
6	JOB_OPEN_PRIMARY_KEY	Job open primary key

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
JOB_OPEN_HISTORY_PK	PK				JOB_OPEN_PRIMARY_KEY	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
JOB_OPEN_HISTORY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
JOB_OPEN_HISTORY_JOB_FK	JOB	Y	Y		JOB_ID	JOB_ID

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

Description
Notes

Number Of Columns	6
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	JOB_OWNER_ID	P		Y	BIGINT	LT
2	JOB_ID		F	Y	BIGINT	LT
3	USER_ID		F	Y	BIGINT	LT
4	COMPANY_ID		F	Y	BIGINT (38)	LT
5	IS_RECRUITER				Boolean	LT
6	JOB_OWNER_MODIFIED				Timestamp	LT

Columns Comments

No	Column Name	Description
1	JOB_OWNER_ID	Job owner ID
2	JOB_ID	Job ID
3	USER_ID	User ID (COMPANY_USER.company_user_id)
4	COMPANY_ID	Company ID
5	IS_RECRUITER	Owner is recruiter (TRUE/FALSE)
6	JOB_OWNER_MODIFIED	Job owner last modified date timestamp

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
JOB_OWNER_PK	PK				JOB_OWNER_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
JOB_OWNER_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
JOB_OWNER_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
JOB_OWNER_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	SEARCH_ID	P		Y	BIGINT	LT
2	JOB_ID		F	Y	BIGINT	LT
3	USER_ID		F	Y	BIGINT	LT
4	COMPANY_ID		F	Y	BIGINT (38)	LT
5	SEARCH_DATE				Timestamp	LT
6	SEARCH_KEYWORDS				VARCHAR (500)	LT
7	SEARCH_ALLWORDS				VARCHAR (500)	LT
8	SEARCH_EXACT_PHRASE				VARCHAR (500)	LT
9	SEARCH_ANYWORD				VARCHAR (500)	LT
10	SEARCH_NOWORD				VARCHAR (500)	LT

Columns Comments

No	Column Name	Description
1	SEARCH_ID	OFCCP Search ID
2	JOB_ID	Job ID
3	USER_ID	User ID (COMPANY_USER.company_user_id)
4	COMPANY_ID	Company ID
5	SEARCH_DATE	Search date timestamp
6	SEARCH_KEYWORDS	Search keywords
7	SEARCH_ALLWORDS	Search all words
8	SEARCH_EXACT_PHRASE	Search exact phrase
9	SEARCH_ANYWORD	Search anyword
10	SEARCH_NOWORD	Search no words

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
OFCCP_SEARCH_PK	PK				SEARCH_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
OFCCP_SEARCH_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
OFCCP_SEARCH_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
OFCCP_SEARCH_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	35
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_NEW_HIRE_ID	P		Y	VARCHAR (30)	LT
2	APP_ID		F	Y	BIGINT	LT
3	JOB_ID		F	Y	BIGINT	LT
4	COMPANY_ID		F	Y	BIGINT (38)	LT
5	ONB_NEW_HIRE_ADDRESS				VARCHAR (100)	LT
6	ONB_NEW_HIRE_CELL_PHONE				VARCHAR (25)	LT
7	ONB_NEW_HIRE_CELL_PHONE_CODE				VARCHAR (4)	LT
8	ONB_NEW_HIRE_CELL_PHONE_EXTENSION				VARCHAR (10)	LT
9	ONB_NEW_HIRE_CITY				VARCHAR (100)	LT
10	ONB_NEW_HIRE_COUNTRY				VARCHAR (100)	LT
11	ONB_NEW_HIRE_CREATED_BY_USER_ID		F	Y	BIGINT	LT
12	ONB_NEW_HIRE_CREATED_DATE				Timestamp	LT
13	ONB_NEW_HIRE_MODIFIED_DATE				Timestamp	LT
14	ONB_NEW_HIRE_EMAIL				VARCHAR (100)	LT
15	ONB_NEW_HIRE_FIRST_NAME				VARCHAR (100)	LT
16	ONB_NEW_HIRE_LAST_NAME				VARCHAR (100)	LT
17	ONB_NEW_HIRE_FULL_NAME				VARCHAR (201)	LT
18	ONB_NEW_HIRE_HIRING_MANAGER_USER_ID		F	Y	BIGINT	LT
19	ONB_NEW_HIRE_HOME_PHONE				VARCHAR (25)	LT
20	ONB_NEW_HIRE_HOME_PHONE_COUNTRY_CODE				VARCHAR (4)	LT
21	ONB_NEW_HIRE_HOME_PHONE_EXTENSION				VARCHAR (10)	LT
22	ONB_NEW_HIRE_HIRE_DATE				Timestamp	LT
23	ONB_NEW_HIRE_START_DATE				Timestamp	LT
24	ONB_NEW_HIRE_STATE				VARCHAR (100)	LT
25	ONB_NEW_HIRE_STATE_OTHER				VARCHAR (50)	LT
26	ONB_NEW_HIRE_MODIFIED_BY_USER_ID		F	Y	BIGINT	LT
27	ONB_NEW_HIRE_WORKFLOW_STATUS				VARCHAR (100)	LT
28	ONB_NEW_HIRE_ZIP				VARCHAR (50)	LT
29	ONB_NEW_HIRE_JOB_TITLE				VARCHAR (100)	LT
30	ONB_NEW_HIRE_CANDIDATE_ID				BIGINT	LT
31	ONB_NEW_HIRE_JOB_SEEKER_ID				BIGINT	LT
32	ONB_NEW_HIRE_EMPLOYEE_USER_ID				BIGINT	LT
33	ONB_NEW_HIRE_ENTITY_CODE				VARCHAR (100)	LT
34	ONB_NEW_HIRE_DELETED				Boolean	LT
35	ONB_NEW_HIRE_GDPR_FORGOTTEN				Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_NEW_HIRE_ID	Onboarding new hire ID
2	APP_ID	Application ID
3	JOB_ID	Job ID
4	COMPANY_ID	Company ID
5	ONB_NEW_HIRE_ADDRESS	New hire address
6	ONB_NEW_HIRE_CELL_PHONE	New hire cell phone
7	ONB_NEW_HIRE_CELL_PHONE_CODE	New hire cell phone country code
8	ONB_NEW_HIRE_CELL_PHONE_EXTENSION	New hire cell phone extension
9	ONB_NEW_HIRE_CITY	New hire address city
10	ONB_NEW_HIRE_COUNTRY	New hire address country
11	ONB_NEW_HIRE_CREATED_BY_USER_ID	New hire created by user (User ID)
12	ONB_NEW_HIRE_CREATED_DATE	New hire created date timestamp
13	ONB_NEW_HIRE_MODIFIED_DATE	New hire onboarding record last modified date timestamp
14	ONB_NEW_HIRE_EMAIL	New hire email address
15	ONB_NEW_HIRE_FIRST_NAME	New hire first name
16	ONB_NEW_HIRE_LAST_NAME	New hire last name
17	ONB_NEW_HIRE_FULL_NAME	New hire full name
18	ONB_NEW_HIRE_HIRING_MANAGER_USER_ID	New hire Hiring Manager user ID
19	ONB_NEW_HIRE_HOME_PHONE	New hire home phone
20	ONB_NEW_HIRE_HOME_PHONE_COUNTRY_CODE	New hire home phone country code
21	ONB_NEW_HIRE_HOME_PHONE_EXTENSION	New hire home phone extension
22	ONB_NEW_HIRE_HIRE_DATE	New hire hire date
23	ONB_NEW_HIRE_START_DATE	New hire start date
24	ONB_NEW_HIRE_STATE	New hire address state
25	ONB_NEW_HIRE_STATE_OTHER	New hire address state other
26	ONB_NEW_HIRE_MODIFIED_BY_USER_ID	New hire onboarding record last modified by User ID (COMPANY_USER.company_user_id)
27	ONB_NEW_HIRE_WORKFLOW_STATUS	New hire workflow status
28	ONB_NEW_HIRE_ZIP	New hire address zip code
29	ONB_NEW_HIRE_JOB_TITLE	New hire job title
30	ONB_NEW_HIRE_CANDIDATE_ID	New hire candidate ID
31	ONB_NEW_HIRE_JOB_SEEKER_ID	New hire job seeker ID
32	ONB_NEW_HIRE_EMPLOYEE_USER_ID	New hire employee user ID (COMPANY_USER.company_user_id)
33	ONB_NEW_HIRE_ENTITY_CODE	New hire entity code
34	ONB_NEW_HIRE_DELETED	New hire deleted (TRUE/FALSE)
35	ONB_NEW_HIRE_GDPR_FORGOTTEN	New hire record forgotten/anonymized for GDPR purposes (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ONBOARDING_NEW_HIRE_PK	PK				ONB_NEW_HIRE_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
ONBOARDING_NEW_HIRE_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
ONBOARDING_NEW_HIRE_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
ONBOARDING_NEW_HIRE_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv2	COMPANY_USER	Y	Y	ONB_NEW_HIRE_MODIFIED_BY_USER_ID	USER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FK	COMPANY_USER	Y	Y	ONB_NEW_HIRE_CREATED_BY_USER_ID	USER_ID
ONBOARDING_NEW_HIRE_COMPANY_USER_FKv1	COMPANY_USER	Y	Y	ONB_NEW_HIRE_HIRING_MANAGER_USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_PROCESS_ONBOARDING_NEW_HIRE_FK	ONBOARDING_PROCESS	Y	Y		ONB_NEW_HIRE_ID	ONB_NEW_HIRE_ID

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

Description
Notes

Number Of Columns	16
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	ONB_PORTAL_ID		Y	VARCHAR (30)	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	ONB_PORTAL_DESCRIPTION			VARCHAR (1000)	LT
4	ONB_PORTAL_EXTERNAL_NAME			VARCHAR (256)	LT
5	ONB_PORTAL_INTERNAL_NAME			VARCHAR (256)	LT
6	ONB_PORTAL_CREATED_DATE			Timestamp	LT
7	ONB_PORTAL_MODIFIED_DATE			Timestamp	LT
8	ONB_PORTAL_CREATED_BY_USER_ID			BIGINT	LT
9	ONB_PORTAL_MODIFIED_BY_USER_ID			BIGINT	LT
10	ONB_PORTAL_LIFE_CYCLE_STATUS			VARCHAR (50)	LT
11	ONB_PORTAL_USED_IN_ONBOARDINGS			BIGINT	LT
12	ONB_PORTAL_USED_IN_PROCESS			BIGINT	LT
13	ONB_PORTAL_TRANSLATION_COMPLETE			Boolean	LT
14	ONB_PORTAL_WORKFLOW_STATUS			VARCHAR (100)	LT
15	ONB_PORTAL_ENTITY_CODE			VARCHAR (100)	LT
16	ONB_PORTAL_DELETED			Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_PORTAL_ID	Onboarding portal ID
2	COMPANY_ID	Company ID
3	ONB_PORTAL_DESCRIPTION	Onboarding portal description
4	ONB_PORTAL_EXTERNAL_NAME	Onboarding portal external name
5	ONB_PORTAL_INTERNAL_NAME	Onboarding portal internal name
6	ONB_PORTAL_CREATED_DATE	Onboarding portal created date timestamp
7	ONB_PORTAL_MODIFIED_DATE	Onboarding portal last modified date timestamp
8	ONB_PORTAL_CREATED_BY_USER_ID	Onboarding portal creator User ID (COMPANY_USER.company_user_id)
9	ONB_PORTAL_MODIFIED_BY_USER_ID	Onboarding portal last modified by User ID (COMPANY_USER.company_user_id)
10	ONB_PORTAL_LIFE_CYCLE_STATUS	Onboarding portal life cycle status
11	ONB_PORTAL_USED_IN_ONBOARDINGS	Onboarding portal used in onboardings
12	ONB_PORTAL_USED_IN_PROCESS	Onboarding portal used in process
13	ONB_PORTAL_TRANSLATION_COMPLETE	Onboarding portal translation completed
14	ONB_PORTAL_WORKFLOW_STATUS	Onboarding portal workflow status
15	ONB_PORTAL_ENTITY_CODE	Onboarding portal entity code
16	ONB_PORTAL_DELETED	Onboarding portal deleted (TRUE/FALSE)

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_PORTAL_COMPANY_FKv1	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
ONBOARDING_PORTAL_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

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

Description
Notes

Number Of Columns	31
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_PROCESS_ID	P		Y	VARCHAR (30)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	ONB_NEW_HIRE_ID		F	Y	VARCHAR (30)	LT
4	ONB_PROCESS_HIRE_DATE				Timestamp	LT
5	ONB_HIRING_MANAGER_USER_ID		F	Y	BIGINT	LT
6	ONB_PROCESS_PORTAL_ID				VARCHAR (30)	LT
7	ONB_PROCESS_START_DATE				Timestamp	LT
8	ONB_PROCESS_ACTUAL_KICKOFF_DATE				Timestamp	LT
9	ONB_PROCESS_COMPLETES_ON				Timestamp	LT
10	ONB_PROCESS_COMPLETION_DATE				Timestamp	LT
11	ONB_PROCESS_CREATED_BY_USER_ID		F	Y	BIGINT	LT
12	ONB_PROCESS_CREATED_DATE				Timestamp	LT
13	ONB_PROCESS_MODIFIED_DATE				Timestamp	LT
14	ONB_PROCESS_DELAYED_KICK_OFF_DATE				Timestamp	LT
15	ONB_PROCESS_LIFE_CYCLE_STATUS				VARCHAR (50)	LT
16	ONB_PROCESS_NUMBER_OF_COMPLETED_TASKS				BIGINT	LT
17	ONB_PROCESS_NUMBER_OF_ISSUES				BIGINT	LT
18	ONB_PROCESS_NUMBER_OF_OVERDUES				BIGINT	LT
19	ONB_PROCESS_NUMBER_OF_SOON_OVERDUES				BIGINT	LT
20	ONB_PROCESS_NUMBER_OF_TASKS				BIGINT	LT
21	ONB_PROCESS_ORCHESTRATOR_USER_ID				BIGINT	LT
22	ONB_PROCESS_ORCHESTRATOR_LOCKED				Boolean	LT
23	ONB_PROCESS_ORCHESTRATOR_TYPE				VARCHAR (100)	LT
24	ONB_PROCESS_PERCENTAGE_OF_COMPLETED				BIGINT	LT
25	ONB_PROCESS_TEMPLATE_ID		F	Y	VARCHAR (30)	LT
26	ONB_PROCESS_TEMPLATE_NAME				VARCHAR (256)	LT
27	ONB_PROCESS_TRANSLATIONS_COMPLETE				Boolean	LT
28	ONB_PROCESS_MODIFIED_BY_USER_ID		F	Y	BIGINT	LT
29	ONB_PROCESS_WORKFLOW_STATUS				VARCHAR (100)	LT
30	ONB_PROCESS_ENTITY_CODE				VARCHAR (100)	LT
31	ONB_PROCESS_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_PROCESS_ID	Onboarding process ID
2	COMPANY_ID	Company ID
3	ONB_NEW_HIRE_ID	Onboarding new hire ID
4	ONB_PROCESS_HIRE_DATE	Onboarding process hire date
5	ONB_HIRING_MANAGER_USER_ID	Onboarding hiring manager User ID (COMPANY_USER.company_user_id)
6	ONB_PROCESS_PORTAL_ID	Onboarding process portal ID
7	ONB_PROCESS_START_DATE	Onboarding process start date
8	ONB_PROCESS_ACTUAL_KICKOFF_DATE	Onboarding process kickoff date
9	ONB_PROCESS_COMPLETES_ON	Onboarding process completion target date
10	ONB_PROCESS_COMPLETION_DATE	Onboarding process completion date
11	ONB_PROCESS_CREATED_BY_USER_ID	Onboarding process creator User ID (COMPANY_USER.company_user_id)
12	ONB_PROCESS_CREATED_DATE	Onboarding process record created date timestamp
13	ONB_PROCESS_MODIFIED_DATE	Onboarding process last modified date timestamp
14	ONB_PROCESS_DELAYED_KICK_OFF_DATE	Onboarding process delayed kick off date
15	ONB_PROCESS_LIFE_CYCLE_STATUS	Onboarding process life cycle status
16	ONB_PROCESS_NUMBER_OF_COMPLETED_TASKS	Number of completed onboarding tasks
17	ONB_PROCESS_NUMBER_OF_ISSUES	Number of onboarding issues
18	ONB_PROCESS_NUMBER_OF_OVERDUES	Number of overdue onboarding tasks
19	ONB_PROCESS_NUMBER_OF_SOON_OVERDUES	Number of onboarding tasks that will be overdue soon
20	ONB_PROCESS_NUMBER_OF_TASKS	Number of onboarding tasks
21	ONB_PROCESS_ORCHESTRATOR_USER_ID	Onboarding process orchestrator User ID (COMPANY_USER.company_user_id)
22	ONB_PROCESS_ORCHESTRATOR_LOCKED	Onboarding process orchestrator locked (TRUE/FALSE)
23	ONB_PROCESS_ORCHESTRATOR_TYPE	Onboarding process orchestrator type
24	ONB_PROCESS_PERCENTAGE_OF_COMPLETED	Onboarding process percent completed
25	ONB_PROCESS_TEMPLATE_ID	Onboarding process template ID
26	ONB_PROCESS_TEMPLATE_NAME	Onboarding process template name
27	ONB_PROCESS_TRANSLATIONS_COMPLETE	Onboarding process translation complete
28	ONB_PROCESS_MODIFIED_BY_USER_ID	Onboarding process record last modified by User ID (COMPANY_USER.company_user_id)
29	ONB_PROCESS_WORKFLOW_STATUS	Onboarding process current workflow status
30	ONB_PROCESS_ENTITY_CODE	Onboarding process entity code
31	ONB_PROCESS_DELETED	Onboarding process deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ONBOARDING_PROCESS_PK	PK				ONB_PROCESS_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
ONBOARDING_PROCESS_ONBOARDING_NEW_HIRE_FK	ONBOARDING_NEW_HIRE	Y	Y	ONB_NEW_HIRE_ID	ONB_NEW_HIRE_ID
ONBOARDING_PROCESS_ONBOARDING_PROCESS_TEMPLATE_FK	ONBOARDING_PROCESS_TEMPLATE	Y	Y	ONB_PROCESS_TEMPLATE_ID	ONB_PROCESS_TEMPLATE_ID
ONBOARDING_PROCESS_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv1	COMPANY_USER	Y	Y	ONB_PROCESS_CREATED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_COMPANY_USER_FKv2	COMPANY_USER	Y	Y	ONB_HIRING_MANAGER_USER_ID	USER_ID
ONBOARDING_PROCESS_COMPANY_USER_FK	COMPANY_USER	Y	Y	ONB_PROCESS_MODIFIED_BY_USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_TASK_ONBOARDING_PROCESS_FK	ONBOARDING_TASK	Y	Y		ONB_TASK_PROCESS_INSTANCE_ID	ONB_PROCESS_ID

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

Description
Notes

Number Of Columns	19
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_PROCESS_TEMPLATE_ID	P		Y	VARCHAR (30)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	ONB_PROCESS_TEMPLATE_NAME				VARCHAR (100)	LT
4	ONB_PROCESS_TEMPLATE_DESCRIPTION				VARCHAR (1000)	LT
5	ONB_PROCESS_TEMPLATE_CODE				VARCHAR (100)	LT
6	ONB_PROCESS_TEMPLATE_NUMBER_OF_TASKS				BIGINT	LT
7	ONB_PROCESS_TEMPLATE_ORCHESTRATOR_ID				BIGINT	LT
8	ONB_PROCESS_TEMPLATE_HAS_CORPORATE_ACCOUNT				Boolean	LT
9	ONB_PROCESS_TEMPLATE_PORTAL_ID				VARCHAR (30)	LT
10	ONB_PROCESS_TEMPLATE_ORCHESTRATOR_TYPE				VARCHAR (100)	LT
11	ONB_PROCESS_TEMPLATE_CREATED_DATE				Timestamp	LT
12	ONB_PROCESS_TEMPLATE_MODIFIED_DATE				Timestamp	LT
13	ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID		F	Y	BIGINT	LT
14	ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID		F	Y	BIGINT	LT
15	ONB_PROCESS_TEMPLATE_LIFE_CYCLE_STATUS				VARCHAR (50)	LT
16	ONB_PROCESS_TEMPLATE_TRANSLATION_COMPLETE				Boolean	LT
17	ONB_PROCESS_TEMPLATE_WORKFLOW_STATUS				VARCHAR (100)	LT
18	ONB_PROCESS_TEMPLATE_ENTITY_CODE				VARCHAR (100)	LT
19	ONB_PROCESS_TEMPLATE_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_PROCESS_TEMPLATE_ID	Onboarding process template ID
2	COMPANY_ID	Company ID
3	ONB_PROCESS_TEMPLATE_NAME	Template name
4	ONB_PROCESS_TEMPLATE_DESCRIPTION	Template description
5	ONB_PROCESS_TEMPLATE_CODE	Template code
6	ONB_PROCESS_TEMPLATE_NUMBER_OF_TASKS	Template number of tasks
7	ONB_PROCESS_TEMPLATE_ORCHESTRATOR_ID	Template orchestrator ID
8	ONB_PROCESS_TEMPLATE_HAS_CORPORATE_ACCOUNT	Template has corporate account (YES/NO)
9	ONB_PROCESS_TEMPLATE_PORTAL_ID	Template portal ID
10	ONB_PROCESS_TEMPLATE_ORCHESTRATOR_TYPE	Template orchestrator type
11	ONB_PROCESS_TEMPLATE_CREATED_DATE	Template created date timestamp
12	ONB_PROCESS_TEMPLATE_MODIFIED_DATE	Template last modified date timestamp
13	ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID	Template created by User ID (COMPANY_USER.company_user_id)
14	ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID	Template last modified by User ID (COMPANY_USER.company_user_id)
15	ONB_PROCESS_TEMPLATE_LIFE_CYCLE_STATUS	Template life cycle status
16	ONB_PROCESS_TEMPLATE_TRANSLATION_COMPLETE	Template translation completed (TRUE/FALSE)
17	ONB_PROCESS_TEMPLATE_WORKFLOW_STATUS	Template workflow status
18	ONB_PROCESS_TEMPLATE_ENTITY_CODE	Template entity code
19	ONB_PROCESS_TEMPLATE_DELETED	Template deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ONBOARDING_PROCESS_TEMPLATE_PK	PK				ONB_PROCESS_TEMPLATE_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
ONBOARDING_PROCESS_TEMPLATE_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FK	COMPANY_USER	Y	Y	ONB_PROCESS_TEMPLATE_CREATED_BY_USER_ID	USER_ID
ONBOARDING_PROCESS_TEMPLATE_COMPANY_USER_FKv1	COMPANY_USER	Y	Y	ONB_PROCESS_TEMPLATE_MODIFIED_BY_USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_PROCESS_ONBOARDING_PROCESS_TEMPLATE_FK	ONBOARDING_PROCESS	Y	Y		ONB_PROCESS_TEMPLATE_ID	ONB_PROCESS_TEMPLATE_ID

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

Description
Notes

Number Of Columns	37
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_TASK_ID	P		Y	VARCHAR (30)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	ONB_TASK_ACTIVATED_ASSIGNEE_TYPE				VARCHAR (100)	LT
4	ONB_TASK_ACTIVATED_ASSIGNEE_USER_ID				BIGINT	LT
5	ONB_TASK_ASSIGNEE_TYPE				VARCHAR (100)	LT
6	ONB_TASK_ASSIGNEE_USER_ID		F	Y	BIGINT	LT
7	ONB_TASK_ISSUE_RAISED				Boolean	LT
8	ONB_TASK_OVERDUE_STATUS				VARCHAR (100)	LT
9	ONB_TASK_ACTUAL_ACTIVATION_DATE				Timestamp	LT
10	ONB_TASK_COMPLETE				Boolean	LT
11	ONB_TASK_COMPLETION_DATE				Timestamp	LT
12	ONB_TASK_CREATED_BY_USER_ID		F	Y	BIGINT	LT
13	ONB_TASK_CREATED_DATE				Timestamp	LT
14	ONB_TASK_MODIFIED_DATE				Timestamp	LT
15	ONB_TASK_DELAYED_ACTIVATION_DATE				Timestamp	LT
16	ONB_TASK_DELAYED_ACTIVATION_REFERENCE				VARCHAR (100)	LT
17	ONB_TASK_DESCRIPTION				VARCHAR (1000)	LT
18	ONB_TASK_DUE_DATE				Timestamp	LT
19	ONB_TASK_DUE_DATE_OFFSET				BIGINT	LT
20	ONB_TASK_EXPECTED_ACTIVATION_DATE				Timestamp	LT
21	ONB_TASK_LAST_TIME_SEEN				Timestamp	LT
22	ONB_TASK_LIFE_CYCLE_STATUS				VARCHAR (100)	LT
23	ONB_TASK_LOCKED				Boolean	LT
24	ONB_TASK_LOCKED_DUE_DATE				Boolean	LT
25	ONB_TASK_PROCESS_INSTANCE_ID		F	Y	VARCHAR (30)	LT
26	ONB_TASK_REFERENCE_DUE_DATE				VARCHAR (100)	LT
27	ONB_TASK_SOURCE_TYPE				VARCHAR (100)	LT
28	ONB_TASK_TEMPLATE_ID		F	Y	VARCHAR (30)	LT
29	ONB_TASK_TEMPLATE_INTERNAL_NAME				VARCHAR (256)	LT
30	ONB_TASK_TEMPLATE_EXTERNAL_NAME				VARCHAR (256)	LT
31	ONB_TASK_MODIFIED_BY_USER_ID		F	Y	BIGINT	LT
32	ONB_TASK_WORKFLOW_STATUS				VARCHAR (100)	LT
33	ONB_TASK_ASSIGNED_DAYS				BIGINT	LT
34	ONB_TASK_BLOCKED_DAYS				BIGINT	LT
35	ONB_TASK_ENTITY_CODE				VARCHAR (100)	LT
36	ONB_TASK_DELETED				Boolean	LT
37	ONB_TASK_OVERDUE_DAYS				BIGINT	LT

Columns Comments

No	Column Name	Description
1	ONB_TASK_ID	Onboarding Task ID
2	COMPANY_ID	Company ID
3	ONB_TASK_ACTIVATED_ASSIGNEE_TYPE	Task activated assignee type
4	ONB_TASK_ACTIVATED_ASSIGNEE_USER_ID	Task activated assignee User ID (COMPANY_USER.company_user_id)
5	ONB_TASK_ASSIGNEE_TYPE	Task assignee type
6	ONB_TASK_ASSIGNEE_USER_ID	Task assignee User ID (COMPANY_USER.company_user_id)
7	ONB_TASK_ISSUE_RAISED	Task has an issue raised (TRUE/FALSE)
8	ONB_TASK_OVERDUE_STATUS	Task overdue status
9	ONB_TASK_ACTUAL_ACTIVATION_DATE	Task actual activation date timestamp
10	ONB_TASK_COMPLETE	Task completed (TRUE/FALSE)
11	ONB_TASK_COMPLETION_DATE	Task completion date timestamp
12	ONB_TASK_CREATED_BY_USER_ID	Task creator User ID (COMPANY_USER.company_user_id)
13	ONB_TASK_CREATED_DATE	Task created date timestamp
14	ONB_TASK_MODIFIED_DATE	Task last modified date timestamp
15	ONB_TASK_DELAYED_ACTIVATION_DATE	Task delayed activation date timestamp
16	ONB_TASK_DELAYED_ACTIVATION_REFERENCE	Task delayed activation reference
17	ONB_TASK_DESCRIPTION	Task description
18	ONB_TASK_DUE_DATE	Task due date
19	ONB_TASK_DUE_DATE_OFFSET	Task due date offset
20	ONB_TASK_EXPECTED_ACTIVATION_DATE	Task expected activation date
21	ONB_TASK_LAST_TIME_SEEN	Task last time seen date timestamp
22	ONB_TASK_LIFE_CYCLE_STATUS	Task life cycle status
23	ONB_TASK_LOCKED	Task locked (TRUE/FALSE)
24	ONB_TASK_LOCKED_DUE_DATE	Task locked due date (TRUE/FALSE)
25	ONB_TASK_PROCESS_INSTANCE_ID	Task process instance ID
26	ONB_TASK_REFERENCE_DUE_DATE	Task reference due date
27	ONB_TASK_SOURCE_TYPE	Task source type
28	ONB_TASK_TEMPLATE_ID	Task template ID
29	ONB_TASK_TEMPLATE_INTERNAL_NAME	Task template internal name
30	ONB_TASK_TEMPLATE_EXTERNAL_NAME	Task template external name
31	ONB_TASK_MODIFIED_BY_USER_ID	Task last modified by User ID (COMPANY_USER.company_user_id)
32	ONB_TASK_WORKFLOW_STATUS	Task workflow status
33	ONB_TASK_ASSIGNED_DAYS	Task assigned days
34	ONB_TASK_BLOCKED_DAYS	Task blocked days
35	ONB_TASK_ENTITY_CODE	Task entity code
36	ONB_TASK_DELETED	Task deleted (TRUE/FALSE)
37	ONB_TASK_OVERDUE_DAYS	Task overdue days

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ONBOARDING_TASK_PK	PK				ONB_TASK_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
ONBOARDING_TASK_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
ONBOARDING_TASK_ONBOARDING_PROCESS_FK	ONBOARDING_PROCESS	Y	Y	ONB_TASK_PROCESS_INSTANCE_ID	ONB_PROCESS_ID
ONBOARDING_TASK_ONBOARDING_TASK_TEMPLATE_FK	ONBOARDING_TASK_TEMPLATE	Y	Y	ONB_TASK_TEMPLATE_ID	ONB_TASK_TEMPLATE_ID
ONBOARDING_TASK_COMPANY_USER_FKv2	COMPANY_USER	Y	Y	ONB_TASK_MODIFIED_BY_USER_ID	USER_ID
ONBOARDING_TASK_COMPANY_USER_FKv1	COMPANY_USER	Y	Y	ONB_TASK_CREATED_BY_USER_ID	USER_ID
ONBOARDING_TASK_COMPANY_USER_FK	COMPANY_USER	Y	Y	ONB_TASK_ASSIGNEE_USER_ID	USER_ID

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

Description
Notes

Number Of Columns	21
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	ONB_TASK_TEMPLATE_ID	P		Y	VARCHAR (30)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	ONB_TASK_TEMPLATE_DESCRIPTION				VARCHAR (1000)	LT
4	ONB_TASK_TEMPLATE_EXTERNAL_NAME				VARCHAR (256)	LT
5	ONB_TASK_TEMPLATE_INTERNAL_NAME				VARCHAR (256)	LT
6	ONB_TASK_TEMPLATE_ASSIGNEE_LOCKED				Boolean	LT
7	ONB_TASK_TEMPLATE_ASSIGNEE_TYPE				VARCHAR (100)	LT
8	ONB_TASK_TEMPLATE_ASSIGNEE_FIRST_NAME				VARCHAR (100)	LT
9	ONB_TASK_TEMPLATE_ASSIGNEE_LAST_NAME				VARCHAR (100)	LT
10	ONB_TASK_TEMPLATE_CODE				VARCHAR (100)	LT
11	ONB_TASK_TEMPLATE_CREATED_DATE				Timestamp	LT
12	ONB_TASK_TEMPLATE_MODIFIED_DATE				Timestamp	LT
13	ONB_TASK_TEMPLATE_CREATED_BY_USER_ID				BIGINT	LT
14	ONB_TASK_TEMPLATE_MODIFIED_BY_USER_ID				BIGINT	LT
15	ONB_TASK_TEMPLATE_LIFE_CYCLE_STATUS				VARCHAR (50)	LT
16	ONB_TASK_TEMPLATE_LOCKED_DUE_DATE				Boolean	LT
17	ONB_TASK_TEMPLATE_PROCESS_TYPE				VARCHAR (100)	LT
18	ONB_TASK_TEMPLATE_TRANSLATION_COMPLETE				Boolean	LT
19	ONB_TASK_TEMPLATE_WORKFLOW_STATUS				VARCHAR (100)	LT
20	ONB_TASK_TEMPLATE_ENTITY_CODE				VARCHAR (100)	LT
21	ONB_TASK_TEMPLATE_DELETED				Boolean	LT

Columns Comments

No	Column Name	Description
1	ONB_TASK_TEMPLATE_ID	Task Template ID
2	COMPANY_ID	Company ID
3	ONB_TASK_TEMPLATE_DESCRIPTION	Task template description
4	ONB_TASK_TEMPLATE_EXTERNAL_NAME	Task template external name
5	ONB_TASK_TEMPLATE_INTERNAL_NAME	Task template internal name
6	ONB_TASK_TEMPLATE_ASSIGNEE_LOCKED	Task template assigned locked (TRUE/FALSE)
7	ONB_TASK_TEMPLATE_ASSIGNEE_TYPE	Task template assignee type
8	ONB_TASK_TEMPLATE_ASSIGNEE_FIRST_NAME	Task template assignee first name
9	ONB_TASK_TEMPLATE_ASSIGNEE_LAST_NAME	Task template assignee last name
10	ONB_TASK_TEMPLATE_CODE	Task template code
11	ONB_TASK_TEMPLATE_CREATED_DATE	Task template created date timestamp
12	ONB_TASK_TEMPLATE_MODIFIED_DATE	Task template last modified date timestamp
13	ONB_TASK_TEMPLATE_CREATED_BY_USER_ID	Task templated creator User ID (COMPANY_USER.company_user_id)
14	ONB_TASK_TEMPLATE_MODIFIED_BY_USER_ID	Task template last modified by User ID (COMPANY_USER.company_user_id)
15	ONB_TASK_TEMPLATE_LIFE_CYCLE_STATUS	Task template life cycle status
16	ONB_TASK_TEMPLATE_LOCKED_DUE_DATE	Tack template locked due date (TRUE/FALSE)
17	ONB_TASK_TEMPLATE_PROCESS_TYPE	Task template process type
18	ONB_TASK_TEMPLATE_TRANSLATION_COMPLETE	Task template translation complete (TRUE/FALSE)
19	ONB_TASK_TEMPLATE_WORKFLOW_STATUS	Task template workflow status
20	ONB_TASK_TEMPLATE_ENTITY_CODE	Task template entity code
21	ONB_TASK_TEMPLATE_DELETED	Task template deleted (TRUE/FALSE)

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
ONBOARDING_TASK_TEMPLATE_PK	PK				ONB_TASK_TEMPLATE_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_TASK_TEMPLATE_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
ONBOARDING_TASK_ONBOARDING_TASK_TEMPLATE_FK	ONBOARDING_TASK	Y	Y		ONB_TASK_TEMPLATE_ID	ONB_TASK_TEMPLATE_ID

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

Description
Notes

Number Of Columns	10
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	SCREENING_FORM_ID	P		Y	BIGINT	LT
2	APP_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	SCREENING_FORM_NAME				VARCHAR (128)	LT
5	SCREENING_FORM_STATUS				VARCHAR (128)	LT
6	SCREENING_FORM_COMPLETED_DATE				Timestamp	LT
7	SCREENING_FORM_SENT_DATE				Timestamp	LT
8	SCREENING_FORM_TEMPLATE_ID				BIGINT	LT
9	SCREENING_FORM_TOTAL_SCORE				DECIMAL (5,2)	LT
10	SCREENING_FORM_MODIFIED_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	SCREENING_FORM_ID	Screening form ID
2	APP_ID	Application ID
3	COMPANY_ID	Company ID
4	SCREENING_FORM_NAME	Screening form name
5	SCREENING_FORM_STATUS	Screening form status
6	SCREENING_FORM_COMPLETED_DATE	Screening form completed date timestamp
7	SCREENING_FORM_SENT_DATE	Screening form sent date timestamp
8	SCREENING_FORM_TEMPLATE_ID	Screening form template ID
9	SCREENING_FORM_TOTAL_SCORE	Screening form total score
10	SCREENING_FORM_MODIFIED_DATE	Screening form last modified date timestamp

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
SCREENING_FORM_PK	PK				SCREENING_FORM_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
SCREENING_FORM_APPLICATION_FK	APPLICATION	Y	Y		APP_ID	APP_ID
SCREENING_FORM_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
SCREENING_FORM_QUESTION_SCREENING_FORM_FK	SCREENING_FORM_QUESTION	Y	Y		SCREENING_FORM_ID	SCREENING_FORM_ID
SCREENING_FORM_VERIFY_SCREENING_FORM_FK	SCREENING_FORM_VERIFY	Y	Y		SCREENING_FORM_ID	SCREENING_FORM_ID

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

Description
Notes

Number Of Columns	7
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	SCREENING_FORM_ID	F	Y	BIGINT	LT
2	SCREENING_FORM_COMPLETED_DATE			Timestamp	LT
3	COMPANY_ID	F	Y	BIGINT (38)	LT
4	SCREENING_FORM_QUESTION			VARCHAR (65535)	LT
5	SCREENING_FORM_ANSWER			VARCHAR (65535)	LT
6	SCREENING_FORM_QUESTION_SCORE			BIGINT	LT
7	SCREENING_FORM_TOTAL_SCORE			DECIMAL (5,2)	LT

Columns Comments

No	Column Name	Description
1	SCREENING_FORM_ID	Screening form ID
2	SCREENING_FORM_COMPLETED_DATE	Screening form completed date timestamp
3	COMPANY_ID	Company ID
4	SCREENING_FORM_QUESTION	Screening form question
5	SCREENING_FORM_ANSWER	Screening form answer
6	SCREENING_FORM_QUESTION_SCORE	Screening form question score
7	SCREENING_FORM_TOTAL_SCORE	Screening form total score

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
SCREENING_FORM_QUESTION_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
SCREENING_FORM_QUESTION_SCREENING_FORM_FK	SCREENING_FORM	Y	Y		SCREENING_FORM_ID	SCREENING_FORM_ID

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

Description
Notes

Number Of Columns	17
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	USER_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	USER_JOBVITE_RECEIVE			BIGINT	LT
4	USER_JOBVITE_SEND			BIGINT	LT
5	USER_JOBVITE_BROADCAST			BIGINT	LT
6	USER_JOBVITE_VIEW			BIGINT	LT
7	USER_JOBVITE_CLICK_TO_APPLY			BIGINT	LT
8	USER_JOBVITE_FORWARD			BIGINT	LT
9	USER_JOBVITE_APPLY			BIGINT	LT
10	USER_JOBVITE_HIRE			BIGINT	LT
11	USER_JOBVITE_EMAIL_DIRECT			BIGINT	LT
12	USER_JOBVITE_LINKEDIN_DIRECT			BIGINT	LT
13	USER_JOBVITE_LINKEDIN_BROADCAST			BIGINT	LT
14	USER_JOBVITE_FACEBOOK_BROADCAST			BIGINT	LT
15	USER_JOBVITE_TWITTER_BROADCAST			BIGINT	LT
16	USER_JOBVITE_JOBLINK_BROADCAST			BIGINT	LT
17	USER_JOBVITE_ACTIVITY_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	USER_ID	User ID (COMPANY_USER.company_user_id)
2	COMPANY_ID	Company ID
3	USER_JOBVITE_RECEIVE	User Jobvites received
4	USER_JOBVITE_SEND	User Jobvites sent
5	USER_JOBVITE_BROADCAST	User Jobvites broadcast
6	USER_JOBVITE_VIEW	User Jobvites viewed
7	USER_JOBVITE_CLICK_TO_APPLY	User Jobvite apply starts
8	USER_JOBVITE_FORWARD	User Jobvites forwarded
9	USER_JOBVITE_APPLY	User Jobvite apply completes
10	USER_JOBVITE_HIRE	User Jobvites resulting in hire
11	USER_JOBVITE_EMAIL_DIRECT	User Jobvites emailed directly
12	USER_JOBVITE_LINKEDIN_DIRECT	User Jobvites shared directly on LinkedIn
13	USER_JOBVITE_LINKEDIN_BROADCAST	User Jobvites broadcast to LinkedIn
14	USER_JOBVITE_FACEBOOK_BROADCAST	User Jobvites broadcast to Facebook
15	USER_JOBVITE_TWITTER_BROADCAST	User Jobvites broadcast to Twitter
16	USER_JOBVITE_JOBLINK_BROADCAST	User Jobvites broadcast to Joblink
17	USER_JOBVITE_ACTIVITY_DATE	User Jobvite activity date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
USER_JOBVITE_ACTIVITY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
USER_JOBVITE_ACTIVITY_COMPANY_USER_FK	COMPANY_USER	Y	Y		USER_ID	USER_ID

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

Description
Notes

Number Of Columns	11
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	VIDEO_FORM_EVALUATION_ID	P		Y	VARCHAR (24)	LT
2	VIDEO_FORM_RESPONSE_ID		F	Y	VARCHAR (24)	LT
3	USER_ID		F	Y	BIGINT	LT
4	APP_ID		F	Y	BIGINT	LT
5	COMPANY_ID		F	Y	BIGINT (38)	LT
6	STATUS				VARCHAR (128)	LT
7	VIDEO_FORM_EVALUATION_CREATE_DATE				Timestamp	LT
8	VIDEO_FORM_EVALUATION_UPDATE_DATE				Timestamp	LT
9	VIDEO_FORM_EVALUATION_COMPLETION_DATE				Timestamp	LT
10	VIDEO_FORM_EVALUATION_OVERALL_RATING				BIGINT	LT
11	VIDEO_FORM_EVALUATION_OVERALL_COMMENT				VARCHAR (512)	LT

Columns Comments

No	Column Name	Description
1	VIDEO_FORM_EVALUATION_ID	Video evaluation form ID
2	VIDEO_FORM_RESPONSE_ID	Video evaluation form response ID
3	USER_ID	User ID (COMPANY_USER.company_user_id)
4	APP_ID	Application ID
5	COMPANY_ID	Company ID
6	STATUS	Video evaluation form status
7	VIDEO_FORM_EVALUATION_CREATE_DATE	Video evaluation form creation date timestamp
8	VIDEO_FORM_EVALUATION_UPDATE_DATE	Video evaluation form last updated date timestamp
9	VIDEO_FORM_EVALUATION_COMPLETION_DATE	Video evaluation form completion date timestamp
10	VIDEO_FORM_EVALUATION_OVERALL_RATING	Video evaluation form overall rating
11	VIDEO_FORM_EVALUATION_OVERALL_COMMENT	Video evaluation form overall comments

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
VIDEO_FORM_EVALUATION_PK	PK				VIDEO_FORM_EVALUATION_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
VIDEO_FORM_EVALUATION_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
VIDEO_FORM_EVALUATION_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_EVALUATION_VIDEO_FORM_RESPONSE_FK	VIDEO_FORM_RESPONSE	Y	Y	VIDEO_FORM_RESPONSE_ID	VIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_EVALUATION_FK	VIDEO_FORM_EVALUATION_QUESTION	Y	Y		VIDEO_FORM_EVALUATION_ID	VIDEO_FORM_EVALUATION_ID

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

Description
Notes

Number Of Columns	9
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	VIDEO_FORM_EVALUATION_ID	F	Y	VARCHAR (24)	LT
2	VIDEO_FORM_RESPONSE_ID	F	Y	VARCHAR (24)	LT
3	USER_ID	F	Y	BIGINT	LT
4	APP_ID	F	Y	BIGINT	LT
5	COMPANY_ID	F	Y	BIGINT (38)	LT
6	VIDEO_QUESTION_ID	F	Y	VARCHAR (24)	LT
7	VIDEO_QUESTION_RESPONSE_RATING			BIGINT	LT
8	VIDEO_QUESTION_RESPONSE_COMMENT			VARCHAR (512)	LT
9	VIDEO_FORM_EVALUATION_UPDATE_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	VIDEO_FORM_EVALUATION_ID	Video evaluation ID
2	VIDEO_FORM_RESPONSE_ID	Video response form ID
3	USER_ID	User ID (COMPANY_USER.company_user_id)
4	APP_ID	Application ID
5	COMPANY_ID	Company ID
6	VIDEO_QUESTION_ID	Video question ID
7	VIDEO_QUESTION_RESPONSE_RATING	Video question response rating
8	VIDEO_QUESTION_RESPONSE_COMMENT	Video question response comment
9	VIDEO_FORM_EVALUATION_UPDATE_DATE	Video evaluation form updated date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_QUESTION_FK	VIDEO_QUESTION	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_EVALUATION_FK	VIDEO_FORM_EVALUATION	Y	Y	VIDEO_FORM_EVALUATION_ID	VIDEO_FORM_EVALUATION_ID
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_RESPONSE_FK	VIDEO_FORM_RESPONSE	Y	Y	VIDEO_FORM_RESPONSE_ID	VIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
VIDEO_FORM_EVALUATION_QUESTION_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_EVALUATION_QUESTION_COMPANY_USER_FK	COMPANY_USER	Y	Y	USER_ID	USER_ID

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

Description
Notes

Number Of Columns	18
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	VIDEO_FORM_RESPONSE_ID	P		Y	VARCHAR (24)	LT
2	APP_ID		F	Y	BIGINT	LT
3	COMPANY_ID		F	Y	BIGINT (38)	LT
4	INTERVIEWEE_USER_ID		F		BIGINT	LT
5	CANDIDATE_ID				BIGINT	LT
6	SENT_BY_USER_ID		F	Y	BIGINT	LT
7	JOB_ID		F	Y	BIGINT	LT
8	WORKFLOW_ID				BIGINT	LT
9	STATUS				VARCHAR (128)	LT
10	VIDEO_FORM_EVALUATION_REQUEST_COUNT				BIGINT	LT
11	VIDEO_FORM_EVALUATION_COMPLETED_COUNT				BIGINT	LT
12	VIDEO_FORM_ID		F	Y	VARCHAR (24)	LT
13	VIDEO_FORM_RESPONSE_CREATE_DATE				Timestamp	LT
14	VIDEO_FORM_RESPONSE_UPDATE_DATE				Timestamp	LT
15	VIDEO_FORM_RESPONSE_SENT_DATE				Timestamp	LT
16	VIDEO_FORM_RESPONSE_VIEW_DATE				Timestamp	LT
17	VIDEO_FORM_RESPONSE_DEADLINE_DATE				Timestamp	LT
18	VIDEO_FORM_RESPONSE_COMPLETION_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	VIDEO_FORM_RESPONSE_ID	Video form response ID
2	APP_ID	Application ID
3	COMPANY_ID	Company ID
4	INTERVIEWEE_USER_ID	Interviewee User ID (COMPANY_USER.company_user_id)
5	CANDIDATE_ID	Candidate ID
6	SENT_BY_USER_ID	Sent by User ID (COMPANY_USER.company_user_id)
7	JOB_ID	Job ID
8	WORKFLOW_ID	Workflow ID
9	STATUS	Status
10	VIDEO_FORM_EVALUATION_REQUEST_COUNT	Video form evaluation request count
11	VIDEO_FORM_EVALUATION_COMPLETED_COUNT	Video form evaluation completed count
12	VIDEO_FORM_ID	Video form ID
13	VIDEO_FORM_RESPONSE_CREATE_DATE	Video form response created date timestamp
14	VIDEO_FORM_RESPONSE_UPDATE_DATE	Video form response last updated date timestamp
15	VIDEO_FORM_RESPONSE_SENT_DATE	Video form response sent date timestamp
16	VIDEO_FORM_RESPONSE_VIEW_DATE	Video form response viewed date timestamp
17	VIDEO_FORM_RESPONSE_DEADLINE_DATE	Video form response deadline date
18	VIDEO_FORM_RESPONSE_COMPLETION_DATE	Video form response completion date timestamp

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
VIDEO_FORM_RESPONSE_PK	PK				VIDEO_FORM_RESPONSE_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
VIDEO_FORM_RESPONSE_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
VIDEO_FORM_RESPONSE_VIDEO_FORM_FK	VIDEO_FORM	Y	Y	VIDEO_FORM_ID	VIDEO_FORM_ID
VIDEO_FORM_RESPONSE_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_RESPONSE_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FKv1	COMPANY_USER		Y	INTERVIEWEE_USER_ID	USER_ID
VIDEO_FORM_RESPONSE_COMPANY_USER_FK	COMPANY_USER	Y	Y	SENT_BY_USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_FORM_RESPONSE_FK	VIDEO_FORM_EVALUATION_QUESTION	Y	Y		VIDEO_FORM_RESPONSE_ID	VIDEO_FORM_RESPONSE_ID
VIDEO_FORM_EVALUATION_VIDEO_FORM_RESPONSE_FK	VIDEO_FORM_EVALUATION	Y	Y		VIDEO_FORM_RESPONSE_ID	VIDEO_FORM_RESPONSE_ID

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

Description
Notes

Number Of Columns	11
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	VIDEO_FORM_RESPONSE_ID		Y	VARCHAR (24)	LT
2	VIDEO_FORM_ID	F	Y	VARCHAR (24)	LT
3	APP_ID	F	Y	BIGINT	LT
4	COMPANY_ID	F	Y	BIGINT (38)	LT
5	INTERVIEWEE_USER_ID	F		BIGINT	LT
6	SENT_BY_USER_ID	F	Y	BIGINT	LT
7	CANDIDATE_ID			BIGINT	LT
8	JOB_ID	F	Y	BIGINT	LT
9	VIDEO_QUESTION_ID	F	Y	VARCHAR (24)	LT
10	VIDEO_QUESTION_RESPONSE_DURATION			BIGINT	LT
11	VIDEO_FORM_RESPONSE_UPDATE_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	VIDEO_FORM_RESPONSE_ID	Video form response ID
2	VIDEO_FORM_ID	Video form ID
3	APP_ID	Application ID
4	COMPANY_ID	Company ID
5	INTERVIEWEE_USER_ID	Interviewee User ID (COMPANY_USER.company_user_id)
6	SENT_BY_USER_ID	Sent by User ID (COMPANY_USER.company_user_id)
7	CANDIDATE_ID	Candidate ID
8	JOB_ID	Job ID
9	VIDEO_QUESTION_ID	Video Question ID
10	VIDEO_QUESTION_RESPONSE_DURATION	Video question response duration (min)
11	VIDEO_FORM_RESPONSE_UPDATE_DATE	Video form response last updated date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
VIDEO_FORM_RESPONSE_QUESTION_APPLICATION_FK	APPLICATION	Y	Y	APP_ID	APP_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_QUESTION_FK	VIDEO_QUESTION	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_FORM_FK	VIDEO_FORM	Y	Y	VIDEO_FORM_ID	VIDEO_FORM_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
VIDEO_FORM_RESPONSE_QUESTION_JOB_FK	JOB	Y	Y	JOB_ID	JOB_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FKv1	COMPANY_USER	Y	Y	SENT_BY_USER_ID	USER_ID
VIDEO_FORM_RESPONSE_QUESTION_COMPANY_USER_FK	COMPANY_USER		Y	INTERVIEWEE_USER_ID	USER_ID

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

Description
Notes

Number Of Columns	9
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	VIDEO_QUESTION_ID	P		Y	VARCHAR (24)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	USER_ID		F	Y	BIGINT	LT
4	VIDEO_QUESTION_TITLE				VARCHAR (512)	LT
5	VIDEO_QUESTION_TIME_TO_ANSWER				BIGINT	LT
6	VIDEO_QUESTION_TIME_TO_PREPARE				BIGINT	LT
7	VIDEO_QUESTION_NUMBER_OF_REDO				BIGINT	LT
8	VIDEO_QUESTION_CREATE_DATE				Timestamp	LT
9	VIDEO_QUESTION_UPDATE_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	VIDEO_QUESTION_ID	Video question ID
2	COMPANY_ID	Company ID
3	USER_ID	User ID (COMPANY_USER.company_user_id)
4	VIDEO_QUESTION_TITLE	Video question title
5	VIDEO_QUESTION_TIME_TO_ANSWER	Video question time to answer
6	VIDEO_QUESTION_TIME_TO_PREPARE	Video question time to prepare
7	VIDEO_QUESTION_NUMBER_OF_REDO	Video question number of redo's
8	VIDEO_QUESTION_CREATE_DATE	Video question created date
9	VIDEO_QUESTION_UPDATE_DATE	Video question last updated date timestamp

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
VIDEO_QUESTION_PK	PK				VIDEO_QUESTION_ID	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
VIDEO_QUESTION_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
VIDEO_QUESTION_COMPANY_USER_FK	COMPANY_USER	Y	Y		USER_ID	USER_ID

Foreign Keys (referred from)

Name	Referred From	Mandatory	Transferable	Columns	Referred Columns
VIDEO_FORM_EVALUATION_QUESTION_VIDEO_QUESTION_FK	VIDEO_FORM_EVALUATION_QUESTION	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID
VIDEO_FORM_RESPONSE_QUESTION_VIDEO_QUESTION_FK	VIDEO_FORM_RESPONSE_QUESTION	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID
VIDEO_QUESTION_FORM_MAP_VIDEO_QUESTION_FK	VIDEO_QUESTION_FORM_MAP	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID

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

Description
Notes

Number Of Columns	5
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	PK	FK	M	Data Type	DT kind
1	PRIM_KEY	P		Y	VARCHAR (49)	LT
2	COMPANY_ID		F	Y	BIGINT (38)	LT
3	VIDEO_QUESTION_ID		F	Y	VARCHAR (24)	LT
4	VIDEO_FORM_ID		F	Y	VARCHAR (24)	LT
5	VIDEO_FORM_UPDATE_DATE				Timestamp	LT

Columns Comments

No	Column Name	Description
1	PRIM_KEY	Video question form mapping primary key
2	COMPANY_ID	Company ID
3	VIDEO_QUESTION_ID	Video question ID
4	VIDEO_FORM_ID	Video Form ID
5	VIDEO_FORM_UPDATE_DATE	Video form last updated date timestamp

Indexes

Index Name	State	Functional	Spatial	Expression	Column Name	Sort Order
VIDEO_QUESTION_FORM_MAP_PK	PK				PRIM_KEY	ASC

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	Columns	Referred Columns
VIDEO_QUESTION_FORM_MAP_VIDEO_FORM_FK	VIDEO_FORM	Y	Y	VIDEO_FORM_ID	VIDEO_FORM_ID
VIDEO_QUESTION_FORM_MAP_COMPANY_FK	COMPANY	Y	Y	COMPANY_ID	COMPANY_ID
VIDEO_QUESTION_FORM_MAP_VIDEO_QUESTION_FK	VIDEO_QUESTION	Y	Y	VIDEO_QUESTION_ID	VIDEO_QUESTION_ID

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

Description
Notes

Number Of Columns	11
Number Of Rows Min.	0
Number Of Rows Max.	9999999
Expected Number Of Rows	0
Expected Growth	0
Growth Interval	Year

Used In Diagrams

Diagram Name

Jobvite Data Exchange

Columns

No	Column Name	FK	M	Data Type	DT kind
1	APP_ID	F	Y	BIGINT	LT
2	COMPANY_ID	F	Y	BIGINT (38)	LT
3	CANDIDATE_ID			BIGINT	LT
4	WORK_HISTORY_COMPANY_NAME			VARCHAR (100)	LT
5	WORK_HISTORY_TITLE			VARCHAR (100)	LT
6	WORK_HISTORY_INDUSTRY			VARCHAR (100)	LT
7	WORK_HISTORY_START_MONTH			VARCHAR (2)	LT
8	WORK_HISTORY_START_YEAR			VARCHAR (4)	LT
9	WORK_HISTORY_END_MONTH			VARCHAR (2)	LT
10	WORK_HISTORY_END_YEAR			VARCHAR (4)	LT
11	WORK_HISTORY_MODIFIED_DATE			Timestamp	LT

Columns Comments

No	Column Name	Description
1	APP_ID	Application ID
2	COMPANY_ID	Company ID
3	CANDIDATE_ID	Candidate ID
4	WORK_HISTORY_COMPANY_NAME	Work history company name
5	WORK_HISTORY_TITLE	Work history title
6	WORK_HISTORY_INDUSTRY	Work history industry
7	WORK_HISTORY_START_MONTH	Work history start month
8	WORK_HISTORY_START_YEAR	Work history start year
9	WORK_HISTORY_END_MONTH	Work history end month
10	WORK_HISTORY_END_YEAR	Work history end year
11	WORK_HISTORY_MODIFIED_DATE	Work history last modified date timestamp

Foreign Keys (referring to)

Name	Refering To	Mandatory	Transferable	In Arc	Columns	Referred Columns	Delete Rule
WORK_HISTORY_COMPANY_FK	COMPANY	Y	Y		COMPANY_ID	COMPANY_ID
WORK_HISTORY_APPLICATION_FK	APPLICATION	Y	Y		APP_ID	APP_ID