D0500510B - Get Goal Action
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| szGoalCode | GOAL | char | REQ | INPUT | 
A code that specifies a competency goal for one or more employees. You can associate competency goals with specific competency 
  | ||||
| nGoalSequence | GSEQ | integer | REQ | INPUT | 
This field is part of the F05117 - Goal Action Plan table and is used as the second data item in the primary key. The value for this field is 
  | ||||
| nGoalActionID | GAID | integer | REQ | INPUT | 
This field is used as part of the primary key for the table F051171. It is generated by reading the most recent record and adding on to GAID.  | ||||
| mnSuggestionID | SGID | MATH_NUMERIC | OPT | OUTPUT | 
This field us a unique key in the F05105 table. It is generated by reading the last suggestion record and adding 1.  | ||||
| szGoalActonStatus | GASTS | char | OPT | OUTPUT | 
A user defined code (05/G3) that specifies the current status of the Goal Action record.  | ||||
| szGoalActionDescription | GAD | char | OPT | OUTPUT | 
A user defined code (05/S3) that specifies a goal action. This value is initially copied from the Goal Suggestions table (F05105).  | ||||
| jdDateSet | GLDT | JDEDATE | OPT | OUTPUT | 
The date on which the competency goal was set for the employee.  | ||||
| jdEstimateStartDate | ESD | JDEDATE | OPT | OUTPUT | 
The date when the goal becomes effective.  | ||||
| jdEstimateEndDate | ESED | JDEDATE | OPT | OUTPUT | 
The date on which the goal is either completed or becomes ineffective.  | ||||
| jdENDDATE | TREN | JDEDATE | OPT | OUTPUT | 
The date on which the training course ended.  | ||||
| jdSTARTDATE | TRSD | JDEDATE | OPT | OUTPUT | 
The date on which the training course started.  | ||||
| szChangeReason99 | CHRN | char | OPT | OUTPUT | 
A user defined code (05/CH) that represents the reason why the employee changed the goal.  | ||||
| mnGoalCreatedBy | GCB | MATH_NUMERIC | OPT | OUTPUT | 
This field contains the Address Book number of the employee creating the goal.  | ||||
| szGoalOriginatorType | GOT | char | OPT | OUTPUT | 
This field is use to track the type of employee that created the goal. It is based on the UDC 08/AN.  | ||||
| None | 
| None |