OEB_PER_ALL_ASSIGNMENTS_F

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ASSIGNMENT_ID BIGINT 8
2 EFFECTIVE_START_DATE TIMESTAMP 8
3 EFFECTIVE_END_DATE TIMESTAMP 8
4 BUSINESS_GROUP_ID BIGINT 8
5 RECRUITER_ID BIGINT 8
6 GRADE_ID BIGINT 8
7 POSITION_ID BIGINT 8
8 JOB_ID BIGINT 8
9 ASSIGNMENT_STATUS_TYPE_ID BIGINT 8
10 PAYROLL_ID BIGINT 8
11 LOCATION_ID BIGINT 8
12 PERSON_REFERRED_BY_ID BIGINT 8
13 SUPERVISOR_ID BIGINT 8
14 SPECIAL_CEILING_STEP_ID BIGINT 8
15 PERSON_ID BIGINT 8
16 RECRUITMENT_ACTIVITY_ID BIGINT 8
17 SOURCE_ORGANIZATION_ID BIGINT 8
18 ORGANIZATION_ID BIGINT 8
19 PEOPLE_GROUP_ID BIGINT 8
20 SOFT_CODING_KEYFLEX_ID BIGINT 8
21 VACANCY_ID BIGINT 8
22 PAY_BASIS_ID BIGINT 8
23 ASSIGNMENT_SEQUENCE BIGINT 8
24 ASSIGNMENT_TYPE CHARACTER VARYING(1) 1
25 PRIMARY_FLAG CHARACTER VARYING(30) 30
26 APPLICATION_ID BIGINT 8
27 ASSIGNMENT_NUMBER CHARACTER VARYING(30) 30
28 CHANGE_REASON CHARACTER VARYING(30) 30
29 COMMENT_ID BIGINT 8
30 DATE_PROBATION_END TIMESTAMP 8
31 DEFAULT_CODE_COMB_ID BIGINT 8
32 EMPLOYMENT_CATEGORY CHARACTER VARYING(30) 30
33 FREQUENCY CHARACTER VARYING(30) 30
34 INTERNAL_ADDRESS_LINE CHARACTER VARYING(80) 80
35 MANAGER_FLAG CHARACTER VARYING(30) 30
36 NORMAL_HOURS NUMERIC(22,3) 19
37 PERF_REVIEW_PERIOD BIGINT 8
38 PERF_REVIEW_PERIOD_FREQUENCY CHARACTER VARYING(30) 30
39 PERIOD_OF_SERVICE_ID BIGINT 8
40 PROBATION_PERIOD NUMERIC(22,2) 19
41 PROBATION_UNIT CHARACTER VARYING(30) 30
42 SAL_REVIEW_PERIOD BIGINT 8
43 SAL_REVIEW_PERIOD_FREQUENCY CHARACTER VARYING(30) 30
44 SET_OF_BOOKS_ID BIGINT 8
45 SOURCE_TYPE CHARACTER VARYING(30) 30
46 TIME_NORMAL_FINISH CHARACTER VARYING(5) 5
47 TIME_NORMAL_START CHARACTER VARYING(5) 5
48 BARGAINING_UNIT_CODE CHARACTER VARYING(30) 30
49 LABOUR_UNION_MEMBER_FLAG CHARACTER VARYING(30) 30
50 HOURLY_SALARIED_CODE CHARACTER VARYING(30) 30
51 REQUEST_ID BIGINT 8
52 PROGRAM_APPLICATION_ID BIGINT 8
53 PROGRAM_ID BIGINT 8
54 PROGRAM_UPDATE_DATE TIMESTAMP 8
55 ASS_ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
56 ASS_ATTRIBUTE1 CHARACTER VARYING(150) 150
57 ASS_ATTRIBUTE2 CHARACTER VARYING(150) 150
58 ASS_ATTRIBUTE3 CHARACTER VARYING(150) 150
59 ASS_ATTRIBUTE4 CHARACTER VARYING(150) 150
60 ASS_ATTRIBUTE5 CHARACTER VARYING(150) 150
61 ASS_ATTRIBUTE6 CHARACTER VARYING(150) 150
62 ASS_ATTRIBUTE7 CHARACTER VARYING(150) 150
63 ASS_ATTRIBUTE8 CHARACTER VARYING(150) 150
64 ASS_ATTRIBUTE9 CHARACTER VARYING(150) 150
65 ASS_ATTRIBUTE10 CHARACTER VARYING(150) 150
66 ASS_ATTRIBUTE11 CHARACTER VARYING(150) 150
67 ASS_ATTRIBUTE12 CHARACTER VARYING(150) 150
68 ASS_ATTRIBUTE13 CHARACTER VARYING(150) 150
69 ASS_ATTRIBUTE14 CHARACTER VARYING(150) 150
70 ASS_ATTRIBUTE15 CHARACTER VARYING(150) 150
71 ASS_ATTRIBUTE16 CHARACTER VARYING(150) 150
72 ASS_ATTRIBUTE17 CHARACTER VARYING(150) 150
73 ASS_ATTRIBUTE18 CHARACTER VARYING(150) 150
74 ASS_ATTRIBUTE19 CHARACTER VARYING(150) 150
75 ASS_ATTRIBUTE20 CHARACTER VARYING(150) 150
76 ASS_ATTRIBUTE21 CHARACTER VARYING(150) 150
77 ASS_ATTRIBUTE22 CHARACTER VARYING(150) 150
78 ASS_ATTRIBUTE23 CHARACTER VARYING(150) 150
79 ASS_ATTRIBUTE24 CHARACTER VARYING(150) 150
80 ASS_ATTRIBUTE25 CHARACTER VARYING(150) 150
81 ASS_ATTRIBUTE26 CHARACTER VARYING(150) 150
82 ASS_ATTRIBUTE27 CHARACTER VARYING(150) 150
83 ASS_ATTRIBUTE28 CHARACTER VARYING(150) 150
84 ASS_ATTRIBUTE29 CHARACTER VARYING(150) 150
85 ASS_ATTRIBUTE30 CHARACTER VARYING(150) 150
86 LAST_UPDATE_DATE TIMESTAMP 8
87 LAST_UPDATED_BY BIGINT 8
88 LAST_UPDATE_LOGIN BIGINT 8
89 CREATED_BY BIGINT 8
90 CREATION_DATE TIMESTAMP 8
91 TITLE CHARACTER VARYING(30) 30
92 OBJECT_VERSION_NUMBER BIGINT 8
93 CONTRACT_ID BIGINT 8
94 COLLECTIVE_AGREEMENT_ID BIGINT 8
95 CAGR_ID_FLEX_NUM BIGINT 8
96 CAGR_GRADE_DEF_ID BIGINT 8
97 ESTABLISHMENT_ID BIGINT 8
98 APPLICANT_RANK BIGINT 8
99 NOTICE_PERIOD BIGINT 8
100 NOTICE_PERIOD_UOM CHARACTER VARYING(30) 30
101 EMPLOYEE_CATEGORY CHARACTER VARYING(30) 30
102 WORK_AT_HOME CHARACTER VARYING(30) 30
103 JOB_POST_SOURCE_NAME CHARACTER VARYING(240) 240
104 POSTING_CONTENT_ID BIGINT 8
105 PERIOD_OF_PLACEMENT_DATE_START TIMESTAMP 8
106 VENDOR_ID BIGINT 8
107 VENDOR_SITE_ID BIGINT 8
108 PO_HEADER_ID BIGINT 8
109 PO_LINE_ID BIGINT 8
110 PROJECTED_ASSIGNMENT_END TIMESTAMP 8
111 VENDOR_EMPLOYEE_NUMBER CHARACTER VARYING(30) 30
112 VENDOR_ASSIGNMENT_NUMBER CHARACTER VARYING(30) 30
113 ASSIGNMENT_CATEGORY CHARACTER VARYING(30) 30
114 PROJECT_TITLE CHARACTER VARYING(30) 30
115 GRADE_LADDER_PGM_ID BIGINT 8
116 SUPERVISOR_ASSIGNMENT_ID BIGINT 8
117 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
118 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
119 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
120 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8