This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 3 KB jmyers to previous WORK_RULE_CODE ==> WORK_RULE (Field)
9 26-Nov-2021 10:22 3 KB jmyers to previous | to last
8 26-Nov-2021 10:22 3 KB JMyers to previous | to last
7 26-Nov-2021 10:22 11 KB JMyers to previous | to last
6 26-Nov-2021 10:22 11 KB JMyers to previous | to last
5 26-Nov-2021 10:22 10 KB JMyers to previous | to last
4 26-Nov-2021 10:22 10 KB JMyers to previous | to last
3 26-Nov-2021 10:22 10 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IVDWR
IVDWR

Version management

Difference between version and

At line 1 changed 2 lines
!!!Alias: [IVDWR]
(INF_CV_WORKRULES)
[{TableOfContents }]
!!!WORK RULES INTERFACE FILE
At line 4 changed one line
The INF_CV_WORKRULES table is used to import work rule codes and their attendant data into the software data structures.
The Work Rules Interface File screen is used to import work rule codes into the software data structures.
At line 6 changed 46 lines
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ENTITY_CODE]|Varchar2(16)|Y|Validation: Must be a valid entity code defined on [P2K_CM_ENTITIES].
|[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()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
Work Rules Interface File data is maintained on the [INF_CV_WORKRULES] table.
At line 53 changed 3 lines
[{If var='loginstatus' contains 'authenticated'
;[ID|ID]:This field uniquely identifies the unit record within the data base.
;[Entity|ENTITY_CODE]:This field displays the entity to which the work rule belongs.
;[Work Rule|WORK_RULE (Field)]:Work rules are used to determine standard processing information required in creating pay headers and transactions for a person.
;[Standing|STANDING]:This field indicates whether this work rule is active, obsolete or frozen.
;[Effective As Of|EFFECTIVE]/[Expires On|EXPIRY]:If the group is temporary, these fields will define the dates the work rule is effective.
;[Change Reason|CHANGE_CODE]:This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date.
;[Work Calendar|WORK_CALENDAR_CODE]:This is the work calendar code to be used for this work rule, if applicable. If no calendar is supplied, the system will assume MON-FRI workweek.
;[First Day of Week|FIRST_DAY_OF_WEEK]:The field shows the first day of the week the pay period begins.
;[Pieces Per Day|PIECES_PER_DAY]:This field shows the standard number of pieces per day an employee produces. Example: A seamstress sews 14 shirts (pieces).
;[Std Hours Per Day|STD_HOURS_PER_DAY]:This field shows the standard number of hours per day.
;[Std Hours Per Week|STD_HOURS_PER_WEEK]:This field shows the standard number of hours per week.
;[Std Hours Per Pay|STD_HOURS_PER_PAY]:This field shows the standard number of hours in a pay period.
;[Weeks Per Year|WEEKS_PER_YEAR]:This field shows the standard number of weeks in a year (default is 52).
;[Months Per Year|MONTHS_PER_YEAR]:This is the standard number of months in a year (default is 12).
;[Pays Per Contract|PAYS_PER_CONTRACT]:This field identifies how many pays will be covered in this contract.
;[Work Is Scheduled|WORK_IS_SCHEDULED]:This field indicates that the transactions generated through the Transaction Generator ([UPTG]) into Pay Transactions ([IPTR]) must always be equivalent to the time scheduled.
;[Must Be Acknowledged|MUST_BE_ACKNOWLEDGED]:
;[Time Rounding Rule|TIME_ROUNDING_RULE]:This field indicates how the time an employee works should be rounded, if at all.
;[Time Rounding Factor|TIME_ROUNDING_FACTOR]:This field indicates to what decimal point the time should be rounded.
;[Pay Starting Date|PAY_STARTING_DATE]:This field identifies the day when the pay for this work rule will commence.
;[Group Source|GROUP_SOURCE]:This is the group source for pay headers to be created.
;[Work In Restriction Rule|WORK_IN_RESTRICTION_RULE]:This field specifies if the work is to be done in a specific department.
;[Overtime Time Code|TIME_CODE_OVERTIME]:This field allows you to provide a unique code to identify the overtime being recorded.
;[Time Sheet Required|TIMESHEET_REQUIRED]:This field indicates if the employees are required to submit some kind of record (paper or electronic) of their work and/or attendance.
;[Time Generation Rule|TIME_GENERATION_RULE]:This field indicates the type of time transactions that must be generated for a person.
;[Generate Headers|GENERATE_HEADERS]:This field indicates if pay headers will be generated for all employees who have this work rule.
At line 57 changed 2 lines
![Discussion|Edit:Internal.INF_CV_WORKRULES]
[{InsertPage page='Internal.INF_CV_WORKRULES' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVDWR]
[{InsertPage page='Internal.IVDWR' default='Click to create a new notes page'}]
At line 60 removed one line
}]
This page (revision-10) was last changed on 26-Nov-2021 10:22 by jmyersTop