Module List > Module HR tables PC70100
You are currently viewing the COMPANY database.
Change

COMPANY..PC70100 Table Definition

(COMPANY..PC Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RPTGRIND smallint
0

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

RPRTNAME char(31)
''

PRNTNOTS tinyint
0

PRNTTYPE smallint
0

ASKECHTM tinyint
0

INCLGNDS tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

SORTBY smallint
0

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now
POSSTATUS smallint
0

HRSTATUS smallint
0
*HR Status...(more) Join Now
EMPLTYPE char(7)
''

EEOCLASS_I smallint
0

FLSASTATUS smallint
0

SHOWINACTIVE tinyint
0

STRTCHANGEDT datetime
'1/1/1900'

STTUSRID char(15)
''

STRTDEPT char(7)
''

STRDIVISIONCODE char(7)
''

STTEMPCL char(15)
''

STTEMPID char(15)
''

STTLOCID char(15)
''

STARTPLAN char(15)
''

STTJBTIT char(7)
''

STRTRPTPOS char(7)
''

STRTSPRVSRCD char(7)
''

ENDCHANGEDT datetime
'1/1/1900'

ENDUSRID char(15)
''

ENDDEPT char(7)
''

ENDDIVISIONCODE char(7)
''

ENEMPCLS char(15)
''

ENDEMPL char(15)
''

ENDLOCID char(15)
''

ENDPLAN char(15)
''

ENJBTITL char(7)
''

ENDRPTPOS char(7)
''

ENDSPRVSRCD char(7)
''

RANGEBY smallint
0

ASSIGNMENTSTATUS smallint
0

INHERITSTATUS smallint
0

SEATTYPE smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3