F48307ResourceAvailableHours

Resource Available Hours

Minor Business Rule

Object Name: B4803030

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose

This business function returns the capacity for a resource type / number based on details stored in the F48307 Resource Working Hours table.

Setup Notes and Prerequisites

Need to setup the following
• Use P48310 Resource Master to enter either individual or asset resource types. The base calendar
code structure is defined in this table.
• Use P48307 Resource Working Hours to setup both base and individual resource working hours.

Special Logic

Currently only Daily and Weekly period buckets are available within the resource assignment application.

If processing weekly period buckets, business function calculates the daily amounts internally, then sums up and outputs the weekly amounts.

Technical Specification

1.Validate Inputs

a.Confirm resource type, number and project from date not blank

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cActionCode	ACTN	char	REQ	INPUT
A code that specifies the action that is performed. Valid values are: A Add C Change
cUpdateMasterFile	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cProcessEdit	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	DTAI	char	OPT	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szVersion	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
szResourceType	RRTY	char	REQ	INPUT
A code that identifies the type of resource for which you are entering competency information. This is a user defined code (05/RT). Valid values are: 01 Individual 02 Asset, such as equipment
mnResourceNumber	RSCN	MATH_NUMERIC	REQ	INPUT
A number that represents either the address number or the asset number,depending on whether the resource that you are working with is a person or a piece of equipment. The system uses the resource number in conjunction with the resource type for unique identification.
jdDateFrom	DTFR	JDEDATE	OPT	INPUT
The beginning date for which the transaction or code is applicable.
nNumberOfPeriods	INT01	integer	OPT	INPUT
Number of Days in Future to Query for Responses Due.
cPeriodType	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnHoursAvailable9_1	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_2	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_3	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_4	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_5	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_6	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_7	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_8	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_9	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_10	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_11	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_12	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_13	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_14	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_15	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_16	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_17	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_18	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_19	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_20	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_21	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_22	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_23	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_24	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_25	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_26	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_27	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_28	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_29	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_30	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_31	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_32	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_33	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_34	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_35	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_36	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_37	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_38	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_39	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_40	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_41	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_42	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_43	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_44	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_45	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_46	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_47	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_48	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_49	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_50	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_51	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.
mnHoursAvailable9_52	DAVL	MATH_NUMERIC	OPT	OUTPUT
The number of hours a resource is available for scheduling on a single day.