This page (revision-14) 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
14 26-Nov-2021 10:22 3 KB JMyers to previous
13 26-Nov-2021 10:22 3 KB JMyers to previous | to last
12 26-Nov-2021 10:22 7 KB JMyers to previous | to last
11 26-Nov-2021 10:22 7 KB JMyers to previous | to last
10 26-Nov-2021 10:22 7 KB JMyers to previous | to last
9 26-Nov-2021 10:22 6 KB JMyers to previous | to last
8 26-Nov-2021 10:22 6 KB JMyers to previous | to last
7 26-Nov-2021 10:22 6 KB JMyers to previous | to last
6 26-Nov-2021 10:22 5 KB JMyers to previous | to last
5 26-Nov-2021 10:22 5 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 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 1 KB JMyers to last

Page References

Incoming links Outgoing links
IVPPRN
IVPPRN

Version management

Difference between version and

At line 1 changed 2 lines
!!!Alias: [IVPPRN]
(INF_CV_PAYRUNS)
[{TableOfContents }]
!!!CANADIAN PAY RUN INTERFACE FILE
At line 4 changed one line
The INF_CV_PAYRUNS table is used to import historical payroll information at a payrun level into the software data structures.
The Canadian Pay Run Interface File screen is used to import historical payroll information at a payrun level into the software data structures.
At line 6 changed 31 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|
|[PAY_RUN_NUMBER]|Number(10)|Y|
|[USER_NAME]|Varchar2(30)|Y|
|[PAYROLL_CODE]|Varchar2(16)|Y|
|[PAY_POINT_SET_CODE]|Varchar2(16)|Y|
|[PAY_CALENDAR_CODE]|Varchar2(16)|Y|
|[PAY_PERIOD]|Number(10)|Y|
|[PAY_RUN_STAGE]|Varchar2(30)|Y|Validation: Must be one of the fixed lexicon values from [X_PAY_RUN_STAGE]
|[PAY_PERIOD_FUTURE]|Number(10)| |
|[COUNTRY_CODE]|Varchar2(16)| |
|[BANK_TRANSIT_CODE]|Varchar2(16)| |
|[BANK_ACCOUNT]|Varchar2(30)| |
|[STARTING_NUMBER]|Number(10)| |
|[PAY_RUN_START_TIMESTAMP]|Date()| |Validation: Must be a valid date.
|[PAY_RUN_END_TIMESTAMP]|Date()| |Validation: Must be a valid date.
|[EMPLOYEE_COUNT]|Number(5)| |
|[REVERSAL_PAY_COUNT]|Number(5)| |
|[ADJUSTMENT_PAY_COUNT]|Number(5)| |
|[CURRENT_PAY_COUNT]|Number(5)| |
|[FUTURE_PAY_COUNT]|Number(5)| |
|[ADVANCE_PAY_COUNT]|Number(5)| |
|[BONUS_PAY_COUNT]|Number(5)| |
|[RETROACTIVE_PAY_COUNT]|Number(5)| |
|[DISBURSED]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
|[TRIAL_RUN]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True
|[JOURNALIZED]|Varchar2(4)| |
|[JOURNALIZED_FUND]|Varchar2(4)| |
Canadian Pay Run Interface File data is maintained on the [INF_CV_PAYRUNS] table.
At line 8 added 28 lines
;[ID|ID]:This field uniquely identifies the Canadian pay run record within the data base.
;[Entity|ENTITY_CODE]:This field displays the entity associated with the pay run.
;[Pay Run|PAY_RUN_NUMBER]:This field displays the unique sequential number assigned to a pay run by the pay calculation process.
;[User|USER_NAME]:This field displays the user id of the person who ran [UPCALC].
;[Payroll|PAYROLL_CODE]:This field shows the payroll that was calculated for this payrun.
;[Pay Point Set|PAY_POINT_SET_CODE]:The pay point set is a set of payroll calculation instructions to be executed for this payroll during the pay cycle. These pay point sets are defined in the [IPPP] screen.
;[Pay Calendar|PAY_CALENDAR_CODE]:This field defines which calendar is to be used for this payroll.
;[Pay Period|PAY_PERIOD]:This field identifies the pay period for which the pay run is calculated.
;[Stage|PAY_RUN_STAGE]:This field indicates the stage the pay run is in.
;[Pay Period Future|PAY_PERIOD_FUTURE]:This field identifies the period for any ‘advance’ pays that were calculated.
;[Country Name|COUNTRY_CODE]:This field identifies the county associated with the pay run.
;[Bank Transit|BANK_TRANSIT_CODE]:The bank associated with the pay run is defined in this field.
;[Bank Account|BANK_ACCOUNT]:The bank account associated with the pay run is defined in this field.
;[Starting Number|STARTING_NUMBER]:This field indicates the number of the first check in the series for the pay run.
;[Start Date/Time|PAY_RUN_START_TIMESTAMP]:This field indicates the date and time that the payrun started ([UPCALC]).
;[End Date/Time|PAY_RUN_END_TIMESTAMP]:This field indicates the date and time that the payrun ended.
;[Employees|EMPLOYEE_COUNT]:This field displays the number of employees in the pay run.
;[Reversal Pays|REVERSAL_PAY_COUNT]:This field shows the total of reversal category headers in the pay run.
;[Adjustment Pays|ADJUSTMENT_PAY_COUNT]:This is the total of adjustment category headers in the pay run.
;[Current Pays|CURRENT_PAY_COUNT]:This field shows the total of regular category headers in the pay run.
;[Future Pays|FUTURE_PAY_COUNT]:This is the total of future category headers in the pay run.
;[Advance Pays|ADVANCE_PAY_COUNT]:This is the total of advance category headers in the pay run.
;[Bonus Pays|BONUS_PAY_COUNT]:This is the total of bonus category headers in the pay run.
;[Retro Pays|RETROACTIVE_PAY_COUNT]:This is the total of retroactive category headers in the pay run.
;[Disbursed|DISBURSED]:This field indicates if the pays in this payrun have been disbursed ([UPDISB]).
;[Trial Run|TRIAL_RUN]:This field indicates if the update is committed or not.
;[Journalized|JOURNALIZED]:This field indicates if all of the pay lines and pay amounts for this header have been processed through the journalizing process.
;[Journalized Fund|JOURNALIZED_FUND]:This field indicates if the GL Fund processing has been run for this pay run.
At line 39 removed 3 lines
[{If var='loginstatus' contains 'authenticated'
At line 43 changed 2 lines
![Discussion|Edit:Internal.IVPPRN]
[{InsertPage page='Internal.IVPPRN' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVPPRN]
[{InsertPage page='Internal.IVPPRN' default='Click to create a new notes page'}]
At line 46 removed one line
}]
This page (revision-14) was last changed on 26-Nov-2021 10:22 by JMyersTop