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_WORKRULES
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : RForbes
More Info...
Attachments
Reading time: 0.4 mins, 101 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
6
7
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVDWR
#
(INF_CV_WORKRULES)
Hours per specific day of a period
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
WORK_RULE_CODE
Varchar2(16)
CODE
Y
STANDING
Varchar2(30)
VARCHAR30
EFFECTIVE
Date()
EFFECTIVE
Y
EXPIRY
Date()
EXPIRY
Y
CHANGE_CODE
Varchar2(16)
CODE
WORK_CALENDAR_CODE
Varchar2(16)
CODE
HOLIDAY_CALENDAR_CODE
Varchar2(16)
CODE
DESCRIPTION
Varchar2(50)
VARCHAR50
FIRST_DAY_OF_WEEK
Varchar2(30)
VARCHAR30
PIECES_PER_DAY
Number(9)
AMT5V4
STD_HOURS_PER_DAY
Number(9)
AMT5V4
STD_HOURS_PER_WEEK
Number(9)
AMT5V4
STD_HOURS_PER_PAY
Number(9)
AMT5V4
WEEKS_PER_YEAR
Number(9)
AMT5V4
MONTHS_PER_YEAR
Number(9)
AMT5V4
PAYS_PER_CONTRACT
Number(5)
NUMBER5
FLSA_METHOD
Varchar2(30)
VARCHAR30
FLOAT_DAYS_ALLOWED
Number(5)
NUMBER5
WORK_IS_SCHEDULED
Varchar2(4)
VARCHAR4
MUST_BE_ACKNOWLEDGED
Varchar2(4)
VARCHAR4
TIME_ROUNDING_RULE
Varchar2(30)
VARCHAR30
TIME_ROUNDING_FACTOR
Number(9)
AMT5V4
PAY_STARTING_DATE
Date()
DATE
GROUP_SOURCE
Varchar2(30)
VARCHAR30
WORK_IN_RESTRICTION_RULE
Varchar2(30)
VARCHAR30
STATUS_CODE
Varchar2(16)
CODE
TIME_CODE_REGULAR
Varchar2(16)
CODE
TIME_CODE_SALARY
Varchar2(16)
CODE
TIME_CODE_OVERTIME
Varchar2(16)
CODE
TIMESHEET_REQUIRED
Varchar2(30)
VARCHAR30
TIME_GENERATION_RULE
Varchar2(30)
VARCHAR30
GENERATE_HEADERS
Varchar2(30)
VARCHAR30
GENERATE_DETAILS
Varchar2(30)
VARCHAR30
GENERATE_HOLIDAYS
Varchar2(30)
VARCHAR30
ACCUMULATE_EXPERIENCE
Varchar2(30)
VARCHAR30
SIGN_OFF_TYPE
Varchar2(30)
VARCHAR30
TIME_GENERATION_DESTINATION
Varchar2(30)
VARCHAR30
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