WKHHSYNSTAT

Statistics for PDA Sync Module

Field Name

Caption

Mask

Description

Field Type

HS_CRT_BY

Created By

25x

Created By

Text

HS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

HS_FILE

V&T Database

40x

Database for Validate and Transfer

Text

HS_HH_ID

PDA Sync Rec #

nnnnnnnn

Stores the WKHHSYNCH.HH_ID

Long Integer

HS_ID

Synch Status Rec #

nnnnnnnn

Auto ID

Long Integer

HS_MOD_BY

Last Modified By

25x

Modified By

Text

HS_MOD_DT

Last Modified Date

mm/dd/yyyy

Modified Date

Date/Time

HS_MOD_TM

Last Modified Time

hh:mm am

Modified By

Date/Time

HS_PROC_DT

Last Processing Date

mm/dd/yyyy

Last Processing Date

Date/Time

HS_PROC_TM

Last Processing Time

hh:mm am

Last Processing Time

Date/Time

HS_PSTATUS

V & T Status

25x

Validate and Transfer Status

Text

HS_REM_DT

File Removal Date

mm/dd/yyyy

Date for file removal

Date/Time

HS_REMOVED

 

 

Database has been removed

Boolean

HS_STATUS

Synchronization Status

25x

Synchronization Status

Text

HS_SYN_DT

Date Sync Started

mm/dd/yyyy

Date Synchronization Started

Date/Time

HS_SYN_TM

Time Sync Started

hh:mm am

Time Synchronization Started

Date/Time