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