More information

Employment

Access Employment information by using Millennium Explorer, Profiles>Biographical>Employment.

A constituent can have an unlimited number of employment rows, each showing complete employment information regarding a current or past job. Additionally, you may choose to retain all former employment rows for all constituents in the system or for selected constituents. A complete employment history can be created with the dates of employment recorded for each entry.

Note: Millennium system administrators or the database administrator can configure audit logging for the Employment data table. For more information, see Audit Log.

Employment Set Up

Employment Status

Active, Retired, and No Longer at this Position are standard entries in the Status lookup table. These entries are used by the system to trigger several automatic features when Employment rows are inserted or updated. If you want to assign a Status other than these to your Employment rows, then active entries must be created in this lookup table before inserting and updating Employment rows.

The Status (job_status) table is a Profiles lookup table. The Lookup Table Maintenance topic provides the details for creating these entries.

Other Lookup Fields

Several other fields, such as Industry and Occupation, are standard lookup table driven fields on the Insert and Update Employment forms. If you wish to use them, active entries must be created in the corresponding lookup tables before inserting and updating Employment rows. See the Employment Field Descriptions, below, for these fields and their corresponding lookup tables.

Customize Employment Display and Maintenance Forms

The Employment display and maintenance forms can be changed to add fields that are not included on the standard forms, to remove standard, but not required fields, to change labels, and to change the placement of the fields on the forms. (Refer to the Custom Display Designer topic for complete instructions on customizing display and maintenance forms.)

Using Internet Explorer as your browser, log on to the system as a Millennium system administrator.
Access the Profiles version of the Custom Display Designer by using Millennium Explorer, Tools>Display Design>Profiles.
Click the Profiles menu. Point to Biographical. Click Employment.
Click Display Type and click on the desired Display Type menu item (for example, Long or Short).
Utilize the Custom Display Designer's editing tools to make your customizations.
Click Save to save and apply your changes.

Create an Employment Row

Locate the constituent's Employment data display by using Millennium Explorer, Profiles > Biographical > Employment.
Point to Employment header Edit Button located on the Edit Button to the left of any existing Employment row.
Click Insert or Insert via Default to display the Insert form for Employment.
Enter the employer's ID number or name in the Firm field, using standard Name search format.

Last Name/First Name<space>Middle Name;Suffix
Select a Status.
Assign a Start Date, if desired.
Supply information for the other fields, as desired.
Check the Primary box if this is the primary employment.

Note: The Primary flag is only used within Millennium's Wealth Engine area.
Click Insert. The system will use the Firm field information to perform a Company ID Search before creating the Employment row. Depending on the results of the Search, a constituent or non-constituent Employment row is created. If a non-constituent Employment row is created, then the information from the Firm field or from the Employer ID Search form will be used as the Non-Constituent Company Name.
- If the search returns one or more constituents who completely or partially match the search criteria, click on the ID number or name of the desired constituent.
- If one of the listed constituents is not the desired Employer, click on the respecify the query hyperlink. The Employer ID Search from displays. You may re-specify your search criteria, click on the Cancel hyperlink to end the search, or click on Enter Non-Constituent Employer. Canceling the Employer ID Search will cancel the creation of the Employment record.
- If the search does not return a constituent who matches the criteria, the Employer ID Search form displays. You may re-specify your search criteria, click on the Cancel hyperlink to end the search or click on Enter Non-Constituent Employer. Canceling the Employer ID Search will cancel the creation of the Employment record.

Notes:

If a constituent Employment row is created:

The employer's name (Firm) is a link. Click it to display the Basic Data display. Here you can see additional information about the employer.
If the Status is set to Active, No Longer at this Position, or Retired, then the system will automatically create the appropriate employer/employee, former employer/former employee, or retired employer/former employer relationship between the constituents.
When an employer/employee relationship is established, the Known Employees and Alumni Employees fields on the employer's Basic Data row are updated. The count of Alumni Employees is based on the Constituent Type of the employee and it must be Alumni in order to be included in the count.
The system will automatically copy the Industry and Matching Gift fields from the Basic Data of the corporation, into the appropriate fields in the constituent's Employment row. In the display of the constituent's Employment row.
If the employer is a Matching Company, the Employment row's Matching Company flag is set to Y. The system can then use this information during Gift processing to prompt the user to create a Matching Gift Pledge or Matching Pledge Potential for the Employer when the employee makes a donation.

Update an Employment Row

Locate the constituent's Employment data display by using Millennium Explorer, Profiles > Biographical > Employment.
Point to the Edit Button located on the Edit Button to the left of the desired Employment row.
Click Update/Delete to display the Update form for Employment.
If you are updating the Employment Status to No Longer at this Position, you may want to give an End Date. Make other changes as desired.
Click Update.

Notes:

If the Status is updated to Retired, then the existing employee/employer relationships will be updated to retired employee/former employer.
If the Status is updated to No Longer at this Position:
- the employer/employee relationships are changed to a former employer/former employee relationship.
- If an Employment row has a linked address, you will be asked if you would like to change the linked address by setting the Address Locator to former and the Address Stop Date to current day's date. If you click on OK it will do so. If you click on Cancel, the information on that Linked Address will not change. You will then be asked if you would like to unlink the linked Address. If you click on OK, it will remove the Linked to Address link from the Employment row and remove the Link to Employment link from the linked Address row. The Address row is not deleted. But, if you want to link the same Address to the new Employment row, then you must do so manually. If you click on Cancel instead, then the links will remain on the archived Employment row and on the Address row.
- the Matching Company flag in the Employment row is set to 'N'.

Delete an Employment Row

Locate the constituent's Employment data display by using Millennium Explorer, Profiles > Biographical > Employment.
Point to the Edit Button located on the Edit Button to the left of the desired Employment row.
Click Update/Delete to display the Update/Delete form for the Employment row.
Click Delete.

Note:

If you delete a constituent Employment row, then the existing employee/employer, former employee/former employer, or retired employee/former employer relationship row will also be deleted.

Update/Archive

If your site makes it a policy to retain the details of previous Employment rows by creating a new row instead of updating an existing one when a constituent's job information changes, then the Update/Archive feature will facilitate the process. When Update/Archive is used, the system automatically edits the existing row and then prompts for the creation of a row for the new information.

The Update/Archive menu item will not be available if the Status on the existing Employment row is already set to No Longer at this Position.

Using Update/Archive

Locate the constituent's Employment Data display by using Millennium Explorer, Profiles > Biographical > Employment.
Point to the Edit Button located to the left of the row you that you want to update.
Click Update/Archive. The Insert form for the new row displays.
Data from the existing Employment row is copied into the Insert form for the new row. The Job Status is set to Active. The Job Status must remain Active, but you may edit the other information as you choose.
Click Insert.

Notes:

The archived Employment row is edited to set the Employment Status to No Longer at this Position.
The Matching Company flag on the archived Employment row is set to N.
The archived row's Stop Date is set in accordance with the following rules:
- If the existing row already has a Stop Date, it will remain unchanged.
- If the new row does not have a Start Date, then the Stop Date will default to the current day's date.
- If the new row has a Start Date, then the Stop Date will be equal to the new row's Start Date.

The relevant employee/employer relationships will be set to former employee/former employer. If an Address is linked to the archived Employment row, it will remain linked. The Locator will be set to Former, the Address Type will be set to the Former version for the given type (for example, Business becomes Former Business), and the Stop Date will be set to the Stop Date of the archived Employment row.

Linked Tables

The following topics discuss the creation and maintenance of linked Employment rows in more detail.

Link Employment and Address

You may link an Employment row and an Address row that belongs to the same constituent. When you do so, a hyperlink will display below the Employment row. Click Linked to an Address to display the address information that is linked to the Employment row. If you are on the constituent's Address, a hyperlink will display below the Address row. The employer's name will be included in the hyperlink text. Click Linked to Employer to display the Employment row to which the Address information is linked. You may create a link between an Employment row and an Address row through the constituent's Employment row OR through the constituent's Address row. The Employment row or the Address row must already exist for the constituent.

Link an Address to Employment Row through Employment

Locate the Employment display for the constituent by using Millennium Explorer, Profiles > Biographical > Employment.
Point to the Edit Button located to the left of the desired Employment row.
To create a new Address row and link this Employment row to it, point to Link. Click Address, or click on Address via Default to use your active Default Insert form for Address. Complete the Address Insert process as desired. Typically, the Address should be assigned a Type equal to Business.

Or

To link this Employment row to an existing Address, point to Link to Existing. Click Address.
1. Point to the Edit Button located to the left of the desired Address.
2. Click Link this Address.

Tip: If you decide that none of the displayed addresses is the one that you want to link to, then you can create a new Address from this display, and then the system will link it. Click Insert New Linked Address or Insert New Linked Address via Default, and then complete the Address Insert process as desired.

Link an Address to Employment row through Address

Locate the constituent's Address data display by using Millennium Explorer, Profiles > Biographical > Address.
Point to the Edit Button located to the left of the desired Address row.
To create a new Employment row and link it to this Address, point to Link. Click Employment, or click on Employment via Default to use your active Default Insert form for Employment. Complete the Employment insert process as desired.

Or

To link this Address row to an existing Employment row, point to Link to Existing. Click Employment.
1. Point to the Edit Button located to the left of the desired Employment row.
2. Click Link this Employment.

Notes:

If the Employment row is already linked to an Address, then the Link > Address, Link > Address via Default, and Link to Existing > Address items are not available.
If you are linking an Employment row from the Address display, and the Address already has a linked Employment row, then Link > Employment, Link > Employment via Default, and Link to Existing > Employment items are not available.
If you change the status of an Employment row from Active to No Longer at this Position and that Employment row has a linked Address, you will be prompted to set the Locator of the linked Address row to Former and the Address Stop Date to the date that you change the status. If you choose not to, then you will be prompted with the opportunity to unlink the Address in order to preserve the Address just as it was, but without the link to the Employment row.
If you update an Address that links to an Employment row using Update/Archive on the Address row, then the Archived Address row and this Employment row are unlinked, and the new Address row is automatically linked to this Employment row.
If you update an Address that links to an Employment row with an Active Job Status by setting the Address's Locator and Type to Former, you will be prompted to set the Employment row's status to No Longer at this Position. The Address row will remain linked to the Employment row regardless of your choice at the prompt.

Linked Attribute to Employment

You may attach, or link, multiple Attribute rows to any Employment row. These Attributes will always display with the Employment row to which they are attached. If the Display Linked Attributes in the Attribute Display User Option is checked, they will also display with the constituent's other Attributes. You may create a link between an Employment row and an Attribute row through the constituent's Employment row OR through the constituent's Attribute row. If you create the link from the Attribute row, then the Employment row must already exist. If you create the link from the Employment row, then you will have the opportunity to either link to an existing Attribute row, or create a new attribute row and then link it.

Link an Attribute to Employment Row through Employment

Locate the Employment display for the constituent by using Millennium Explorer, Profiles > Biographical > Employment.
Point to the Edit Button located to the left of the desired Employment row.
To create a new Attribute row and link this Employment row to it point to Link. Click Attribute, or click on Attribute via Default to use your active Default Insert form for Attribute. Complete the Attribute Insert process as desired.

Or

To link this Employment row to an existing Attribute, point to Link to Existing. Click Attribute.
1. Point to the Edit Button located to the left of the desired Attribute.
2. Click Link this Attribute.

Tip: If you decide that none of the displayed Attributes is the one that you want to link to, then you can create a new Attribute from this display, and then the system will automatically link it. Click Insert new Linked Attribute or Insert new Linked Attribute via Default, and then complete the Attribute Insert process as desired.

Link an Attribute to Employment row through Attribute

Locate the constituent's Attribute data display by using Millennium Explorer, Profiles > Biographical > Attribute.
Point to the Edit Button located to the left of the desired Attribute row.
Point to Link to Existing. Click Employment.
Point to the Edit Button located to the left of the desired Employment row.
Click Link this Employment.

Employment Field Descriptions

Employment information is stored in the jobs table. The following fields are included. Note that the Field Labels and non-displaying designations that are listed are those that the system uses by default. If you want to override these default settings, you must customize your display definition.

Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
jobskey no label	none	numeric/number 13,0	The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System field)
jobsid non-displaying	none	char 10	This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System field)
jobsdoc non-displaying	none	char 1 ['N']	This field holds a Y/N flag to indicate the existence of a linked document for this row. (System field)
jobsdate no label	none	datetime/date [getdate()]	The date that this Employment row was last updated. This field is automatically entered by the system. (System field)
jobsuserid no label	none	varchar/varchar2 30 [suser_sname]	The User ID of the operator that last edited this Employment row. It is automatically entered by the system. (System field)
jobsugroup non-displaying	none	char 1	This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field)
jobsoccup Occupation	Occupations	char 6 [' ']	Indicates the occupation as described by the U.S. Department of Labor or as defined by your institution.
jobsindust Industry	Industries	char 6 [' ']	Indicates the industry in which this constituent is employed as defined by the Department of Commerce in the Standard Industry Codes.
jobsstrtdt Begin	none	datetime/date	Indicates the date on which the constituent began employment with this firm.
jobsstopdt End	none	datetime/date	Indicates the date on which the constituent ceased to be employed by this firm.
jobscpnyid Firm	none	char 10	Indicates the ID Number (if available) and name of the employer.
jobsconame Company Name	none	char 75	Indicates the name of the employer. If the employer is a constituent, this will be constructed from the preferred name data columns. If the constituent has data in the First or Middle Name columns, that data will be stored in this field as 'Last/First Middle;Suffix'. If there is a suffix but no First or Middle, the name will be stored as 'Last, Suffix'.
jobstitle Title	none	char 50	Indicates the constituent's title as it might appear on his or her business card, while employed at the firm listed in this row. This is a free text title that conforms to the constituent's wants, not a standardized description of the occupation and therefore not necessarily the best choice for use for report selection purposes.
jobsstatus Status	Job Status	char 6 [' ']	The work status of the constituent for this position. If this field is set to 'No Longer at this Position', (Code: 'no'), then the Matching Company flag (jobsmflag) is automatically set to 'N'.
jobsdescr1 Descriptor 1	Job Descriptors	char 6 [' ']	A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors lookup table.
jobsdescr2 Descriptor 2	Job Descriptors2	char 6 [' ']	A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors2 lookup table.
jobsdescr3 Descriptor 3	Job Descriptors3	char 6 [' ']	A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors3 lookup table.
jobsaddrky non-displaying	none	numeric/number 13,0 [0]	This field holds a copy of the addrkey field from the linked Address row, if one exists. If this field is used, the hyperlink text, Linked to an Address displays with the row. (System field)
jobsrelky1 non-displaying	none	numeric/number 13,0 [0]	During data entry, when a constituent Company ID number or name is entered in the field labeled Firm (jobsconame or jobscpnyid), the system automatically creates two Relationship rows. The first belongs to the employee (who owns this Employment row) and the second belongs to the constituent who is the employer, showing the two-way relationship. The jobsrelky1 holds a copy of the relkey field from the employer's Relationship row. (System field)
jobsrelky2 non-displaying	none	numeric/number 13,0 [0]	During data entry, when a constituent Company ID number or name is entered in the field labeled Firm (jobsconame or jobscpnyid), the system automatically creates two Relationship rows. The first belongs to the employee (who owns this Employment row) and the second belongs to the constituent who is the employer, showing the two-way relationship. The jobsrelky2 field holds a copy of the relkey field from the employee's Relationship row (System field)
jobsmflag Matching Company?	none	char 1 ['N']	Indicates whether this firm does or does not have a policy of making gifts to match their employee's contributions. This flag allows the system to automatically prompt during gift processing for the creation of Matching Gift Pledge or Match Potential. This field is automatically set equal to Y if the company that is entered in this row is a constituent on the system and that constituent's coremrat1 field in their Basic Data row contains ratio data. If you need to override this automatic behavior, re-access an existing Employment row and manually edit this jobsmflag field using standard data maintenance procedures. (Note that if the company's coremrat1 field is updated, this field in the Employment row will also be updated and set to Y.) If the Job Status (jobsstatus) is set to 'No Longer at this Position', Code: 'no', then this flag is automatically set to 'N'.
jobssalcls Salary Class	Salary Class	char 6 [' ']	Institution-defined classifications, usually a set of salary ranges.
jobssource Source	Source	char 6 [' ']	The source of the information in this Employment row.
jobscodiv Division	none	char 60	The name of the division within the company with which the constituent is associated.
jobspoint non-displaying	none	numeric/number 10,0	This system-assigned field is no longer used or supported. (System field)
jobsfnum non-displaying	none	char 2 ['06'] {'06'}	The file (table) number for the Employment table. (System field)
jobscrdate non-displaying	none	datetime/date [getdate()]	The date that the Employment row was created. (System field)
jobscomm no label	none	varchar/varchar2 4000	A free text Comment that may be entered and displayed with this row only.
jobslattr non-displaying	none	char 1 ['N']	A flag indicating that Attribute row(s) are linked to this Employment row. (System field)
jobsdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsmny1	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny2	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsnum1	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum2	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsyesno	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobslook1	Jobs Lookup1	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
jobslook2	Jobs Lookup2	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
jobslook3	Jobs Lookup3	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
jobstext	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobspend Pending	none	char 1 ['N'] {not null}	This field is a flag to indicate that this data row has linked information in the 'pending' Employment table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is pending incorporation into this data row. (system field)
jobspubfl Publish	none	char 1 ['N'] {not null}	This field is a flag to indicate whether this data row will or will not be available for online publishing. This flag will be applicable when the Options for Publishing Data for the Employment table are set to 'Published by Consent'. Otherwise, the corepub06 column flag in the Basic Data table will be used.
jobsupkey non-displaying	none	numeric/number 13,0	This field holds the Timekey of the pending data row that may be updated from the jobs_pending table.
jobsdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
jobsmny3	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny4	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny5	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny6	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny7	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny8	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny9	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny10	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny11	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsmny12	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
jobsnum3	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum4	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum5	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum6	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum7	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum8	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum9	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum10	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum11	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobsnum12	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
jobschk1	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk2	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk3	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk4	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk5	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk6	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk7	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk8	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk9	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobschk10	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
jobstxt1	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobstxt2	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobstxt3	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobstxt4	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobstxt5	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
jobsadesrc non-displaying	ade_source	char 30	If this row is created or updated from data that originally came from the jobs_pending table, then this field will hold information about the data's import source. Data from the Online Constituent Directory will have a source of Online Directory. Data from Soft Edit users will have a source of Soft Edit. Data whose import source is the ADE Import Tool can be assigned a value (other than Online Directory or Soft Edit) from the ade_source lookup table by the user who executes the utility, or the source can be blank.

Field Name

Field Label

Lookup Table

Type SQL/Oracle

Length

[Default]

{Check}

Description

jobskey

no label

none

numeric/number

13,0

The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System field)

jobsid

non-displaying

none

char

This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System field)

jobsdoc

non-displaying

none

char

['N']

This field holds a Y/N flag to indicate the existence of a linked document for this row. (System field)

jobsdate

no label

none

datetime/date

[getdate()]

The date that this Employment row was last updated. This field is automatically entered by the system. (System field)

jobsuserid

no label

none

varchar/varchar2

[suser_sname]

The User ID of the operator that last edited this Employment row. It is automatically entered by the system. (System field)

jobsugroup

non-displaying

none

char

This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System field)

jobsoccup

Occupation

Occupations

char

[' ']

Indicates the occupation as described by the U.S. Department of Labor or as defined by your institution.

jobsindust

Industry

Industries

char

[' ']

Indicates the industry in which this constituent is employed as defined by the Department of Commerce in the Standard Industry Codes.

jobsstrtdt

Begin

none

datetime/date

Indicates the date on which the constituent began employment with this firm.

jobsstopdt

End

none

datetime/date

Indicates the date on which the constituent ceased to be employed by this firm.

jobscpnyid

Firm

none

char

Indicates the ID Number (if available) and name of the employer.

jobsconame

Company Name

none

char

Indicates the name of the employer. If the employer is a constituent, this will be constructed from the preferred name data columns. If the constituent has data in the First or Middle Name columns, that data will be stored in this field as 'Last/First Middle;Suffix'. If there is a suffix but no First or Middle, the name will be stored as 'Last, Suffix'.

jobstitle

Title

none

char

Indicates the constituent's title as it might appear on his or her business card, while employed at the firm listed in this row. This is a free text title that conforms to the constituent's wants, not a standardized description of the occupation and therefore not necessarily the best choice for use for report selection purposes.

jobsstatus

Status

Job Status

char

[' ']

The work status of the constituent for this position.

If this field is set to 'No Longer at this Position', (Code: 'no'), then the Matching Company flag (jobsmflag) is automatically set to 'N'.

jobsdescr1

Descriptor 1

Job Descriptors

char

[' ']

A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors lookup table.

jobsdescr2

Descriptor 2

Job Descriptors2

char

[' ']

A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors2 lookup table.

jobsdescr3

Descriptor 3

Job Descriptors3

char

[' ']

A description or categorization of the constituent's job, as defined by your institution in the Job Descriptors3 lookup table.

jobsaddrky

non-displaying

none

numeric/number

13,0

[0]

This field holds a copy of the addrkey field from the linked Address row, if one exists. If this field is used, the hyperlink text, Linked to an Address displays with the row. (System field)

jobsrelky1

non-displaying

none

numeric/number

13,0

[0]

During data entry, when a constituent Company ID number or name is entered in the field labeled Firm (jobsconame or jobscpnyid), the system automatically creates two Relationship rows. The first belongs to the employee (who owns this Employment row) and the second belongs to the constituent who is the employer, showing the two-way relationship. The jobsrelky1 holds a copy of the relkey field from the employer's Relationship row. (System field)

jobsrelky2

non-displaying

none

numeric/number

13,0

[0]

During data entry, when a constituent Company ID number or name is entered in the field labeled Firm (jobsconame or jobscpnyid), the system automatically creates two Relationship rows. The first belongs to the employee (who owns this Employment row) and the second belongs to the constituent who is the employer, showing the two-way relationship. The jobsrelky2 field holds a copy of the relkey field from the employee's Relationship row (System field)

jobsmflag

Matching Company?

none

char

['N']

Indicates whether this firm does or does not have a policy of making gifts to match their employee's contributions. This flag allows the system to automatically prompt during gift processing for the creation of Matching Gift Pledge or Match Potential.
This field is automatically set equal to Y if the company that is entered in this row is a constituent on the system and that constituent's coremrat1 field in their Basic Data row contains ratio data.
If you need to override this automatic behavior, re-access an existing Employment row and manually edit this jobsmflag field using standard data maintenance procedures. (Note that if the company's coremrat1 field is updated, this field in the Employment row will also be updated and set to Y.)

If the Job Status (jobsstatus) is set to 'No Longer at this Position', Code: 'no', then this flag is automatically set to 'N'.

jobssalcls

Salary Class

char

[' ']

Institution-defined classifications, usually a set of salary ranges.

jobssource

Source

char

[' ']

The source of the information in this Employment row.

jobscodiv

Division

none

char

The name of the division within the company with which the constituent is associated.

jobspoint

non-displaying

none

numeric/number

10,0

This system-assigned field is no longer used or supported. (System field)

jobsfnum

non-displaying

none

char

['06']

{'06'}

The file (table) number for the Employment table. (System field)

jobscrdate

non-displaying

none

datetime/date

[getdate()]

The date that the Employment row was created. (System field)

jobscomm

no label

none

varchar/varchar2

4000

A free text Comment that may be entered and displayed with this row only.

jobslattr

non-displaying

none

char

['N']

A flag indicating that Attribute row(s) are linked to this Employment row. (System field)

jobsdate1

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate2

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsmny1

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny2

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsnum1

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum2

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsyesno

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobslook1

Jobs Lookup1

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

jobslook2

Jobs Lookup2

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

jobslook3

Jobs Lookup3

char

This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

jobstext

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobspend

Pending

none

char

['N']

{not null}

This field is a flag to indicate that this data row has linked information in the 'pending' Employment table as a result of data entry by the constituent via the Online Constituent Directory. That linked info is pending incorporation into this data row. (system field)

jobspubfl

Publish

none

char

['N']

{not null}

This field is a flag to indicate whether this data row will or will not be available for online publishing. This flag will be applicable when the Options for Publishing Data for the Employment table are set to 'Published by Consent'. Otherwise, the corepub06 column flag in the Basic Data table will be used.

jobsupkey

non-displaying

none

numeric/number

13,0

This field holds the Timekey of the pending data row that may be updated from the jobs_pending table.

jobsdate3

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate4

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate5

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate6

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate7

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate8

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdate9

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdte10

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdte11

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsdte12

none

datetime/date

This custom field may be defined and used by your institution to track any date information associated with this data row.

jobsmny3

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny4

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny5

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny6

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny7

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny8

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny9

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny10

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny11

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsmny12

none

money/number

(19,4)/(16,2)

This custom field may be defined and used by your institution to track any monetary information associated with this data row.

jobsnum3

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum4

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum5

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum6

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum7

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum8

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum9

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum10

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum11

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobsnum12

none

numeric/number

10, 0

This custom field may be defined and used by your institution to track any numeric information associated with this data row.

jobschk1

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk2

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk3

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk4

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk5

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk6

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk7

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk8

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk9

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobschk10

none

char

['N']

{'N' or 'Y'}

This custom field may be defined and used by your institution to flag this data row for any purpose.

jobstxt1

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobstxt2

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobstxt3

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobstxt4

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobstxt5

none

varchar/varchar2

255

This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.

jobsadesrc

non-displaying

ade_source

char

If this row is created or updated from data that originally came from the jobs_pending table, then this field will hold information about the data's import source. Data from the Online Constituent Directory will have a source of Online Directory. Data from Soft Edit users will have a source of Soft Edit. Data whose import source is the ADE Import Tool can be assigned a value (other than Online Directory or Soft Edit) from the ade_source lookup table by the user who executes the utility, or the source can be blank.

Indices - Employment

Index	Primary	Foreign	Unique	Fields	Sort
pk_jobs	Y		Y	jobskey	ASC
jobs02		Y		jobsid	ASC
jobs03		Y		jobscpnyid	ASC
jobs04		Y		jobsrelky1	ASC
jobs05				jobsdate	ASC
jobs06		Y		jobsoccup	ASC
jobs07		Y		jobsindust	ASC
jobs08				jobsconame	ASC

Top of Page