PayTime tm Human Resources DATABASE CONTENTS

Human Resources Employee file

Database Name: HREMPE.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
EMP_ID  12  Employee identification 
JOBCLASS  25  Job classification 
SEX  Sex 
NODEP  Number of Dependents 
DOJU  Date of Joining Union 
EDUCATION  25  Education 
NEXTOFKIN  25  Next of Kin 
NKADD  25  Address of Next of Kin 
NKPROV  20  Province 
NKPC  Postal Code 
NKTEL  12  Telephone 
GROUPINS  25  Group Insurance 
GIEDATE  Group Insurance Effective Date 
PENSION  25  Pension Plan 
PPEDATE  Pension Plan Effective Date 
YOS  Years of Service 
PAY_TYPE  'C' check; 'T' bank transfer, 'P' pay slip 
EFF_DATE  Effective date of transfer 
BANK_ID  Bank ID 
EMP_ACCT  12  Employee's Bank Account Number 

Human Resources Employee Notes file

Database Name: HRNOTES.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
EMP_ID  12  Employee identification 
NOTES  10  Notes memo pad 

Human Resources Employee Report file

Database Name: HRREPORT.dbf

Field Name  Type  Lgth  Dec.  Indx  Description 
FILE 
DESC  65 

Human Resources Employee Field Structure file

Database Name: HRSTRU.dbf

Field Name  Type Lgth  Dec.  Indx  Description 
FILE  File name 
FIELD_NAME  10  Field name 
FIELD_DESC  30  Field description 
FIELD_TYPE  Field type 
FIELD_LEN  Field length 
FIELD_DEC  Decimal places for Numeric 
SEL  Selection flag 


[Home]  [Top]  [Overview]  [Operations]  [Appendix]