Table 42833 "SL Hist. PJEmploy"

DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation
1	BaseCuryId	Text[4]	—
2	CpnyId	Text[10]	—
3	crtd_datetime	DateTime	—
4	crtd_prog	Text[8]	—
5	crtd_user	Text[10]	—
6	CuryId	Text[4]	—
7	CuryRateType	Text[6]	—
8	date_hired	Date	—
9	date_terminated	Date	—
10	employee	Text[10]	—
11	emp_name	Text[60]	—
12	emp_status	Text[1]	—
13	emp_type_cd	Text[4]	—
14	em_id01	Text[30]	—
15	em_id02	Text[30]	—
16	em_id03	Text[50]	—
17	em_id04	Text[16]	—
18	em_id05	Text[4]	—
19	em_id06	Decimal	—
20	em_id07	Decimal	—
21	em_id08	Date	—
22	em_id09	Date	—
23	em_id10	Integer	—
24	em_id11	Text[30]	—
25	em_id12	Text[30]	—
26	em_id13	Text[20]	—
27	em_id14	Text[20]	—
28	em_id15	Text[10]	—
29	em_id16	Text[10]	—
30	em_id17	Text[4]	—
31	em_id18	Decimal	—
32	em_id19	Date	—
33	em_id20	Integer	—
34	em_id21	Text[10]	—
35	em_id22	Text[10]	—
36	em_id23	Text[10]	—
37	em_id24	Text[10]	—
38	em_id25	Text[10]	—
39	exp_approval_max	Decimal	—
40	gl_subacct	Text[24]	—
41	lupd_datetime	DateTime	—
42	lupd_prog	Text[8]	—
43	lupd_user	Text[10]	—
44	manager1	Text[10]	—
45	manager2	Text[10]	—
46	MSPData	Text[50]	—
47	MSPInterface	Text[1]	—
48	MSPRes_UID	Integer	—
49	MSPType	Text[1]	—
50	noteid	Integer	—
51	placeholder	Text[1]	—
52	projExec	Integer	—
53	S4Future01	Text[30]	—
54	S4Future02	Text[30]	—
55	S4Future03	Decimal	—
56	S4Future04	Decimal	—
57	S4Future05	Decimal	—
58	S4Future06	Decimal	—
59	S4Future07	Date	—
60	S4Future08	Date	—
61	S4Future09	Integer	—
62	S4Future10	Integer	—
63	S4Future11	Text[10]	—
64	S4Future12	Text[10]	—
65	stdday	Integer	—
66	Stdweek	Integer	—
67	Subcontractor	Text[1]	—
68	user1	Text[30]	—
69	user2	Text[30]	—
70	user3	Decimal	—
71	user4	Decimal	—
72	user_id	Text[50]	—
73	VacaTot	Decimal	—
74	VacaBal	Decimal	—
75	VacaProjectID	Text[16]	—
76	VacaTaskID	Text[32]	—
77	VacaLUpd	Date	—

Keys

PK: employee (clustered)

Recent changes

2026-07-09 #9220 Backport SL Migration - Snapshot Project Transactions (main, BC30, feature, added)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "SL Hist. PJEmploy"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.