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_PAYRUNS
☰
Info
Version :
1
Date Modified :
26-Nov-2021 10:22
Author : JEscott
More Info...
Attachments
Reading time: 0.3 mins, 70 words
E
dit
More...
View Page Source
Show Reader View
Wiki Formatting
Main
This is version
1
2
3
4
5
. It is not the current version, and thus it cannot be edited.
Back to current version
Restore this version
Alias: IVPPRN
#
(INF_CV_PAYRUNS)
Pay Runs
Table Columns
#
Column name
Data Type / Size
Domain
Mand.
Notes
ID
Number(10)
ID
ENTITY_CODE
Varchar2(16)
CODE
Y
PAY_RUN_NUMBER
Number(10)
NUMBER10
Y
USER_NAME
Varchar2(30)
VARCHAR30
Y
PAYROLL_CODE
Varchar2(16)
CODE
Y
PAY_POINT_SET_CODE
Varchar2(16)
CODE
Y
PAY_CALENDAR_CODE
Varchar2(16)
CODE
Y
PAY_PERIOD
Number(10)
NUMBER10
Y
PAY_RUN_STAGE
Varchar2(30)
VARCHAR30
Y
PAY_PERIOD_FUTURE
Number(10)
NUMBER10
COUNTRY_CODE
Varchar2(16)
CODE
BANK_TRANSIT_CODE
Varchar2(16)
CODE
BANK_ACCOUNT
Varchar2(30)
VARCHAR30
STARTING_NUMBER
Number(10)
NUMBER10
PAY_RUN_START_TIMESTAMP
Date()
TIMESTAMP
PAY_RUN_END_TIMESTAMP
Date()
TIMESTAMP
EMPLOYEE_COUNT
Number(5)
NUMBER5
REVERSAL_PAY_COUNT
Number(5)
NUMBER5
ADJUSTMENT_PAY_COUNT
Number(5)
NUMBER5
CURRENT_PAY_COUNT
Number(5)
NUMBER5
FUTURE_PAY_COUNT
Number(5)
NUMBER5
ADVANCE_PAY_COUNT
Number(5)
NUMBER5
BONUS_PAY_COUNT
Number(5)
NUMBER5
RETROACTIVE_PAY_COUNT
Number(5)
NUMBER5
DISBURSED
Varchar2(4)
VARCHAR4
TRIAL_RUN
Varchar2(4)
VARCHAR4
JOURNALIZED
Varchar2(4)
VARCHAR4
JOURNALIZED_FUND
Varchar2(4)
VARCHAR4
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