# 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.