View: Employee Setup Detail - Demographics

RotoID: AH0004
Table: AHEPED
Protocol: Detail, Ordered revisions
DLL: AHEPED

Compositions: 3

RotoID  Tables  Title  DLL 
AH0003  AHEPEH  Employee Setup Header  AHEPEH
AH0114  AHEPEDCM  Employee Setup Demographics - Mapping  AHEPEDCM
AH0115  AHEPEDRM  Employee Setup Demographics - Reverse Mapping  AHEPEDRM

Keys: 5

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

Fields: 10

Field  Index  Type  Title  Attributes  Presentation
PROFID  1  String*22  Profile ID  E A K R   
ACCPACFLD  2  String*20  Accpac Field  E A K R   
ACFLDESC  3  String*60  Accpac Field Description  E A   
ABRAFLD  4  String*40  Sage Accpac HRMS Field  E A   
ABFLDESC  5  String*60  Sage HRMS Field Description  E A   
SWSHOW  6  Boolean  Show In Grid?  E A   
ABFLDTYP  7  Integer  Have Detail Table?  E A  List: 2 entries
0=No
1=Yes
STATUSFLT  8  Integer  Canadian Additional Status  E A  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  9  Integer  Process Command  E A  List: 3 entries
0=Do Nothing
1=Insert Record to AHEPEDCM
2=Insert Record to AHEPEDRM
PROCSEQ  10  Integer  Process Sort  E A   

This page was generated on 2009-Nov-19

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