Table: Employee Setup Detail - Demographics

Table: AHEPED
View: AH0004
Record length: 236
Flags: A R 

Keys: 5

Title  Flags  Fields
Primary Key - Profile ID, Accpac  PROFID, ACCPACFLD
Accpac Field  D  ACCPACFLD
Accpac Field, Sage Accpac HRMS F  D M  ACCPACFLD, ABRAFLD
Sage Accpac HRMS Field  D M  ABRAFLD
Process Sort  M  PROCSEQ, PROFID, ACCPACFLD

Fields: 14

Field  Type  Title  Presentation 
PROFID  String*22  Profile ID   
ACCPACFLD  String*20  Accpac Field   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ACFLDESC  String*60  Accpac Field Description   
ABRAFLD  String*40  Sage Accpac HRMS Field   
ABFLDESC  String*60  Sage HRMS Field Description   
SWSHOW  Boolean  Show In Grid?   
ABFLDTYP  Integer  Have Detail Table?  List: 2 entries
0=No
1=Yes
STATUSFLT  Integer  Canadian Additional Status  List: 7 entries
0=None
1=Printed for Inactive or Terminated Status
2=Unprinted for Inactive or Terminated Status
3=First Get Country1, if blank Get Country2
4=Use View UPEMPC|CPEMPC
5=if hrpersnl.p_overtime is 'N', Blank
10=Not Used
PROCESSCMD  Integer  Process Command  List: 3 entries
0=Do Nothing
1=Insert Record to AHEPEDCM
2=Insert Record to AHEPEDRM
PROCSEQ  Integer  Process Sort   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.