Personality Knowledgebase 5.05
HighLine
Wiki
G’day (anonymous guest)
User Preferences
Log in
Register a new user!
For full search, hit enter...
Recent Searches
INF_CV_DEPARTMENTS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.3 mins, 77 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVDDP
#
(INF_CV_DEPARTMENTS)
Date sensitive department information.
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE_SUB_DIVISION
Varchar2(16)
CODE
Y
ENTITY_CODE_LEGAL
Varchar2(16)
CODE
DEPARTMENT_CODE
Varchar2(16)
CODE
Y
STANDING
Varchar2(30)
VARCHAR30
GENERIC_CODE
Varchar2(16)
CODE
EFFECTIVE
Date()
EFFECTIVE
EXPIRY
Date()
EXPIRY
CHANGE_CODE
Varchar2(16)
CODE
DEPARTMENT_NAME
Varchar2(50)
VARCHAR50
Y
LOCATION_CODE_LOCATED_IN
Varchar2(16)
CODE
WORK_RULE_CODE
Varchar2(16)
CODE
PERSON_CODE
Varchar2(16)
CODE
LOCATION_CODE_PAYDEST
Varchar2(16)
CODE
AUTHORIZATION_CODE
Varchar2(16)
CODE
POSITION_CODE
Varchar2(16)
CODE
DISTRIBUTION_MASK
Varchar2(50)
DISTRIBUTION
BURDEN_PERCENT
Number(5)
PERCENT
PHONE_NUMBER
Varchar2(20)
TELEPHONE
PHONE_EXTENSION
Varchar2(16)
VARCHAR16
FAX_NUMBER
Varchar2(20)
TELEPHONE
EMAIL_ADDRESS
Varchar2(50)
EMAIL
EEOC_FUNCTION
Varchar2(30)
VARCHAR30
BATCH_CODE
Varchar2(16)
CODE
INDUSTRY_CODE
Varchar2(16)
CODE
OFFICE_CODE
Varchar2(16)
CODE
BURDEN_METHOD
Varchar2(30)
VARCHAR30
DEPARTMENT_CODE_REPORTING_TO
Varchar2(16)
CODE
CREATE_DATE
Date()
DATE
CREATE_USER
Varchar2(30)
VARCHAR30
CHANGE_DATE
Date()
DATE
CHANGE_USER
Varchar2(30)
VARCHAR30
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help