Alias: PBT#

(P2K_PR_BATCHES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR45

Batches

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
BATCH_NUMBER	Number(10)	NUMBER10	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
MUS_ID	Number(10)	ID	Y	link to P2K_AM_USERS
PPA_ID	Number(10)	ID	Y	link to P2K_PR_PAYROLLS
PPP_ID	Number(10)	ID	Y	link to P2K_PR_PAY_PERIODS
PCT_ID	Number(10)	ID	Y	link to P2K_PR_PAY_CATEGORIES
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
DAA_ID	Number(10)	ID		link to P2K_CM_AUTHORIZATION_AREAS
BATCH_STATUS	Varchar2(2)	X_BATCH_STATUS	Y
BATCH_TYPE	Varchar2(2)	X_BATCH_TYPE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
BATCH_SOURCE	Varchar2(2)	X_BATCH_SOURCE	Y
BATCH_CODE	Varchar2(16)	CODE
AUDITED	Varchar2(1)	TOGGLE
BALANCED	Varchar2(1)	TOGGLE
ELIGIBLE	Varchar2(1)	TOGGLE
BEING_USED_BY	Varchar2(30)	VARCHAR30
BATCHED_BY	Varchar2(16)	X_BATCH_BY
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
EAS_ID	Number(10)	ID		link to P2K_HR_ASSIGNMENTS to identify the manager
POSTED_EXPERIENCE	Varchar2(1)	TOGGLE
MEX_ID	Number(10)	ID		link to P2K_AM_EXECUTIONS to identify the process that created a batch

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_OPEN_PAY_HEADERS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page