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 :
3
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.5 mins, 111 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
#
The INF_CV_WORKRULES table is used to import work rule codes and their attendant data into the software data structures.
Table Columns
#
Column name
Data Type / Size
Mand.
Notes
ID
Number(10)
ENTITY_CODE
Varchar2(16)
Y
WORK_RULE_CODE
Varchar2(16)
Y
STANDING
Varchar2(30)
EFFECTIVE
Date()
Y
EXPIRY
Date()
Y
CHANGE_CODE
Varchar2(16)
WORK_CALENDAR_CODE
Varchar2(16)
HOLIDAY_CALENDAR_CODE
Varchar2(16)
DESCRIPTION
Varchar2(50)
FIRST_DAY_OF_WEEK
Varchar2(30)
PIECES_PER_DAY
Number(9)
STD_HOURS_PER_DAY
Number(9)
STD_HOURS_PER_WEEK
Number(9)
STD_HOURS_PER_PAY
Number(9)
WEEKS_PER_YEAR
Number(9)
MONTHS_PER_YEAR
Number(9)
PAYS_PER_CONTRACT
Number(5)
FLSA_METHOD
Varchar2(30)
FLOAT_DAYS_ALLOWED
Number(5)
WORK_IS_SCHEDULED
Varchar2(4)
MUST_BE_ACKNOWLEDGED
Varchar2(4)
TIME_ROUNDING_RULE
Varchar2(30)
TIME_ROUNDING_FACTOR
Number(9)
PAY_STARTING_DATE
Date()
GROUP_SOURCE
Varchar2(30)
WORK_IN_RESTRICTION_RULE
Varchar2(30)
STATUS_CODE
Varchar2(16)
TIME_CODE_REGULAR
Varchar2(16)
TIME_CODE_SALARY
Varchar2(16)
TIME_CODE_OVERTIME
Varchar2(16)
TIMESHEET_REQUIRED
Varchar2(30)
TIME_GENERATION_RULE
Varchar2(30)
GENERATE_HEADERS
Varchar2(30)
GENERATE_DETAILS
Varchar2(30)
GENERATE_HOLIDAYS
Varchar2(30)
ACCUMULATE_EXPERIENCE
Varchar2(30)
SIGN_OFF_TYPE
Varchar2(30)
TIME_GENERATION_DESTINATION
Varchar2(30)
CREATE_DATE
Date()
CREATE_USER
Varchar2(30)
CHANGE_DATE
Date()
CHANGE_USER
Varchar2(30)
Hello, 10.86.0.2
Index
Recent Updates
Wiki Formatting
Search Help