F1207BeginUpdate

F1207 Update PM Schedule Status

Major Business Rule

Object Name: B1200110

Parent DLL: CMFG

Location: Client/Server

Language: C

Data Structure

D1200110A - F1207 Begin Update Data Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szProgramID	PID	char	OPT	INPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cProcessEdits	EV01	char	OPT	INPUT
1' = Interactive ^
cSuppressErrorMessages	EV02	char	OPT	INPUT
'1' - Will not display systems errors ^
jdPOThruDate	TRDJ	JDEDATE	OPT	INPUT
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.
szPOFromStatus	STSOW	char	OPT	INPUT
A user defined code (system 12, type MS) that indicates the maintenance status on a piece of equipment, such as 50 for maintenance due or 60 for waiting for parts. NOTE: Status code 99 is reserved for completed maintenance. Status code 01,the default, is reserved for initial maintenance setup.
szPOToStatus	DSTOW	char	OPT	INPUT
Use this field to change the maintenance status of selected records.
szPOChangeStatus	SRST	char	OPT	INPUT
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from 90 through 99 triggers the system to automatically update the completion date.
cPOPrintFlag	EV03	char	OPT	INPUT
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX, and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.
cPOPrintNumberFlag	EV04	char	OPT	INPUT
PeopleSoft event point processing flag 04.
cPOCreateWOFlag	EV05	char	OPT	INPUT
A flag that indicates whether automatic spell check is turned on.
jdPOStartDateWO	STRT	JDEDATE	OPT	INPUT
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine starts with the required date and offsets the total leadtime to calculate the appropriate start date.
cPOUseSystemDateFlag	EV06	char	OPT	INPUT
An option that specifies the type of processing for an event.
cPOProjectStartDateFlag	EV07	char	OPT	INPUT
An option that specifies the type of processing for an event.
cPOCrossReferenceFlag	EV08	char	OPT	INPUT
An option that specifies the type of processing for an event.
cPOUpdateLastCompletedFlag	EV09	char	OPT	INPUT
An option that specifies the type of processing for an event.
szPOCraftWorkCenter	MCU	char	OPT	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cPOEstimateOccurFlag	EV10	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	OUTPUT
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.
szProcessModule	VC04A	char	OPT	INPUT
This is a generic field used as a work field in Everest.
szPOOrderType	DCTO	char	OPT	INPUT
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
cPOPastProjectedDates_EV01	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnDaysAdded_NMDYS	NMDYS	MATH_NUMERIC	OPT	INPUT
This field represents a number of days. The value is available when printing a letter. Valid values: 1-999
szPOPartsListVersion_VERS	VERS	char	OPT	INPUT
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.
szPORoutingsVersion_VERS	VERS	char	OPT	INPUT
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.
szPOForecastType_TYPF	TYPF	char	OPT	INPUT
A user defined code (34/DF) that indicates one of the following: o The forecasting method used to calculate the numbers displayed about the item o The actual historical information about the item

Related Functions

B1300060 F1207 Calculate Estimated Occurrences
X1202 F1201 Validate Asset Number
X4801 X4801 Work Order Entry Master Business Function

Related Tables

F1207 Maintenance Schedule File
F13907 Associated Service Types
F1393 Maintenance Rules

F1207EndUpdate

F1207 Update PM Schedule Status

Major Business Rule

Object Name: B1200110

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
This function will close all tables that were opened by this function and called business functions.
All caches created by this function will be destroyed.

Setup Notes and Prerequisites

Special Logic

Technical Specification



F1207EndUpdate


I1200110_SetUpEndProcessing


 I1200110_GetHuser


 I1200110_CreateCache


I1200110_ClearMemoryToX1200


 X1200 Memory Free Fixed Asset Retrieval


 I1200110_ClearF4802


 B3100860 F4802 Close


 I1200110_CloseTables


 Table IF1207, F1393, F13907, F1308, F0911 (Close)


 I1200110_DestroyCache

Data Structure

D1200110D - F1207 End Update Data Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cSuppressErrorMessages	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	OUTPUT
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.
szProcessModule	VC04A	char	OPT	INPUT
This is a generic field used as a work field in Everest.

Related Functions

B1300060 F1207 Calculate Estimated Occurrences
X1202 F1201 Validate Asset Number
X4801 X4801 Work Order Entry Master Business Function

Related Tables

F1207 Maintenance Schedule File
F13907 Associated Service Types
F1393 Maintenance Rules

F1207GetPrintCacheRow

F1207 Update PM Schedule Status

Major Business Rule

Object Name: B1200110

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
This function will retrieve the print cache record using the input Cache Row Number as the index. It
will then load the retrieved values to the appropriate output parameter.

Setup Notes and Prerequisites
To retrieve multiple records, use the output nCacheRowCounter from F1207 Update PM Schedule Status
function to create a loop. Increment the counter and call this function until the counter >
nCacheRowCounter.

Special Logic

Technical Specification




F1207GetPrintCacheRow


I1200110_SetUpPrintProcessing


 I1200110_GetHuser


 I1200110_PrintInitStructures


 I1200110_CreateCache


 I1200110_OpenCursor


I1200110_GetPrintRecordFromCache


 I1200110_LoadPrintOutput


 I1200110_TerminateInitCache

Data Structure

D1200110C - F1207 Print Cache Data Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
nCacheRow	INT01	integer	REQ	INPUT
Number of Days in Future to Query for Responses Due.
cSuppressErrorMessages	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	OUTPUT
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.
szOutputNumber	DL01	char	OPT	OUTPUT
Asset, Unit or Serial Number (depending on Processing Option 5) in 26 character string format ^
szNumberDescription	DL02	char	OPT	OUTPUT
Additional text that further describes or clarifies a field in the system.
szServiceType	SRVT	char	OPT	OUTPUT
A user defined code (12/ST) that describes the preventive maintenance service to be performed. Examples of codes include CLUTCH for adjust clutch, OIL for change oil, and 10H for 10 hour service.
mnMaintPercentComplete	MPC	MATH_NUMERIC	OPT	OUTPUT
A percentage measure that indicates how close a piece of equipment is to requiring maintenance. This percentage is based on the greater of the actual date, miles, hours, or fuel consumption compared to the threshold date, miles,hours, or fuel consumption. A percentage of 090 means that the piece of equipment is 10% away from requiring maintenance. A percentage greater than 100 means that maintenance is past due.
szMaintenanceStatus	MSTS	char	OPT	OUTPUT
A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for waiting for parts. Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code 01 (default) is reserved for initial maintenance setup.
mnWOAssigned	WONA	MATH_NUMERIC	OPT	OUTPUT
The Work Order Number related to a particular Equipment Maintenance line item. The system assigns this number from next numbers.
mnCompletedMilesHours	CPLM	MATH_NUMERIC	OPT	OUTPUT
Actual miles at completion of maintenance.
mnConsumedFuel	CPLH	MATH_NUMERIC	OPT	OUTPUT
Actual quantity of fuel consumed at completion of maintenance.
mnCompletedHours	CPLF	MATH_NUMERIC	OPT	OUTPUT
Actual hours at completion of maintenance.
mnLastMilesHours	LSTM	MATH_NUMERIC	OPT	OUTPUT
Number of miles at last maintenance.
mnLastFuelConsumed	LSTH	MATH_NUMERIC	OPT	OUTPUT
Fuel consumed at last maintenance.
mnLastHours	LSTF	MATH_NUMERIC	OPT	OUTPUT
Number of hours at last maintenance.
mnOriginalMiles	ORGM	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original miles meter reading.
mnOriginalFuel	ORGF	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original fuel meter reading.
mnOriginalHours	ORGH	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original hours meter reading.
cSymbol	SMU	char	OPT	OUTPUT
A value that identifies an asset. You can assign one of three different types of numbers: o Asset Number - an eight digit, system assigned number o Serial Number - a 25 digit model or serial number o Unit Number - a 12 digit, alphanumeric, user defined number When you enter an asset number, you may use a prefix or symbol to designate the type of number you enter. For the type of asset number you use most often, you should use no prefix, so that you just need to enter the number. For the other two types of asset numbers, you should define a symbol for each, such as / or , that you will enter as a prefix before the number to identify which type of number you are representing. For example, if you enter serial numbers most often, you should use no prefix for serial numbers. Then you might use / as a prefix for asset numbers and as a prefix for unit numbers. Note: You can leave only one type of asset number with no prefix. The other two must have a symbol so that all three numbers are unique. Verify that the symbols that you use are not significant for any other purposes of data entry, for example, a period or comma.
mnLastOriginalMiles	ORGM	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original miles meter reading.
mnLastOriginalFuel	ORGF	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original fuel meter reading.
mnLastOriginalHours	ORGH	MATH_NUMERIC	OPT	OUTPUT
The balance for the statistical account which tracks the original hours meter reading.
szPrintErrorMessage	DL03	char	OPT	OUTPUT
Additional text that further describes or clarifies an element.
mnOriginalPercentComplete	MPC	MATH_NUMERIC	OPT	OUTPUT
A percentage measure that indicates how close a piece of equipment is to requiring maintenance. This percentage is based on the greater of the actual date, miles, hours, or fuel consumption compared to the threshold date, miles,hours, or fuel consumption. A percentage of 090 means that the piece of equipment is 10% away from requiring maintenance. A percentage greater than 100 means that maintenance is past due.
szOriginalStatus	MSTS	char	OPT	OUTPUT
A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for waiting for parts. Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code 01 (default) is reserved for initial maintenance setup.
cScheduleType	PDFG	char	OPT	OUTPUT
A code that indicates the type of maintenance schedule. Enter a value from UDC table 13/ST (Schedule Type). Valid values are: Blank Interval-Based Schedule. This type of preventive maintenance schedule uses a service interval to determine when maintenance should be performed. Examples include an oil change that occurs every 3000 miles or an inspection that occurs every 30 days. 1 Unscheduled Maintenance. This type of preventive maintenance schedule entails maintenance that is performed on an ad hoc basis. You use the Work With Unscheduled Maintenance program (P13UM) to specify when the scheduled maintenance should be performed. Examples include replacing a windshield or washing a vehicle. 2 Condition-Based Schedule. This type of preventive maintenance schedule uses an alert level, indicated by the condition of the equipment, to determine when maintenance should be performed. Examples include replacing tires based on their tread depth or replacing an electric motor that is overheating.

Related Functions

B1300060 F1207 Calculate Estimated Occurrences
X1202 F1201 Validate Asset Number
X4801 X4801 Work Order Entry Master Business Function

Related Tables

F1207 Maintenance Schedule File
F13907 Associated Service Types
F1393 Maintenance Rules

F1207UpdatePMScheduleStatus

F1207 Update PM Schedule Status

Major Business Rule

Object Name: B1200110

Parent DLL: CMFG

Location: Client/Server

Language: C

Functional Description

Purpose
'b7 This is the main function.  It handles all update processing.
'b7 A F1207 record's unique key ID is required input.  This record is then fetched from the F1207.
'b7 The Asset Number is then used as input to retrieved the corresponding F1201 record.
'b7 The maintenance rules are then retrieved from the F1393 using the service type and asset number
as keys.  If Processing Options are blank, the values will be used from the maintenance rules.
'b7 If the F1207 record's Status is between the To and From Status (PO or Maintenance Rules), status
change is determined.  Meter readings for Miles, Hours and Fuel are accumulated and the percent due
and start date is determined for each.
'b7 If a WO is already assigned the Start Date is updated in the F4801.
'b7 If the status is valid to be changed and the PO Create WO flag = '1', a new Work Order is created
in the F4801.
'b7 If the status is valid, the record is then loaded to the Print Cache and updated in the F1207.
'b7 Maintenance is then rescheduled: creating a new F1207 record.
'b7 All records in the F1308 that match the Asset Number and Service Type are either updated or added
to the F1207 table.  (Maintenance Loops)
'b7 If associated items are found in the F13907, the process is repeated for each record found.

Setup Notes:
'b7 To process multiple records, call this function for each record in the F1207 that should be
processed.

Special Logic:
'b7 Setting cProcessEdits = '1' is used when called from an interactive program such as P13UM.
Percent Due is not calculated but set to 100%.
'b7 If creating Work Orders, the F1207 MUST have a model WO attached (FWDOCO).
'b7 This function returns the Unique Key ID of the first F1207 record it creates.  This is used in
the batch program to ensure that the data selection does not include the newly created records when
updating the schedule.
'b7 The Cache Row Counter is used after all calls to this function have finished processing.  The
counter informs the calling function how many records exist in the Print Cache.

Setup Notes and Prerequisites

Special Logic

Technical Specification




F1207UpdatePMScheduleStatus


I1200110_SetUpUpdateProcessing


 I1200110_GetHuser


 I1200110_BeginUpdateStructures


 I1200110_SetTableParameters


 I1200110_CreateCache


 I1200110_GetAuditInformation


 B9800100 Get Audit Info


I1200110_ProcessRecord


 I1200110_FetchF1207Record


 Table IF1207 (Fetch)


 I1200110_GetServiceTypeDescription


 X0005 Get UDC


 I1200110_FetchF1201Record


 X1202 F1201GetItemMasterByAssetNumber


 I1200110_GetPrimaryAssetNumber


 X1202 F1201 Return Primary Asset Number


 I1200110_LoadRulesData


 Table IF1393


 I1200110_DetermineStatusChange


 I1200110_CheckServiceType


 I1200110_GetServiceRecordFromCache


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_CheckCraft


 Table IF3003


 I1200110_CheckScheduledDate


 I1200110_CheckServiceDays


 I1200110_CalculatePercentDue


 I1200110_CheckServiceHours


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_ProjectStartDate


 I1200110_AccumulateMeterUnits


 I1200110_SelectF0911Records


 Table IF0911 (Select)


 Table IF0911 (Fetch)


 I1200110_CheckFuelUsage


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_ProjectStartDate


 I1200110_AccumulateMeterUnits


 I1200110_SelectF0911Records


 Table IF0911 (Select)


 Table IF0911 (Fetch)


 I1200110_CheckServiceMiles


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_ProjectStartDate


 I1200110_AccumulateMeterUnits


 I1200110_SelectF0911Records


 Table IF0911 (Select, Fetch)


 I1200110_DetermineStartDate


 I1200110_UpdateWOStartDate


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_LoadWOEditLineDefault


 I1200110_LoadWOEditLine


 I1200110_CallX4801


 X4801 F4801 Edit Document


 I1200110_LoadWOEndDocDefault


 X4801 F4801 End Document


 X4801 F4801 Clear Work File


 I1200110_DeterminePercentDue


 I1200110_CalcEstOccurrences


 B1300060 F1207 Calculate Estimated Occurence


 I1200110_UpdateStatus


 I1200110_CheckMultiple


 Table IF1207 - Fetch Key 6


 I1200110_CreateWO


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_LoadWOEditLine


 I1200110_LoadWOEditLineDefault


 I1200110_LoadParentItem


 I1200110_FetchF1201Record


 I1200110_CallX4801


 X4801 F4801 Edit Document


 I1200110_LoadWOEndDocDefault


 X4801 F4801 End Document


 X4801 F4801 Clear Work File


 I1200110_FetchF4802Record


 B3100860 F4802 Get WO Text Row 


 I1200110_CreateF4802Record


 B3100860 F4802 Write WO Text Row


 I1200110_CallX13807 - future


 I1200110_LoadPrintCache


 I1200110_AddPrintRecordToCache


 I1200110_LoadF1207Audit


 I1200110_UpdateF1207


 Table IF1207 (Update)


 I1200110_UpdateServiceTypeCache


 I1200110_GetServiceRecordFromCache


 I1200110_UpdateServiceRecordToCache


 I1200110_AddServiceRecordToCache


 I1200110_RescheduleMaintenance


 N1300090 Calculation of Schedule Date


 I1200110_CreateF1207Record


 I1200110_GetF1207UniqueID


 Table IF1207 (Select, Sort, Fetch)


 Table IF1207 (Insert)


 I1200110_UpdateServiceTypeCache


 I1200110_GetServiceRecordFromCache


 I1200110_UpdateServiceRecordToCache


 I1200110_AddServiceRecordToCache


 I1200110_MaintenanceLoops


 Table IF1308 (Select, Fetch)


 Table IF1207 (Fetch)


 I1200110_FetchF1201Record


 X1202 F1201GetItemMasterByAssetNumber


 I1200110_GetPrimaryAssetNumber


 X1202 F1201 Return Primary Asset Number


 I1200110_LoadF1207Audit


 I1200110_UpdateF1207


 Table IF1207 (Update)


 I1200110_CreateF1207Record


 I1200110_GetF1207UniqueID


 Table IF1207 (Select, Sort, Fetch)


 Table IF1207 (Insert)


 I1200110_GroupMaintenance


 Table IF13907 (Select, Fetch)


 Table IF1207 (Select, Fetch)


 I1200110_UpdateWOStatus


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_LoadWOEditLineDefault


 I1200110_LoadWOEditLine


 I1200110_CallX4801


 X4801 F4801 Edit Document


 I1200110_LoadWOEndDocDefault


 X4801 F4801 End Document


 X4801 F4801 Clear Work File


 I1200110_DetermineStatusChange


 I1200110_CheckServiceType


 I1200110_GetServiceRecordFromCache


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_CheckCraft


 Table IF3003


 I1200110_CheckScheduledDate


 I1200110_CheckServiceDays


 I1200110_CalculatePercentDue


 I1200110_CheckServiceHours


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_ProjectStartDate


 I1200110_AccumulateMeterUnits


 I1200110_SelectF0911Records


 Table IF0911 (Select)


 Table IF0911 (Fetch)


 I1200110_CheckFuelUsage


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_'1a'1a





Data Structure
D1200110B - F1207 Update PM Schedule Status Data Structure

 
Parameter Name Data Item Data Type Req/Opt I/O/Both
mnF1207UniqueKeyID UKID MATH_NUMERIC REQ INPUT
This field is a unique number used to identify a record in a file.
cProcessEdits EV01 char REQ INPUT


'1'  Interactive


else  Batch





cSuppressErrorMessages EV02 char OPT INPUT
An option that specifies the type of processing for an event.


szErrorMessageID DTAI char OPT OUTPUT
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.








nCacheRowCounter INT01 integer OPT OUTPUT


Number of records written to Print Cache if Print Report processing option = '1'




^
mnAssignedWO WONA MATH_NUMERIC OPT OUTPUT
The Work Order Number related to a particular Equipment Maintenance line item.



The system assigns this number from next numbers.
szMaintenanceStatus MSTS char OPT OUTPUT
A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for 

waiting for parts.



Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code 

01 (default) is reserved for initial maintenance setup.


mnMaintPercentComplete MPC MATH_NUMERIC OPT OUTPUT
A percentage measure that indicates how close a piece of equipment is to requiring maintenance. This percentage is based on the greater 

of the actual date, miles, hours, or fuel consumption compared to the threshold date, miles,hours, or fuel consumption. A percentage of 090 

means that the piece of equipment is 10% away from requiring maintenance. A percentage greater than 100 means that maintenance is past 

due.
jdDatePlannedToStart PNST JDEDATE OPT OUTPUT
The date when the item or line of work is to start.
cPrintFlag EV02 char OPT INPUT
An option that specifies the type of processing for an event.


mnLowestCreatedUKID UKID MATH_NUMERIC OPT OUTPUT


Used in R12807.  Since this function will create new F1207 records, the new records will be read by the fetch in the UBE and processed.   To eliminate 

processing the new records, a comparison is made in the UBE to determine if the record is lower than the lowest newly created record.




^
szProcessModule VC04A char OPT INPUT
This is a generic field used as a work field in Everest.
cDefaultOwner DEFOW char OPT INPUT
A code that specifies which customer the system defaults to assigned work orders for scheduled maintenance. Valid values are:

 



Blank

Default the customer from the model work order.



1

Default the customer from the equipment.


cDefaultSite DEFST char OPT INPUT
A code that specifies which site the system defaults to assigned work orders for scheduled maintenance. Valid values are:

 

Blank

Default 

the site from the model work order.



1

Default the site from the equipment.


cErrorCode_ERRC ERRC char OPT OUTPUT


This parameter is used to pass back an error code from inside of B1200110. This 

code is used to trigger appropriate error messages. Valid values are:


0 = No Error


1 = Warning


2 = Error





cCreateResourceAssignment EV01 char REQ INPUT
An option that specifies the type of processing for an event.



Related Functions

 
B1300060  	F1207 Calculate Estimated Occurrences

X1202     	F1201 Validate Asset Number

X4801     	X4801 Work Order Entry Master Business Function


Related Tables

 
F1207     	Maintenance Schedule File

F13907    	Associated Service Types

F1393     	Maintenance Rules




:Courier New;font-size:10pt">


'b7 If associated items are found in the F13907, the process is repeated for each record found.





Setup Notes:


'b7 To process multiple records, call this function for each record in the F1207 that should be 

processed.





Special Logic:


'b7 Setting cProcessEdits = '1' is used when called from an interactive program such as P13UM.  

Percent Due is not calculated but set to 100%.


'b7 If creating Work Orders, the F1207 MUST have a model WO attached (FWDOCO).


'b7 This function returns the Unique Key ID of the first F1207 record it creates.  This is used in 

the batch program to ensure that the data selection does not include the newly created records when 

updating the schedule.


'b7 The Cache Row Counter is used after all calls to this function have finished processing.  The 

counter informs the calling function how many records exist in the Print Cache.








Setup Notes and Prerequisites





Special Logic











Technical Specification





F1207UpdatePMScheduleStatus


I1200110_SetUpUpdateProcessing


 I1200110_GetHuser


 I1200110_BeginUpdateStructures


 I1200110_SetTableParameters


 I1200110_CreateCache


 I1200110_GetAuditInformation


 B9800100 Get Audit Info


I1200110_ProcessRecord


 I1200110_FetchF1207Record


 Table IF1207 (Fetch)


 I1200110_GetServiceTypeDescription


 X0005 Get UDC


 I1200110_FetchF1201Record


 X1202 F1201GetItemMasterByAssetNumber


 I1200110_GetPrimaryAssetNumber


 X1202 F1201 Return Primary Asset Number


 I1200110_LoadRulesData


 Table IF1393


 I1200110_DetermineStatusChange


 I1200110_CheckServiceType


 I1200110_GetServiceRecordFromCache


 I1200110_GetWorkOrder


 B3100330 Verify And Get Work Order Master


 I1200110_CheckCraft


 Table IF3003


 I1200110_CheckScheduledDate


 I1200110_CheckServiceDays


 I1200110_CalculatePercentDue


 I1200110_CheckServiceHours


 I1200110_GetAccountID


 B000055 Validate AAI Completely


 I1200110_ProcessServiceAmounts


 I1200110_AccumMeterReadings


 I1200110_LoadX1200Default


 I1200110_CallX1200


 X1200 F1202 Date Sensitive Retrieval


 I1200110_CalculatePercentDue


 I1200110_ProjectStartDate


 I1200110_AccumulateMeterUnits


 I1200110_SelectF0911Records

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnF1207UniqueKeyID	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
cProcessEdits	EV01	char	REQ	INPUT
'1' Interactive else Batch
cSuppressErrorMessages	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	OPT	OUTPUT
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.
nCacheRowCounter	INT01	integer	OPT	OUTPUT
Number of records written to Print Cache if Print Report processing option = '1' ^
mnAssignedWO	WONA	MATH_NUMERIC	OPT	OUTPUT
The Work Order Number related to a particular Equipment Maintenance line item. The system assigns this number from next numbers.
szMaintenanceStatus	MSTS	char	OPT	OUTPUT
A user defined code (12/MS) that indicates the maintenance status of a piece of equipment, such as 50 for maintenance due or 60 for waiting for parts. Note: Status code 98 is reserved for cancelled maintenance. Status code 99 is reserved for completed maintenance. Status code 01 (default) is reserved for initial maintenance setup.
mnMaintPercentComplete	MPC	MATH_NUMERIC	OPT	OUTPUT
A percentage measure that indicates how close a piece of equipment is to requiring maintenance. This percentage is based on the greater of the actual date, miles, hours, or fuel consumption compared to the threshold date, miles,hours, or fuel consumption. A percentage of 090 means that the piece of equipment is 10% away from requiring maintenance. A percentage greater than 100 means that maintenance is past due.
jdDatePlannedToStart	PNST	JDEDATE	OPT	OUTPUT
The date when the item or line of work is to start.
cPrintFlag	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnLowestCreatedUKID	UKID	MATH_NUMERIC	OPT	OUTPUT
Used in R12807. Since this function will create new F1207 records, the new records will be read by the fetch in the UBE and processed. To eliminate processing the new records, a comparison is made in the UBE to determine if the record is lower than the lowest newly created record. ^
szProcessModule	VC04A	char	OPT	INPUT
This is a generic field used as a work field in Everest.
cDefaultOwner	DEFOW	char	OPT	INPUT
A code that specifies which customer the system defaults to assigned work orders for scheduled maintenance. Valid values are: Blank Default the customer from the model work order. 1 Default the customer from the equipment.
cDefaultSite	DEFST	char	OPT	INPUT
A code that specifies which site the system defaults to assigned work orders for scheduled maintenance. Valid values are: Blank Default the site from the model work order. 1 Default the site from the equipment.
cErrorCode_ERRC	ERRC	char	OPT	OUTPUT
This parameter is used to pass back an error code from inside of B1200110. This code is used to trigger appropriate error messages. Valid values are: 0 = No Error 1 = Warning 2 = Error
cCreateResourceAssignment	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.