P 2 K_TS_TIME_BATCHES
Back to current versionRestore this version

P2K_TS_TIME_BATCHES

Alias: TBT#

Unique Keys: _
Child Table:
_
Parent Table: _

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