LONG_TERM_GOALS

(SQL Table)
Index Back

Long-Term Career Goals

LONG_TERM_GOALS is part of Career Planning for an employee. Use it to identify an employee's long-term career goals as well as estimated and actual completion dates.

  • Parent record: CAREERPLAN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EST_COMPLETION_DT Date(10) DATE NOT NULL Estimated Completion Date
    4 CAREER_GOAL Character(120) VARCHAR2(120) NOT NULL Career Goal
    5 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date