Data Definitions
|
Field Name N |
External Name (Screen) |
Definition |
|
ASSIGN_RESOURCE |
||
|
Assign_resource_inits |
Initials (User) Resource (Resource Assignment) |
The unique key from the USER table that identifies a Resource. |
|
Assign_workreq_id |
WR# (Work Request) |
The first part of the unique key from the WORKREQ_ACTIVITY table that identifies a Work Request or Activity. |
|
Assign_workreq_act_id |
(None) |
The second part of the unique key from the WORKREQ_ACTIVITY table that identifies a Work Request or Activity. |
|
Assign_status |
Assignment Status (Resource Assignment) |
Status of the resource assignment. Assigned is the default when the assignment is created. Cancelled is for when the assignment is cancelled. When workreq_activity_status is set to Cancelled, assign_status is automatically set to Cancelled. |
|
Assign_hours_est |
Estimated Hours (Resource Assignment) |
Estimated hours to complete the activity |
|
Assign_comment |
Comments (Resource Assignment) |
Any comments related to the assignment. |
|
Assign_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Assign_last_upd_inits |
(None) |
The initials from the LOGIN_ADMIN table at the time this row was updated. |
|
LOGIN_ADMIN |
||
|
Login_id |
User (Log-on) |
The ID of the person who is accessing the system. |
|
Login_user_inits |
Initials (User) |
The initials of the person who is accessing the system. |
|
Login_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Login_last_upd_inits |
(None) |
The initials from the LOGIN_ADMIN table at the time this row was updated. |
|
USER |
||
|
User_inits |
Initials (User) |
Unique key for the user |
|
User_name |
Full Name (User) |
The name (Last, First) of the user. |
|
User_access_privilege_cd |
Access Privileges (User) |
The access level of the person who is accessing the system. Levels: 1=Client, 3=ACS. All levels below the one a person is logged on as are accessible. |
|
User_active_ind |
Active (User) |
Indicates whether the user is currently an active employee at NU |
|
User_auth_system_codes |
Systems (User) |
The code(s) of the system(s) on which the user is authorized to report (Max of 10). |
|
User_phone |
Telephone (User) |
Phone number ( (nnn)nnn-nnnn ) where the user can be reached during the day. |
|
User_email |
(User) |
E-mail address where the user wants work related e-mail directed. |
|
User_comment |
Comments (User) |
Comments about the user. |
|
User_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
User_last_upd_inits |
(None) |
The initials from the LOGIN_ADMIN table at the time this row was updated. |
|
WORKREQ_ACTIVITY |
||
|
Workreq_id |
WR# (Work Request) |
Value internal to the system that makes a Work Request unique. |
|
Workreq_act_id |
(None) |
Value internal to the system that makes the Activity unique within the Work Request. Zeroes identify the row as a Work Request. All other numbers (system generated or sequentially assigned) indicate that the row is an Activity. |
|
Workreq_act_name |
Work Request Name (Work Request) Activity Name (Activity) |
Work Request Name: This is a name entered by the ACS Responsible Manager at, or before, the time the Work Request is marked "Approved". Activity Name: Entered by the ACS person creating the activity row. |
|
Workreq_act_type |
Activity Type (Activity) |
The type of Activity being performed. |
|
Workreq_act_status |
Status (Work Request) Activity Status (Activity) |
The status of the Work Request or Activity. . When workreq_activity_status is set to Cancelled, assign_status is automatically set to Cancelled. |
|
Workreq_leader_inits |
Leader (Work Request) |
Initials of the ACS user responsible for the Work Request. Selected from a pick list. |
|
Workreq_request_dt |
Date Requested (Work Request) |
Date from the paper or on-line form labeled Date Requested. |
|
Workreq_due_dt |
Due Date (Work Request) |
Date from the paper or on-line form labeled Due Date. |
|
Workreq_system_cd |
System (Work Request) |
The code for the system for which the Work Request was submitted. The instruction sheet has the initial list. More may be added to the SYSTEM_LOOKUP table |
|
Workreq_requestor_name |
Requestor's Name (Work Request) |
Data from the paper or on-line form labeled Requestor’s Name. This should be the name of the person who originated the request. |
|
Workreq_requestor_phone |
Telephone # (Work Request) |
Data from the paper or on-line form labeled Telephone # that appears after Requestor’s Name. Should be the phone number where the Requestor can be reached for questions related to the Work Request. Desired format is (nnn)nnn-nnnn. |
|
Workreq_requestor_email |
(Work Request) |
Data from the paper or on-line form labeled e-mail that appears after Requestor’s Name. Should be the e-mail address where the Requestor can be contacted for questions related to the Work Request. |
|
Workreq_auth_mgr_inits |
Authorized Manager's Name (Work Request) |
The initials of the Authorized Manager. An Authorized Manager is someone in the USER table as a Client for the System specified in the Work Request. |
|
Workreq_reason |
Reason for request (Work Request) |
Data from the paper or on-line form labeled Reason for request. There is a specific set of valid values and an Other category that allows explanation. |
|
Workreq_pgm_name |
Program Name (Work Request) |
Data from the paper or on-line form labeled Program Name. If the requestor or Authorizing Manager has the information, this should be the specific programs, jobs, etc. affected by the request. |
|
Workreq_description |
Request (Work Request) |
General description of the work request. This could be the primary source of information from which the ACS Manager will develop the Work Request Name. |
|
Workreq_func_specs |
Functional Specifications (Work Request) |
Describes any and all rules, validations, calculations, and computations required for completion of the request. Contains references to any supporting documentation. |
|
Workreq_improvement |
Improvement/benefits (Work Request) |
Specifics of any improvements or benefits to be gained by completing the request. |
|
Workreq_due_dt_reason |
What drives the due date (Work Request) |
Identification of any deadline, regulatory request, or other circumstance that dictates that the project be carried out by a specific date. |
|
Workreq_act_comment |
Additional Comments (Work Request) Comments (Activity) |
Comments about the Work Request that do not logically fit into any other text entry field. |
|
Workreq_submitted_dt |
Date Submitted (Receive Work Requests) |
The date the request was submitted via the web to ACS. |
|
Workreq_received_ts |
Date Received (Receive Work Requests) |
The date the request was received by ACS. This is filled in by the program when the ACS Manager clicks on the button that marks the request as received. When an ACS person keys the request, it is by definition "received". |
|
Workreq_received_inits |
Initials (User) |
Initials of the person who marked the request as received. Filled in by the program when the ACS Manager clicks on the button that marks the request as received. |
|
Workreq_approved_dt |
Approval Date (Work Request) |
The date the request was approved by ACS as a complete request. This is filled in by the program when the ACS Manager clicks on the button that marks the request as approved. |
|
Workreq_assigned_to_inits |
Assigned to (Work Request) |
Initials of the lead person assigned to the Work Request. Selected from the USER table. |
|
Workreq_hours_est |
Time Estimate (Work Request) |
This is a shadow field (not stored on the database). The value displayed on the screen is the sum of the detail estimates from ASSIGN_RESOURCE. |
|
Workreq_start_dt |
Start Date (Work Request) |
Date that work actually started on the Work Request. |
|
Workreq_target_complete_dt |
Target Completion Date (Work Request) |
Date that the ACS Manager keys as the desired completion date of the Work Request. |
|
Workreq_signoff_name |
Requestor Sign Off (Work Request) |
Name of the person who actually signed the original Work Request indicating that the Work Request was complete. |
|
Workreq_signoff_dt |
Date (Work Request) |
Date that the person who actually signed the Work Request signed the original Work Request form signed the work request indicating that the work request was complete. At this point, the work request is complete. |
|
Workreq_tested_by_name |
Tested By (Work Request) |
Name of the person in the client organization who was the lead for testing to ensure that Work Request was completed correctly. |
|
Workreq_tested_dt |
Tested Date (Work Request) |
Date that the person in the client organization who was the lead for testing completed the testing. |
|
Workreq_act_anticip_start_dt |
Anticipated Start Date (Activity) |
Date on which work on the activity is expected to start. |
|
Workreq_act_actual_start_dt |
Actual Start Date (Activity) |
Date on which work on the activity actually starts. |
|
Workreq_act_anticip_complete_dt |
Anticipated Completion Date (Activity) |
Date on which work on the activity is expected to be complete. |
|
Workreq_act_actual_complete_dt |
Actual Completion Date (Activity) |
Date on which work on the activity is actually complete. |
|
Workreq_act_last_update_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Workreq_act_last_upd_inits |
(None) |
The initials from the LOGIN_ADMIN table at the time this row was updated. |
|
TIMESHEET |
||
|
Timesheet_resource_inits |
Time Sheet for (Time Sheet) |
The unique key from the USER table that identifies a Resource. |
|
Timesheet_workreq_id |
None |
The first part of the unique key from the WORKREQ_ACTIVITY table that identifies a Work Request or Activity. |
|
Timesheet_workreq_act_id |
None |
The second part of the unique key from the WORKREQ_ACTIVITY table that identifies a Work Request or Activity. |
|
Timesheet_date |
None |
Date for which hours are being entered |
|
Timesheet_hours |
None |
Hours spent working on the work request or activity for the specified date |
|
Timesheet_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Timesheet_last_upd_inits |
(None) |
The initials from the LOGIN_ADMIN table at the time this row was updated. |
|
SYSTEM_LOOKUP |
||
|
System_cd |
None |
The unique key that identifies a system for which a Work Request can be submitted. |
|
System_name |
System (Work Request) |
The full name of the system |
|
System_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
System_last_upd_inits |
(None) |
The initials of the system administrator who last updated this row |
|
WORKREQ_ACTIVITY_TYPE_LOOKUP |
||
|
Workreq_act_type |
Activity type WORKREQ_ACTIVITY) |
The unique key that identifies a type of Activity to be performed. |
|
Workreq_act_type_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Workreq_act_type_last_upd_inits |
(None) |
The initials of the system administrator who last updated this row |
|
WORKREQ_ACTIVITY_STATUS_LOOKUP |
||
|
Workreq_act_status |
Status (Work Request) Activity Status (Activity) |
The unique key that identifies a status of a Work Request or Activity. |
|
Workreq_act_valid_for_cd |
None |
Indicates whether this status is valid for a work request or for an activity |
|
Workreq_act_status_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Workreq_act_status_last_upd_inits |
(None) |
The initials of the system administrator who last updated this row |
|
WORKREQ_REASON_LOOKUP |
||
|
Workreq_reason |
Reason for request (Work Request) |
The unique key that identifies a Work Request reason. |
|
Workreq_reason_last_upd_ts |
(None) |
The system timestamp for the last time this row was updated. |
|
Workreq_reason_last_upd_inits |
(None) |
The initials of the system administrator who last updated this row |