Design Name | JobviteDataWarehouseERD |
Version Date | 18.05.2020 11:01:06 |
Version Comment | |
Model Name | Jobvite_QA_DataWarehouse |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
AGENCY_JOB_PK | PK | AGENCY_JOB_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
AGENCY_USER_PK | PK | AGENCY_USER_ID | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 () |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
APPLICATION_PK | PK | APP_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
APPROVER_PK | PK | APPROVER_ID | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
CAMPAIGN_CONTACT_PK | PK | CAMPAIGN_CONTACT_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
CANDIDATE_WORKFLOW_PK | PK | APP_WORKFLOW_WORKFLOW_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
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 | |||||
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
COMPANY_USER_PK | PK | USER_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
COMPANY_USER_COMPANY_FK | COMPANY | Y | Y | COMPANY_ID | COMPANY_ID |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
COMPLIANCE_PK | PK | COMPLIANCE_ID | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
CONTACT_PK | PK | CONTACT_ID | ASC |
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 |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
CONTACT_STATUS_HISTORY_PK | PK | CONTACT_STATUS_HISTORY_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
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 |
No | Column Name | Description | Notes |
---|---|---|---|
1 | USER_ID | User ID (COMPANY_USER.company_user_id) | |
2 | COMPANY_ID | Company ID |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ENGAGE_USER_PK | PK | USER_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
ENGAGE_USER_COMPANY_FK | COMPANY | Y | Y | COMPANY_ID | COMPANY_ID |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
GDPR_ONBOARDING_ENTITY_PK | PK | ONB_ENTITY_ID | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
INTERVIEW_PK | PK | INTERVIEW_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
INTERVIEW_EVALUATION_PK | PK | INTERVIEW_EVALUATION_ID | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
JOB_PK | PK | JOB_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
JOB_COMPANY_FK | COMPANY | Y | Y | COMPANY_ID | COMPANY_ID |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
JOB_OPEN_HISTORY_PK | PK | JOB_OPEN_PRIMARY_KEY | ASC |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
JOB_OWNER_PK | PK | JOB_OWNER_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
OFCCP_SEARCH_PK | PK | SEARCH_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ONBOARDING_NEW_HIRE_PK | PK | ONB_NEW_HIRE_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ONBOARDING_PROCESS_PK | PK | ONB_PROCESS_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ONBOARDING_PROCESS_TEMPLATE_PK | PK | ONB_PROCESS_TEMPLATE_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ONBOARDING_TASK_PK | PK | ONB_TASK_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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) |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
ONBOARDING_TASK_TEMPLATE_PK | PK | ONB_TASK_TEMPLATE_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
ONBOARDING_TASK_TEMPLATE_COMPANY_FK | COMPANY | Y | Y | COMPANY_ID | COMPANY_ID |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
SCREENING_FORM_PK | PK | SCREENING_FORM_ID | ASC |
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
VIDEO_FORM_EVALUATION_PK | PK | VIDEO_FORM_EVALUATION_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
VIDEO_FORM_RESPONSE_PK | PK | VIDEO_FORM_RESPONSE_ID | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
VIDEO_QUESTION_PK | PK | VIDEO_QUESTION_ID | ASC |
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 |
Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
Index Name | State | Functional | Spatial | Expression | Column Name | Sort Order |
---|---|---|---|---|---|---|
VIDEO_QUESTION_FORM_MAP_PK | PK | PRIM_KEY | ASC |
Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule |
---|---|---|---|---|---|---|---|
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 |
Diagram Name |
Jobvite Data Exchange |
No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation |
---|---|---|---|---|---|---|---|---|---|---|
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 |
No | Column Name | Description | Notes |
---|---|---|---|
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 |
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 |