P 2 K_TS_TIME_BATCHES

Alias: TBT#

(P2K_TS_TIME_BATCHES)

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


Time Batches

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
PPA_IDNumber(10)ID link to P2K_PR_PAYROLLS
TWA_IDNumber(10)ID link to P2K_TS_WORK_AREAS
TWT_IDNumber(10)ID link to P2K_TS_WORK_TEAMS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
DAA_IDNumber(10)ID link to P2K_CM_AUTHORIZATION_AREAS
MEX_IDNumber(10)ID link to P2K_AM_EXECUTIONS
TIME_BATCH_NUMBERNumber(10)NUMBER10Y
TIME_BATCH_CODEVarchar2(16)CODEY
TIME_BATCH_STATUSVarchar2(2)X_TIME_BATCH_STATUSY
TIME_BATCH_SOURCEVarchar2(2)X_TIME_BATCH_SOURCEY
BATCH_FROM_DATEDate()DATEY
BATCH_TO_DATEDate()DATEY
BEING_USED_BYVarchar2(30)VARCHAR30
APPROVEDVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
COUNT_ENTEREDNumber(10)NUMBER10

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page