STANDARD DATA DICTIONARY #117.1 -- STAFFING DATA FILE 9/29/25 PAGE 1
STORED IN ^FH(117.1, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 5.5)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file contains the statistical data necessary to prepare the Staffing Data report. Data is saved for each date.
DD ACCESS: #
RD ACCESS: #F
WR ACCESS: #F
DEL ACCESS: #F
LAYGO ACCESS: #F
CROSS
REFERENCED BY: DATE(B)
117.1,.01 DATE 0;1 DATE (Required)
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X I $D(X) S DINUM=X
DESCRIPTION:
This is the date for which staffing data is entered.
NOTES: XXXX--CAN'T BE ALTERED EXCEPT BY PROGRAMMER
CROSS-REFERENCE: 117.1^B
1)= S ^FH(117.1,"B",$E(X,1,30),DA)=""
2)= K ^FH(117.1,"B",$E(X,1,30),DA)
This is the normal B cross-reference of the DATE field.
117.1,1 DAILY FTEE 0;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: NOV 20, 1989
HELP-PROMPT: Type a Number between 0 and 999, 3 Decimal Digits
DESCRIPTION: This field contains the count of all personnel assigned to the Dietetic Service and includes
full-time and part-time employees.
117.1,2 CLINICAL FTEE 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 06, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
DESCRIPTION: This field contains the FTEE of the clinical dietitians and clinical technicians who work with the
clinical dietitians in patient care activities.
117.1,3 ADMINISTRATIVE FTEE 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: NOV 20, 1989
HELP-PROMPT: Type a Number between 0 and 999, 3 Decimal Digits
DESCRIPTION: This field contains the FTEE of the Chief and Assistant Chief of the Dietetic Service, Chief of the
Administrative section, Chief Clinical Section, administrative dietitians, internship, education
and staff development dietitians, and any QA dietitians.
117.1,4 SUPPORT STAFF FTEE 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: NOV 20, 1989
HELP-PROMPT: Type a Number between 0 and 999, 3 Decimal Digits
DESCRIPTION: This field contains the FTEE of all secretaries, clerk-typists, cost accountants, and
administrative technicians; it does not include diet communications personnel.
117.1,5 CFWS FTEE 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4N.N) X
LAST EDITED: NOV 20, 1989
HELP-PROMPT: Type a Number between 0 and 999, 3 Decimal Digits
DESCRIPTION:
This field contains the FTEE of Supervisory Cooks and Supervisory Food Service workers.
117.1,6 DAYS OFF HOURS 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."3N.N) X
LAST EDITED: NOV 21, 1989
HELP-PROMPT: Type a Number between 0 and 9999, 2 Decimal Digits
DESCRIPTION:
This field contains the count of hours not worked by measured personnel.
117.1,7 LWOP & AWOL HOURS 0;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of LWOP and AWOL hours for measured personnel.
117.1,8 OVERTIME HOURS 0;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of overtime hours worked by measured personnel.
117.1,9 UNSCHEDULED HOURS 0;10 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of unscheduled hours worked by measured personnel.
117.1,10 INTERMITTENT HOURS 0;11 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of intermittent hours worked by measured personnel.
117.1,11 COP HOURS 0;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of Continuation-of-Pay hours by measured personnel.
117.1,12 ANNUAL LEAVE HOURS 0;13 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours of annual leave taken by measured personnel.
117.1,13 SICK LEAVE HOURS 0;14 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours of sick leave taken by measured personnel.
117.1,14 OTHER LEAVE HOURS 0;15 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours of other types of leave taken by measured personnel.
117.1,15 LOANED/UNION HOURS 0;16 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION: This field contains the number of hours worked in other services, or on union affairs, by measured
personnel.
117.1,16 COMP. HOURS 0;17 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of compensatory hours worked by measured personnel.
117.1,17 TRAINEE HOURS 0;18 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours worked by trainees.
117.1,18 VOLUNTEER HOURS 0;19 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours worked by uncompensated volunteers.
117.1,19 BORROWED HOURS 0;20 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3N.N) X
HELP-PROMPT: Type a Number between 0 and 999, 2 Decimal Digits
DESCRIPTION:
This field contains the number of hours worked by employees borrowed from other Services.
117.1,20 COMM OFFICE 1;0 POINTER Multiple #117.11
117.11,.01 COMM OFFICE 0;1 POINTER TO COMMUNICATION OFFICE FILE (#119.73)
LAST EDITED: APR 23, 2003
HELP-PROMPT: This entry is required, enter Communications Office code
CROSS-REFERENCE: 117.11^B
1)= S ^FH(117.1,DA(1),1,"B",$E(X,1,30),DA)=""
2)= K ^FH(117.1,DA(1),1,"B",$E(X,1,30),DA)
117.11,2 DAILY FTEE 0;2 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
117.11,3 CLINICAL FTEE 0;3 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
117.11,4 ADMINISTRATIVE FTEE 0;4 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
117.11,5 SUPPORT STAFF FTEE 0;5 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
117.11,6 CFWS FTEE 0;6 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."4.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 3 Decimal Digits
117.11,7 DAYS OFF HOURS 0;7 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>9999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 9999, 2 Decimal Digits
117.11,8 LWOP & AWOL HOURS 0;8 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,9 OVERTIME HOURS 0;9 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,10 UNSCHEDULED HOURS 0;10 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,11 INTERMITTENT HOURS 0;11 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,12 COP HOURS 0;12 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,13 ANNUAL LEAVE HOURS 0;13 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,14 SICK LEAVE HOURS 0;14 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,15 OTHER LEAVE HOURS 0;15 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,16 LOANED/UNION HOURS 0;16 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,17 COMP. HOURS 0;17 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,18 TRAINEE HOURS 0;18 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,19 VOLUNTEER HOURS 0;19 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
117.11,20 BORROWED HOURS 0;20 NUMBER
INPUT TRANSFORM: K:+X'=X!(X>999)!(X<0)!(X?.E1"."3.N) X
LAST EDITED: MAR 07, 2003
HELP-PROMPT: Type a number between 0 and 999, 2 Decimal Digits
FILES POINTED TO FIELDS
COMMUNICATION OFFICE (#119.73) COMM OFFICE:COMM OFFICE (#.01)
INPUT TEMPLATE(S):
FHADM4 OCT 10, 2003@11:31 USER #0
This template is used to input daily data into the Staffing
Guidelines file (117.1).
FHMADM4 OCT 10, 2003@11:22 USER #0
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):