# View: Employee History Optional Field Values

RotoID: CP0013
Table: CPHSHO
Protocol: Detail, Ordered revisions
DLL: CPHSHO

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
CP0012 | CPHSTH | Employee History Control | CPHSTH

## Keys: 1

Title | Fields
--- | ---
History Optional Field Value | EMPLOYEE, HISTDATE, OPTFIELD

## Fields: 20

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R |
HISTDATE | 2 | Date | Date | E A K R |
OPTFIELD | 3 | String*12 | Optional Field | E A K R |
VALUE | 4 | String*60 | Value | E A |
TYPE | 5 | Integer | Type | E A |
LENGTH | 6 | Integer | Length | E A |
DECIMALS | 7 | Integer | Decimals | E A |
ALLOWNULL | 8 | Boolean | Allow Blank | E A |
VALIDATE | 9 | Boolean | Validate | E A |
SWSET | 10 | Integer | Value Set | E A |
VALINDEX | 20 | Long | Typed Value Field Index | E A |
VALIFTEXT | 21 | String*60 | Text Value | E A |
VALIFMONEY | 22 | BCD*10.3 | Amount Value | E A |
VALIFNUM | 23 | BCD*10.0 | Number Value | E A T |
VALIFLONG | 24 | Long | Integer Value | E A |
VALIFBOOL | 25 | Boolean | Yes/No Value | E A |
VALIFDATE | 26 | Date | Date Value | E A |
VALIFTIME | 27 | Time | Time Value | E A |
FDESC | 28 | String*60 | Optional Field Description | E A |
VDESC | 29 | String*60 | Value Description | E A |

This page was generated on 2009-Nov-19

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