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 9 changed 27 lines
INF_CV_PAYRUNS|[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)| |
;[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 37 removed 4 lines
[{If var='loginstatus' contains 'authenticated'
At line 42 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 45 removed one line
}]
This page (revision-14) was last changed on 26-Nov-2021 10:22 by JMyersTop