Docstoc

Professional Record Company Business Plan

Document Sample
Professional  Record Company Business Plan Powered By Docstoc
					Click on a record name below to see a list of available fields.

Record Name               Description
ABSENCE_HIST              EE Absence
ACTION_TBL                ACTION Setup Table
ACTN_REASON_TBL           Action/Reason Combinations
BEN_PROG_PARTIC           EE Benefit Programs
CITIZEN_STS_TBL           Citizen Status Table
CITIZENSHIP               EE/Dependent Citizenship
COMPENSATION              EE Compensation Data
COUNTRY_TBL               Countries
CU_BUDCENTR_TBL           Clemson Budget Center / Depts
CU_BUSN_ADDR              Address Type
CU_CHKPICKUP_VW
CU_DUAL_EMP_JOB           Dual Employment Job
CU_EMP_HISTORY            Personnel Data - Current Date
CU_EMPLOYEES              Personnel Data - Current Date
CU_EMPVERIFY_VW           CU_EMP_VERIFY_VW
CU_FURLOUGH_B             CU Furlough Plan B
CU_GRAD_DIFF              CU_GRAD_DIFF
CU_GRAD_DIST              CU_GRAD_DIST
CU_GRAD_SRCH              CU Grad Diff - Dept Security
CU_LEAVE_COMHIS           EE Absence Details
CU_LEAVE_DTLHIS           old Absence details
CU_LEAVE_TOTHIS           Leave Accruals history
CU_PAY_INFO_VW            CU Pay Check# VW for Query
CU_PAY_SHEET_VW           CU Pay Sheet View for Query
CU_PAYSHEET_ACC
CU_PAYSHEET_DE
CU_PAYSHEET_VW
CU_POSITION_SC            State position information
CU_POSN_POOL_ID           Manager Info & Position Pool
CU_RECUR_PAY_VW           CU_RECUR_PAY_VW
CU_SPE_PAY_DIST           CU_SPECIAL_PAY
CU_SPECIAL_PAY            CU_SPECIAL_PAY
DEPT_TBL                  Departments
EMAIL_ADDRESSES           Email Addresses
EMERGENCY_CNTCT           EE Emergency Contacts
EMPLOYMENT                EE General Employment Data
JOB                       EE Job History
JOB_EARNS_DIST            EE Job Earnings Distribution
JOBCODE_TBL               Job Codes
LEAVE_ACCRUAL             EE Leave Accruals
LEAVE_PLAN                EE Leave Benefit Enrollments
LOCATION_TBL              Company Site Locations
MAJOR_TBL                 College Major Subject Codes
NAME_CURR_VW     Current Name Vw all types
NAMES            Person Names
PERS_NID         PERS_NID Record
PERSON           PERSON record
PERSON_NAME      Current Primary Name View
PERSONAL_DATA    PERSONAL_DATA for Rpting
PERSONAL_VW      Personal Data Name View
POSITION_DATA    Position Data
POSN_INCUMBENT   Posn Incumbents - Emplid Only
POSN_VACANT      Vacant Budgeted Posns by Dept
PSXLATITEM       Translate Value Items
SCRTY_TBL_DEPT   OprID Access to Departments
VISA_PMT_DATA    EE/Dependent Visa Data
Return to Record List
                   ABSENCE_HIST - EE Absence

Field                    Description
ABSENCE_CODE              Absence Code
ABSENCE_TYPE              Absence Type
ABS_APPROVED_DT           Date Approved
ABS_BEGIN_TM              Begin Time
ABS_DUR_WEEKS_UK          Duration (Weeks)
ABS_ENTRY_PANEL           Absence Entry Panel
ABS_PCT_PAID_UK           Percent Paid
ABS_POSTPND_LVE_UK        Begin Date Postponed
ABS_RECURRENCE            Absence Recurrence
ABS_RETURN_TM             Return Time
ACCRUED_TAKEN_CU          Accrued or Taken
AWC_DT                    Actual Week of Child Birth
BEGIN_DT                  Begin Date
BIRTH_DT                  Actual Birth Date
COUNSELLING               Counselling
DATE_ENTERED_CU           Date Entered
DATE_POSTED_CU            Date Posted
DAYS_ABSENCE_ITA          Fiscal Days of Absence
DEPENDENT_BENEF           Dependent/Beneficiary ID
DISCIPLINARY              Disciplinary
DOC_CONSULTED             Doctor Consulted
DOC_CONSULT_DT            Consultation Date
DUE_DT                    Expected Birth Date
DURATION_DAYS             Duration (Days)
DURATION_HOURS            Duration (Hours)
DURATION_HOURS_CU         Duration (Hours)
ELIGIBLE                  Eligible
ELIG_EXT_LEAVE            Eligible for Additional Leave
EMPLID                    EmplID
EMPLOYER_APPROVED         Employer - Approved
EMPL_RCD                  Empl Rcd Nbr
END_MAN_REP_DT_BEL        End Date Mandatory Replacement
EWC_DT                    Expected Week of Child Birth
EXP_ML_END_DT             Expected End of Leave
FISCAL_VISIT              Fiscal Visit
FLAG_POSTED_CU            Flag Posted
FLAG_VOID_CU              Flag Void CU
INCIDENT_NBR              Incident Number
INDUSTRIAL_INJURY         Work Injury Related
MANDAT_REPL_BEL           Mandatory Replacement
MATB1_RECEIVED_DT         Form MATB1 Received
MPP_EARLIEST_DT           Earliest Start of MPP
MPP_EXPECTED_END          Expected End of MPP
MPP_START_DT         MPP Actual Start Date
NOTIFIED_BY          Notified of Absence By Whom
NOTIFIED_DT          Date First Notified
NOTIFIED_RETURN_DT   Notified Return Date
NOTIFIED_TM          Time First Notified
NOTIF_END_DT_NLD     End Notification Date
NOTIF_MLSTART_DT     Date Notified of Actual Start
NOTIF_START_DT_NLD   Begin Notification Date
ORIG_ABS_TYPE_BEL    Original Absence Type
ORIG_BEGIN_DT_BEL    Start Date
ORIG_EMPL_RCD_BEL    Employment Record Nbr
PAID_UNPAID          Paid/Unpaid
PROT_END_DT_GER      Protection Period End Date
PROT_START_DT_GER    Protection Period Start Date
QW_DT                Qualifying Week
REASON               Reason
REFER_TO_OHA         Refer to Occ. Health Auth.
RESLT_FISCAL_VISIT   Result of the Fiscal Visit
RETURN_DT            Return Date
RTN_CONF_RECVD_DT    Confirmation Received
RTN_WRK_REMIND_DT    Date Return Reminder Sent
SEQ_NUM              Sequence
SMP_ELIGIBLE         based on Employment Conditions
SMP_NI_ELIGIBLE      based on NI Calculation
SMP_START_DT         SMP Actual Start Date
Return to Record List
          ACTION_TBL - ACTION Setup Table

Field                  Description
ACTION                 Action
ACTION_DESCR           Action Description
ACTION_DESCRSHORT      Short Description
EFFDT                  Effective Date
EFF_STATUS             Status as of Effective Date
LASTUPDDTTM            Last Update Date/Time
LASTUPDOPRID           by
OBJECTOWNERID          Object owner identifier
SYSTEM_DATA_FLG        System Data
Return to Record List
     ACTN_REASON_TBL - Action/Reason Combinations

Field               Description
ACTION               Action
ACTION_REASON        Reason Code
DESCR                Description
DESCRSHORT           Short Description
EFF_STATUS           Status as of Effective Date
EFFDT                Effective Date
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
OBJECTOWNERID        Object owner identifier
SYSTEM_DATA_FLG      System Data
Return to Record List
      BEN_PROG_PARTIC - EE Benefit Programs

Field                Description
BENEFIT_PROGRAM      Benefit Program
COBRA_EVENT_ID       COBRA Event Identification
EFFDT                Effective Date
EMPL_RCD             Empl Rcd Nbr
EMPLID               EmplID
Return to Record List
  CITIZEN_STS_TBL - Citizen Status Table

Field                  Description
CITIZENSHIP_STATUS     Citizenship Status
COUNTRY                Country
DESCR                  Description
DESCRSHORT             Short Description
Return to Record List
      CITIZENSHIP - EE/Dependent Citizenship

Field                    Description
CITIZENSHIP_STATUS       Citizenship Status
COUNTRY                  Country
DEPENDENT_ID             Dependent ID
EMPLID                   EmplID
PERM_STATUS_DT_SGP       Permanent Status Date
WORKER_TYPE_SGP          Worker Type
Return to Record List
       COMPENSATION - EE Compensation Data

Field               Description
CHANGE_AMT          Change Amount
CHANGE_PCT          Change Percent
CHANGE_PTS          Change Points
CMP_SRC_IND         Rate Code Source
COMPRATE            Compensation Rate
COMP_EFFSEQ         Compensation Eff Sequence
COMP_FREQUENCY      Compensation Frequency
COMP_PCT            Comp Percent
COMP_RATECD         Comp Rate Code
COMP_RATE_POINTS    Comp Rate Points
CONVERT_COMPRT      Converted Comp Rate
CURRENCY_CD         Currency Code
EFFDT               Effective Date
EFFSEQ              Effective Sequence
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
FTE_INDICATOR       Apply FTE for Annualization
MANUAL_SW           Manual Row Switch
RATE_CODE_GROUP     Rate Code Group Name
Return to Record List
             COUNTRY_TBL - Countries

Field                Description
ADDR_VALIDAT         Enable Address Validation
COUNTRY              Country
COUNTRY_2CHAR        2 - Char Country Code
DESCR                Description
DESCRSHORT           Short Description
EO_SEC_PAGE_NAME     Address Edit Page
EU_MEMBER_STATE      EU Member State
POST_SRCH_AVAIL      Post Search Available
Return to Record List
    CU_BUDCENTR_TBL - Clemson Budget Center / Depts

Field               Description
BUD_CTR_CU           Budget Center
COMPANY              Company
DEPARTMENT           Department
DESCR                Description
Return to Record List
         CU_BUSN_ADDR - Address Type

Field               Description
ADDRESS1             Address Line 1
ADDRESS2             Address Line 2
ADDRESS3             Address Line 3
CITY                 City
COUNTRY              Country
COUNTY               County
EMPLID               EmplID
EMPL_RCD             Empl Rcd Nbr
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
STATE                State
ZIP                  Postal Code
Return to Record List
             CU_CHKPICKUP_VW

Field              Description
CHECK_DEPT_CU       Check Dept
CHECK_DT            Paycheck Issue Date
DEPTID              Department
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
LOCATION            Location Code
NAME                Name
PAYCHECK_NBR        Paycheck Number
PAYGROUP            Pay Group
Return to Record List
     CU_DUAL_EMP_JOB - Dual Employment Job

Field               Description
AMOUNT_DUE          Amount Due
AMOUNT_PAID         Total Payments For Charge
BEGIN_DT            Begin Date
CU_FISCAL_YEAR      Fiscal Year by Calendar Year
DEPTID              Department
DESCRLONG           Description
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
END_DT              End Date
SEQNUM              Sequence number
SETID               SetID
Return to Record List
    CU_EMP_HISTORY - Personnel Data - Current Date

Field                   Description
ACTION                   Action
ACTION_DT                Action Date
ACTION_REASON            Reason Code
ADDRESS1                 Address Line 1
ADDRESS2                 Address Line 2
ADDRESS3                 Address Line 3
ADDRESS4                 Address Line 4
ADDR_FIELD1              Address Field 1
ADDR_FIELD2              Address Field 2
ADDR_FIELD3              Address Field 3
ANNL_BENEF_BASE_RT       Annual Benefits Base Rate
ANNUAL_RT                Annual Rate
BENEFIT_RCD_NBR          Benefit Record Number
BIRTHDATE                Date of Birth
BUD_CTR_CU               Budget Center
BUSINESS_TITLE           Business Title
BUSINESS_UNIT            Business Unit
CHANGE_AMT               Change Amount
CHANGE_PCT               Change Percent
CITIZENSHIP_STATUS       Citizenship Status
CITY                     City
CLASS_INDC               Classified/Unclassified Indc
CMPNY_SENIORITY_DT       Company Seniority Date
COMPANY                  Company
COMPRATE                 Compensation Rate
COMP_FREQUENCY           Compensation Frequency
COUNTRY                  Country
COUNTY                   County
COUNTY_WORK_CU           County Work
CU_BUSN_ADDR1            Business Address Line 1
CU_BUSN_ADDR2            Business Address Line 2
CU_BUSN_ADDR3            Business Address Line 3
CU_BUSN_CITY             Business City
CU_BUSN_COUNTY           Business County
CU_BUSN_POSTAL           Business Postal Code
CU_BUSN_STATE            Business State
CU_STUDENT_ID            Clemson Student ID
DDDH_FLG_CU              Deans, Dir, Dept Heads Flag
DEPTID                   Department
DEPTNAME                 Department
DEPTNAME_ABBRV           Short Name
DEPT_ENTRY_DT            Department Entry Date
DIRECTLY_TIPPED          Tipped
DT_OF_DEATH          Date of Death
EEO1CODE             EEO - 1 Job Category
EEO4CODE             EEO - 4 Job Category
EEO4_FUNCTION        U.S. EEO4 Function
EEO5CODE             EEO - 5 Job Category
EEO6CODE             EEO - 6 Job Catgory
EEO_CLASS            EEO Classification
EEO_JOB_GROUP        EEO Job Group
EFFDT                Effective Date
EFFSEQ               Effective Sequence
EMAIL_ADDR           Email Address
EMPLID               EmplID
EMPL_CLASS           Employee Classification
EMPL_RCD             Empl Rcd Nbr
EMPL_STATUS          Employee Status
EMPL_TYPE            Employee Type
ETHNIC_GRP_CD        Ethnic Group
EXPECTED_RETURN_DT   Expected Return Date
FACULTY_RANK_CU      Clemson Faculty Rank
FACULTY_RANK_DT_CU   Clemson Faculty Rank Date
FICA_STATUS_EE       FICA Status - Employee
FLSA_STATUS          FLSA Status
FORMER_NAME          Former Name
FTE                  FTE
FULL_PART_TIME       Full/Part Time
GRADE                Salary Grade
GRADE_ENTRY_DT       Grade Entry Date
HIGHEST_EDUC_LVL     Highest Education Level
HIRE_DT              Hire Date
HOME_PHONE           Home Phone #
HOURLY_RT            Hourly Rate
IPEDSSCODE           IPEDS - S Job Category
JOBCODE              Job Code
JOBTITLE             Job Title
JOBTITLE_ABBRV       Short Name
JOB_ENTRY_DT         Job Entry Date
JOB_FAMILY           Job Family
LAST_DATE_WORKED     Last Date Worked
LAST_INCREASE_DT     Date Last Increase
LOCATION             Location Code
LONGEVITY_NBR_CU     Longevity #
LONGEVITY_YEAR_CU    Longevity Year
MAR_STATUS           Marital Status
MONTHLY_RT           Monthly Rate
NAME                 Name
NAME_PREFIX          Name Prefix
NATIONAL_ID          National ID
NATIONAL_ID_TYPE    National ID Type
NID_COUNTRY         National ID Country
ORIG_HIRE_DT        Original Hire Date
PAYGROUP            Pay Group
POSITION_ENTRY_DT   Position Entry Date
POSITION_NBR        Position Number
POSTAL              Postal Code
PROBATION_DT        Probation Date
RATING_MODEL        Rating Model
REG_TEMP            Regular/Temporary
REHIRE_DT           Rehire Date
REPORTS_TO          Reports To Position Number
REVIEW_DT           Review Date
REVIEW_DT_NEXT_CU   Next Review Date
REVIEW_RATING       Review Rating
SAL_ADMIN_PLAN      Salary Administration Plan
SERVICE_DT          Service Date
SEX                 Gender
SHIFT               Regular Shift
STATE               State
STD_HOURS           Standard Hours
SUPERVISOR_ID       Supervisor ID
SUPERVISOR_NAME     Supervisor Name
TENURE_DATE_CU      Clemson Tenure date
TENURE_MAX_DTE_CU   Penultimate date
TENURE_STATUS_CU    Clemson Tenure Status
TERMINATION_DT      Termination Date
UNION_CD            # Months
WORK_PHONE          Work Phone #
Return to Record List
     CU_EMPLOYEES - Personnel Data - Current Date

Field                   Description
ACTION                   Action
ACTION_DT                Action Date
ACTION_REASON            Reason Code
ADDRESS1                 Address Line 1
ADDRESS2                 Address Line 2
ADDRESS3                 Address Line 3
ADDRESS4                 Address Line 4
ADDR_FIELD1              Address Field 1
ADDR_FIELD2              Address Field 2
ADDR_FIELD3              Address Field 3
ANNL_BENEF_BASE_RT       Annual Benefits Base Rate
ANNUAL_RT                Annual Rate
BENEFIT_RCD_NBR          Benefit Record Number
BIRTHDATE                Date of Birth
BUD_CTR_CU               Budget Center
BUSINESS_TITLE           Business Title
BUSINESS_UNIT            Business Unit
CHANGE_AMT               Change Amount
CHANGE_PCT               Change Percent
CITIZENSHIP_STATUS       Citizenship Status
CITY                     City
CLASS_INDC               Classified/Unclassified Indc
CMPNY_SENIORITY_DT       Company Seniority Date
COMPANY                  Company
COMPRATE                 Compensation Rate
COMP_FREQUENCY           Compensation Frequency
COUNTRY                  Country
COUNTY                   County
COUNTY_WORK_CU           County Work
CU_BUSN_ADDR1            Business Address Line 1
CU_BUSN_ADDR2            Business Address Line 2
CU_BUSN_ADDR3            Business Address Line 3
CU_BUSN_CITY             Business City
CU_BUSN_COUNTY           Business County
CU_BUSN_POSTAL           Business Postal Code
CU_BUSN_STATE            Business State
CU_STUDENT_ID            Clemson Student ID
DDDH_FLG_CU              Deans, Dir, Dept Heads Flag
DEPTID                   Department
DEPTNAME                 Department
DEPTNAME_ABBRV           Short Name
DEPT_ENTRY_DT            Department Entry Date
DIRECTLY_TIPPED          Tipped
DT_OF_DEATH          Date of Death
EEO1CODE             EEO - 1 Job Category
EEO4CODE             EEO - 4 Job Category
EEO4_FUNCTION        U.S. EEO4 Function
EEO5CODE             EEO - 5 Job Category
EEO6CODE             EEO - 6 Job Category
EEO_CLASS            EEO Classification
EEO_JOB_GROUP        EEO Job Group
EFFDT                Effective Date
EFFSEQ               Effective Sequence
EMAIL_ADDR           Email Address
EMPLID               EmplID
EMPL_CLASS           Employee Classification
EMPL_RCD             Empl Rcd Nbr
EMPL_STATUS          Employee Status
EMPL_TYPE            Employee Type
ETHNIC_GRP_CD        Ethnic Group
EXPECTED_RETURN_DT   Expected Return Date
FACULTY_RANK_CU      Clemson Faculty Rank
FACULTY_RANK_DT_CU   Clemson Faculty Rank Date
FICA_STATUS_EE       FICA Status - Employee
FLSA_STATUS          FLSA Status
FORMER_NAME          Former Name
FTE                  FTE
FULL_PART_TIME       Full/Part Time
GRADE                Salary Grade
GRADE_ENTRY_DT       Grade Entry Date
HIGHEST_EDUC_LVL     Highest Education Level
HIRE_DT              Hire Date
HOME_PHONE           Home Phone #
HOURLY_RT            Hourly Rate
IPEDSSCODE           IPEDS - S Job Category
JOBCODE              Job Code
JOBTITLE             Job Title
JOBTITLE_ABBRV       Short Name
JOB_ENTRY_DT         Job Entry Date
JOB_FAMILY           Job Family
LAST_DATE_WORKED     Last Date Worked
LAST_INCREASE_DT     Date Last Increase
LOCATION             Location Code
LONGEVITY_NBR_CU     Longevity #
LONGEVITY_YEAR_CU    Longevity Year
MAR_STATUS           Marital Status
MONTHLY_RT           Monthly Rate
NAME                 Name
NAME_PREFIX          Name Prefix
NATIONAL_ID          National ID
NATIONAL_ID_TYPE    National ID Type
NID_COUNTRY         National ID Country
ORIG_HIRE_DT        Original Hire Date
PAYGROUP            Pay Group
POSITION_ENTRY_DT   Position Entry Date
POSITION_NBR        Position Number
POSTAL              Postal Code
PROBATION_DT        Probation Date
RATING_MODEL        Rating Model
REG_TEMP            Regular/Temporary
REHIRE_DT           Rehire Date
REPORTS_TO          Reports To Position Number
REVIEW_DT           Review Date
REVIEW_DT_NEXT_CU   Next Review Date
REVIEW_RATING       Review Rating
SAL_ADMIN_PLAN      Salary Administration Plan
SERVICE_DT          Service Date
SEX                 Gender
SHIFT               Regular Shift
STATE               State
STD_HOURS           Standard Hours
SUPERVISOR_ID       Supervisor ID
SUPERVISOR_NAME     Supervisor Name
TENURE_DATE_CU      Clemson Tenure date
TENURE_MAX_DTE_CU   Penultimate date
TENURE_STATUS_CU    Clemson Tenure Status
TERMINATION_DT      Termination Date
UNION_CD            # Months
WORK_PHONE          Work Phone #
Return to Record List
   CU_EMPVERIFY_VW - CU_EMP_VERIFY_VW

Field             Description
DEPTID            Department
DEPTNAME          Department
EMPLID            EmplID
EMPL_CLASS        Employee Classification
EMPL_RCD          Empl Rcd Nbr
NAME              Name
STD_HOURS         Standard Hours
Return to Record List
  CU_FURLOUGH_B - CU Furlough Plan B

Field               Description
BUD_CTR_CU          Budget Center
DEPTID              Department
EMPLID              EmplID
Return to Record List
                 CU_GRAD_DIFF - CU_GRAD_DIFF

Field                            Description
AMOUNT_DUE                       Amount Due
APPROVAL_STATUS                  Approval Status
CLASS_FLD                        Class Field
CU_GRAD_DEGREE                   Graduate Degree Program
CU_STUDENT_ID                    Clemson Student ID
DEPTID                           Department
EARNS_DIST_TYPE                  Earnings Distribution Type
EMPLID                           EmplID
EMPL_CLASS                       Employee Classification
EMPL_RCD                         Empl Rcd Nbr
GAD_SOURCE                       GAD Source
LASTUPDDTTM                      Last Update Date/Time
LASTUPDOPRID                     by
MAJOR_CODE                       Major Code
PAID_FLAG                        Paid Flag
SETID                            SetID
STATUS_DT                        Status Date
Return to Record List
          CU_GRAD_DIST - CU_GRAD_DIST

Field               Description
ACCOUNT             Account
AMT                 Dollar Amount
CLASS_FLD           Class Field
CU_STUDENT_ID       Clemson Student ID
DEPTID2             DEPTID
DIST_PCT            Percent of Distribution
EARNS_DIST_TYPE     Earnings Distribution Type
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
FUND_CODE           Fund Code
PROGRAM_CODE        Program Code
PROJECT_ID          Project/Grant
SETID               SetID
STATUS_DT           Status Date
Return to Record List
    CU_GRAD_SRCH - CU Grad Diff - Dept Security

Field                Description
APPROVAL_STATUS       Approval Status
CU_STUDENT_ID         Clemson Student ID
DEPTID                Department
EMPLID                EmplID
EMPL_RCD              Empl Rcd Nbr
GAD_SOURCE            GAD Source
LAST_NAME_SRCH        Last Name
MAJOR_CODE            Major Code
NAME                  Name
STATUS_DT             Status Date
Return to Record List
   CU_LEAVE_COMHIS - EE Absence Details

Field                Description
ABSENCE_TYPE         Absence Type
BEGIN_DT             Begin Date
COMMENTS             Comment
COMMENT_DT           Comment Date
EMPLID               EmplID
EMPL_RCD             Empl Rcd Nbr
SEQ_NUM              Sequence
YEAR_4_CU            4 digit year
Return to Record List
          CU_LEAVE_DTLHIS - old Absence details

Field                   Description
ABSENCE_TYPE            Absence Type
ABS_APPROVED_DT         Date Approved
ABS_RECURRENCE          Absence Recurrence
ACCRUED_TAKEN_CU        Accrued or Taken
BEGIN_DT                Begin Date
BIRTH_DT                Actual Birth Date
COMMENTS                Comment
COUNSELLING             Counselling
DATE_ENTERED_CU         Date Entered
DATE_POSTED_CU          Date Posted
DISCIPLINARY            Disciplinary
DOC_CONSULTED           Doctor Consulted
DOC_CONSULT_DT          Consultation Date
DUE_DT                  Expected Birth Date
DURATION_DAYS           Duration (Days)
DURATION_HOURS          Duration (Hours)
DURATION_HOURS_CU       Duration (Hours)
EMPLID                  EmplID
EMPLOYER_APPROVED       Employer
EMPL_RCD                Empl Rcd Nbr
FLAG_POSTED_CU          Flag Posted
FLAG_VOID_CU            Flag Void CU
INCIDENT_NBR            Incident Number
INDUSTRIAL_INJURY       Work Injury Related
NOTIFIED_BY             Notified of Absence By Whom
NOTIFIED_DT             Date First Notified
NOTIFIED_TM             Time First Notified
PAID_UNPAID             Paid/Unpaid
REASON                  Reason
REFER_TO_OHA            Refer to Occ. Health Auth.
RETURN_DT               Return Date
SEQ_NUM                 Sequence
YEAR_4_CU               4 digit year
Return to Record List
        CU_LEAVE_TOTHIS - Leave Accruals history


ACCRUAL_PROC_DT          Accrual Process Date
COMPANY                  Company
EMPLID                   EmplID
EMPL_RCD                 Empl Rcd Nbr
HRS_ADJUST_UNPROC        Hours Adjusted Unprocessed
HRS_ADJUST_YTD           Hours Adjusted Year
HRS_BOUGHT_UNPROC        Hours Bought Unprocessed
HRS_BOUGHT_YTD           Hours Bought Year
HRS_CARRYOVER            Hours Carried Over
HRS_EARNED_YTD           Hours Earned Year
HRS_SOLD_UNPROC          Hours Sold Unprocessed
HRS_SOLD_YTD             Hours Sold Year
HRS_TAKEN_UNPROC         Hours Taken Unprocessed
HRS_TAKEN_YTD            Hours Taken Year
PLAN_TYPE                Plan Type
SERVICE_HRS              Hours of Service
SERVICE_HRS_UNPROC       Service Hours Unprocessed
YEAR_4_CU                4 digit year
Return to Record List
   CU_PAY_INFO_VW - CU Pay Check# VW for Query

Field               Description
CHECK_DT            Paycheck Issue Date
DEPTID              Department
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
LOCATION            Location Code
NAME                Name
PAYCHECK_NBR        Paycheck Number
Return to Record List
  CU_PAY_SHEET_VW - CU Pay Sheet View for Query

Field               Description
CHECK_DT             Paycheck Issue Date
DEPTID               Department
EMPLID               EmplID
EMPL_RCD             Empl Rcd Nbr
ERNCD                Earnings Code
LOCATION             Location Code
NAME                 Name
OTH_EARNS            Other Earnings
OTH_HRS              Other Hours
OTH_PAY              Other Pay
PAYCHECK_NBR         Paycheck Number
PAYGROUP             Pay Group
Return to Record List
             CU_PAYSHEET_ACC

Field               Description
ACCT_CD             Account Code
CHECK_DT            Paycheck Issue Date
DEPTID              Department
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
ERNCD               Earnings Code
LOCATION            Location Code
NAME                Name
OTH_EARNS           Other Earnings
OTH_HRS             Other Hours
OTH_PAY             Other Pay
PAYCHECK_NBR        Paycheck Number
PAYGROUP            Pay Group
Return to Record List
              CU_PAYSHEET_DE

Field               Description
ACCT_CD              Account Code
CHECK_DT             Paycheck Issue Date
DEPTID               Department
EMPLID               EmplID
EMPL_RCD             Empl Rcd Nbr
ERNCD                Earnings Code
NAME                 Name
OTH_EARNS            Other Earnings
OTH_HRS              Other Hours
OTH_PAY              Other Pay
PAYGROUP             Pay Group
RUN_ID               Pay Run ID
Return to Record List
              CU_PAYSHEET_VW

Field               Description
ACCT_CD             Account Code
CHECK_DEPT_CU       Check Dept
CHECK_DT            Paycheck Issue Date
DEPTID              Department
EMPLID              EmplID
EMPL_RCD            Empl Rcd Nbr
ERNCD               Earnings Code
LOCATION            Location Code
NAME                Name
OTH_EARNS           Other Earnings
OTH_HRS             Other Hours
OTH_PAY             Other Pay
PAYCHECK_NBR        Paycheck Number
PAYGROUP            Pay Group
Return to Record List
    CU_POSITION_SC - State position information

Field                   Description
CENSUS_CODE_STATE       State Census Code
COUNTY                  County
EEO6CODE                EEO
EEO_JOB_GROUP           EEO Job Group
FC_OLD_CU               Clemson FC old
GRADE_OLD_CU            Clemson Grade Old
JOBCODE                 Job Code
JOB_CODE_OLD_CU         Clemson's Old JobCode
POSITION_NBR            Position Number
POSITION_NBR_STATE      SC State Positon Number
SLOT_STATE              State Slot
Return to Record List
  CU_POSN_POOL_ID - Manager Info & Position Pool

Field                 Description
CLASS_INDC            Classified/Unclassified Indc
DEPTID                Department
EMPLID                EmplID
EMPL_CLASS            Employee Classification
EMPL_RCD              Empl Rcd Nbr
MANAGER_NAME          Manager Name
NAME                  Name
POSITION_NBR          Position Number
POSITION_POOL_ID      Position Pool ID
REPORTS_TO            Reports To Position Number
REVIEW_DT             Review Date
REVIEW_DT_NEXT_CU     Next Review Date
REVIEW_RATING         Review Rating
Return to Record List
         CU_RECUR_PAY_VW - CU_RECUR_PAY_VW

Field             Description
ACCT_CD            Account Code
ADDL_SEQ           Additional Pay Sequence Number
EARNINGS_END_DT    Earnings End Date
EFFDT              Effective Date
EMPLID             EmplID
EMPL_RCD           Empl Rcd Nbr
ERNCD              Earnings Code
GOAL_AMT           Goal Amount
GOAL_BAL           Current Goal Balance
HOURLY_RT          Hourly Rate
OK_TO_PAY          OK to Pay
OTH_HRS            Other Hours
OTH_PAY            Other Pay
Return to Record List
        CU_SPE_PAY_DIST - CU_SPECIAL_PAY

Field               Description
ACCOUNT              Account
AMT                  Dollar Amount
CLASS_FLD            Class Field
CU_SPEC_PAY_TYPE     Special Pay Type
CU_STUDENT_ID        Clemson Student ID
DATE_DUE             Date Due
DEPTID               Department
DEPTID2              DEPTID
EARNS_DIST_TYPE      Earnings Distribution Type
EMPLID               EmplID
EMPL_RCD             Empl Rcd Nbr
ERNCD                Earnings Code
FUND_CODE            Fund Code
PAYGROUP             Pay Group
POSITION_NBR         Position Number
PROGRAM_CODE         Program Code
PROJECT_ID           Project/Grant
SETID                SetID
Return to Record List
         CU_SPECIAL_PAY - CU_SPECIAL_PAY

Field                 Description
AMOUNT_DUE            Amount Due
BEGIN_DT              Begin Date
CITIZENSHIP_STATUS    Citizenship Status
COMMENTS              Comment
CU_SPEC_PAY_TYPE      Special Pay Type
CU_STUDENT_ID         Clemson Student ID
DATE_DUE              Date Due
DEPTID                Department
EARNS_DIST_TYPE       Earnings Distribution Type
EMPLID                EmplID
EMPL_CLASS            Employee Classification
EMPL_RCD              Empl Rcd Nbr
END_DATE              End Date
ENTERED_BY            Entered by
ENTERED_DT            Entered on
ERNCD                 Earnings Code
HOURLY_BASE_RT_CU     Clemson hourly Base Rate
HOURLY_RT             Hourly Rate
HRS_TO_PAY            Hours to Pay
LAST_DATE_WORKED      Last Date Worked
PAID_FLAG             Paid Flag
PAYGROUP              Pay Group
POSITION_NBR          Position Number
Return to Record List
                DEPT_TBL - Departments

Field                 Description
ACCIDENT_INS           Accident Insurance
ACCOUNTING_OWNER       Accounting Owner
APS_AGENT_CD_AUS       Agency Code
BUDGET_DEPTID          Budget with Department
BUDGET_LVL             Budget Level
BUDGET_YR_END_DT       Budget Year End Date
CAN_IND_SECTOR         Canadian Industrial Sector
CLASS_UNIT_NZL         Classification Unit
COMPANY                Company
COUNTRY_GRP            Country Group
DEPTID                 Department
DEPT_TENURE_FLG        Can Grant Tenure
DESCR                  Description
DESCRSHORT             Short Description
EEO4_FUNCTION          U.S. EEO4 Function
EFFDT                  Effective Date
EFF_STATUS             Status as of Effective Date
ESTABID                Establishment ID
FTE_EDIT_INDC          FTE Edit Indicator
GL_EXPENSE             GL Account # - Expense
GVT_DESCR40            Description
GVT_PAR_DESCR2         PAR Line 2 Description
GVT_PAR_DESCR3         PAR Line 3 Description
GVT_PAR_DESCR4         PAR Line 4 Description
GVT_PAR_DESCR5         PAR Line 5 Description
GVT_PAR_LINE2          PAR Line 2 Department ID
GVT_PAR_LINE3          PAR Line 3 Department ID
GVT_PAR_LINE4          PAR Line 4 Department ID
GVT_PAR_LINE5          PAR Line 5 Department ID
GVT_SUB_AGENCY         Sub - Agency
HAZARD                 Hazard
HP_STATS_DEPT_CD       Stats - Can Dept Code
HP_STATS_FACULTY       Stats - Can Faculty Code
IND_COMMITTEE_BEL      Industrial Committee
LOCATION               Location Code
MANAGER_ID             Manager ID
MANAGER_NAME           Manager Name
MANAGER_POSN           Manager Position
NACE_CD_BEL            NACE Code
ORG_UNIT_AUS           Organizational Unit
RISKCD                 Risk Code
SETID                  SetID
SETID_LOCATION         Location SetID
SI_ACCIDENT_NUM    Social Insurance Accident #
TAX_LOCATION_CD    Tax Location Code
TL_DISTRIB_INFO    Use TL Distribution
USE_BUDGETS        Use Comm. Acctg. / Budgeting
USE_DISTRIBUTION   Use Actuals Distribution
USE_ENCUMBRANCES   Use Encumbrance Processing
WORK_SECTOR_AUS    Work Sector
Return to Record List
  EMAIL_ADDRESSES - Email Addresses

Field               Description
EMAIL_ADDR           Email Address
EMPLID               EmplID
E_ADDR_TYPE          Email Type
PREF_EMAIL_FLAG      Preferr
Return to Record List
       EMERGENCY_CNTCT - EE Emergency Contacts

Field                 Description
ADDRESS1              Address Line 1
ADDRESS2              Address Line 2
ADDRESS3              Address Line 3
ADDRESS4              Address Line 4
ADDRESS_TYPE          Address Type
ADDR_FIELD1           Address Field 1
ADDR_FIELD2           Address Field 2
ADDR_FIELD3           Address Field 3
CITY                  City
CONTACT_NAME          Contact Name
COUNTRY               Country
COUNTRY_CODE          Country Code
COUNTY                County
EMPLID                EmplID
EXTENSION             Phone Extension
GEO_CODE              Tax Vendor Geographical Code
HOUSE_TYPE            House Type
IN_CITY_LIMIT         In City Limit
NUM1                  Number 1
NUM2                  Number 2
PHONE                 Telephone
PHONE_TYPE            Phone Type
POSTAL                Postal Code
PRIMARY_CONTACT       Primary Contact
RELATIONSHIP          Relationship to Employee
SAME_ADDRESS_EMPL     Same Address as Employee
SAME_PHONE_EMPL       Same Phone as Employee
STATE                 State
Return to Record List
         EMPLOYMENT - EE General Employment Data

Field                   Description
BENEFIT_RCD_NBR         Benefit Record Number
BUSINESS_TITLE          Business Title
CMPNY_SENIORITY_DT      Company Seniority Date
EMPLID                  EmplID
EMPL_RCD                Empl Rcd Nbr
EXPECTED_RETURN_DT      Expected Return Date
HIRE_DT                 Hire Date
HOME_HOST_CLASS         Home/Host Classification
LAST_DATE_WORKED        Last Date Worked
LAST_INCREASE_DT        Date Last Increase
LAST_VERIFICATN_DT      Last Verification Date
NEE_PROVIDER_ID         Provider ID
OWN_5PERCENT_CO         Owns 5% (or More) of Company
PER_ORG                 Organizational Relationship
POSITION_PHONE          Position Phone
PROBATION_DT            Probation Date
PROF_EXPERIENCE_DT      Professional Experience Date
REHIRE_DT               Rehire Date
REPORTS_TO              Reports To Position Number
SENIORITY_PAY_DT        Seniority Pay Calc Date
SERVICE_DT              Service Date
SUPERVISOR_ID           Supervisor ID
TERMINATION_DT          Termination Date
Return to Record List
                        JOB - EE Job History

Field                        Description
ABSENCE_SYSTEM_CD             Absence System
ACCDNT_CD_FRA                 Work Accident Type Code
ACCT_CD                       Account Code
ACTION                        Action
ACTION_DT                     Action Date
ACTION_REASON                 Reason Code
ADDS_TO_FTE_ACTUAL            Adds to FTE Actual Count
ANNL_BENEF_BASE_RT            Annual Benefits Base Rate
ANNUAL_RT                     Annual Rate
APPT_TYPE                     Appointment Type
ASGN_END_DT                   Assignment End Date
ASGN_START_DT                 First Assignment Start
AUTO_END_FLG                  End Job Automatically
BARG_UNIT                     Bargaining Unit
BAS_ACTION                    Benefits Administration Action
BAS_GROUP_ID                  BAS Group ID
BENEFIT_SYSTEM                Benefits System
BEN_STATUS                    Benefits Employee Status
BORDER_WALKER                 Cross Border Worker
BUSINESS_UNIT                 Business Unit
CHANGE_AMT                    Change Amount
CHANGE_PCT                    Change Percent
CLASS_INDC                    Classified/Unclassified Indc
COBRA_ACTION                  COBRA Action
COMPANY                       Company
COMPRATE                      Compensation Rate
COMP_FREQUENCY                Compensation Frequency
CONTRACT_NUM                  Contract Number
CTG_RATE                      Category Rate
CURRENCY_CD                   Currency Code
CURRENCY_CD1                  Currency Code
CUR_RT_TYPE                   Exchange Rate Type
DAILY_RT                      Daily Rate
DDDH_FLG_CU                   Deans, Dir, Dept Heads Flag
DEPTID                        Department
DEPT_ENTRY_DT                 Department Entry Date
DIRECTLY_TIPPED               Tipped
EARNS_DIST_TYPE               Earnings Distribution Type
EEO_CLASS                     EEO Classification
EFFDT                         Effective Date
EFFSEQ                        Effective Sequence
ELIG_CONFIG1                  Eligibility Config Field 1
ELIG_CONFIG2                  Eligibility Config Field 2
ELIG_CONFIG3         Eligibility Config Field 3
ELIG_CONFIG4         Eligibility Config Field 4
ELIG_CONFIG5         Eligibility Config Field 5
ELIG_CONFIG6         Eligibility Config Field 6
ELIG_CONFIG7         Eligibility Config Field 7
ELIG_CONFIG8         Eligibility Config Field 8
ELIG_CONFIG9         Eligibility Config Field 9
EMPLID               EmplID
EMPL_CLASS           Employee Classification
EMPL_CTG             Employee Category
EMPL_CTG_L1          Employee Subcategory
EMPL_CTG_L2          Employee Subcategory 2
EMPL_RCD             Empl Rcd Nbr
EMPL_STATUS          Employee Status
EMPL_TYPE            Employee Type
ENCUMB_OVERRIDE      Encumbrance Override
ENTRY_DATE           Date Entered
ESTABID              Establishment ID
EXEMPT_HOURS_MONTH   Exempted Hours per Month
EXEMPT_JOB_LBR       Exempted
EXPECTED_END_DATE    Expected Job End Date
EXPECTED_RETURN_DT   Expected Return Date
FACULTY_RANK_CU      Clemson Faculty Rank
FACULTY_RANK_DT_CU   Clemson Faculty Rank Date
FICA_STATUS_EE       FICA Status - Employee
FLSA_STATUS          FLSA Status
FORCE_PUBLISH        Force Publish
FTE                  FTE
FULL_PART_TIME       Full/Part Time
FUNCTION_CD          Function Code
GL_PAY_TYPE          General Ledger Pay Type
GP_ASOF_DT_EXG_RT    Use Rate As Of
GP_DFLT_CURRTTYP     Use Pay Group Rate Type
GP_DFLT_ELIG_GRP     Use Pay Group Eligibility
GP_DFLT_EXRTDT       Use Pay Group As Of Date
GP_ELIG_GRP          Eligibility Group
GP_PAYGROUP          Pay Group
GRADE                Salary Grade
GRADE_ENTRY_DT       Grade Entry Date
HIRE_DT              Hire Date
HOLIDAY_SCHEDULE     Holiday Schedule
HOURLY_RT            Hourly Rate
HOURLY_RT_FRA        Hours Type
HR_STATUS            HR Status
INTERCTR_WRKS_CNCL   InterCtr.Works Cnil Function
JOBCODE              Job Code
JOB_DATA_SRC_CD      Job Source Code
JOB_ENTRY_DT         Job Entry Date
JOB_INDICATOR        Job Indicator
LABOR_AGREEMENT      Labor Agreement
LABOR_FACILITY_ID    Labor Facility ID
LABOR_TYPE_GER       Labor Type
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
LAST_DATE_WORKED     Last Date Worked
LAST_HIRE_DT         Last Start Date
LAYOFF_EXEMPT_FLAG   Exempt from Layoff
LAYOFF_EXEMPT_RSN    Layoff Exemption Reason
LBR_FAC_ENTRY_DT     Labor Facility Entry Date
LDW_OVR              Override Last Date Worked
LOCATION             Location Code
LONGEVITY_NBR_CU     Longevity #
LONGEVITY_YEAR_CU    Longevity Year
LST_ASGN_START_DT    Last Assignment Start Date
LUMP_SUM_PAY         Lump Sum Retro Payment
MAIN_APPT_NUM_JPN    Main Appointment Number
MATRICULA_NBR        Matricula Number
MONTHLY_RT           Monthly Rate
OFFICER_CD           Officer Code
PAID_FTE             Paid FTE
PAID_HOURS           Paid Hours
PAID_HRS_FREQUENCY   Paid Work Period
PAYGROUP             Pay Group
PAY_SYSTEM_FLG       Payroll System
PAY_UNION_FEE        Pay Union Fee
PERFORM_GROUP_GER    Performance Group
PER_ORG              Organizational Relationship
POI_TYPE             Person of Interest Type
POSITION_ENTRY_DT    Position Entry Date
POSITION_NBR         Position Number
POSITION_OVERRIDE    Override Position Data
POSN_CHANGE_RECORD   Position Management Record
PRORATE_CNT_AMT      Prorate Contract Change Amount
RATING_MODEL         Rating Model
REG_REGION           Regulatory Region
REG_TEMP             Regular/Temporary
REPORTS_TO           Reports To Position Number
REVIEW_DT            Review Date
REVIEW_DT_NEXT_CU    Next Review Date
REVIEW_RATING        Review Rating
SAL_ADMIN_PLAN       Salary Administration Plan
SETID_DEPT           Department SetID
SETID_EMPL_CLASS      EMPL_CLASS SetID
SETID_JOBCODE        Job Code SetID
SETID_LBR_AGRMNT     Labor Agreement SetID
SETID_LOCATION       Location SetID
SETID_SALARY         Salary SetID
SETID_SUPV_LVL       Supervisor Level Setid
SHIFT                Regular Shift
SHIFT_FACTOR         Shift Differential Factor
SHIFT_RT             Shift Differential Rate
SOC_SEC_RISK_CODE    Social Security Risk Code
SPK_COMM_ID_GER      Spokesmen Committee ID
STD_HOURS            Standard Hours
STD_HRS_FREQUENCY    Standard Work Period
STEP                 Step
STEP_ENTRY_DT        Step Entry Date
SUPERVISOR_ID        Supervisor ID
SUPV_LVL_ID          Supervisor Level
TARIFF_AREA_GER      Tariff Area
TARIFF_GER           Tariff
TAX_LOCATION_CD      Tax Location Code
TENURE_DATE_CU       Clemson Tenure date
TENURE_MAX_DTE_CU    Penultimate date
TENURE_STATUS_CU     Clemson Tenure Status
TERMINATION_DT       Termination Date
UNION_CD             # Months
UNION_FEE_AMOUNT     Union Fee Amount
UNION_FEE_END_DT     Union Fee End Date
UNION_FEE_START_DT   Union Fee Start Date
UNION_FULL_PART      Union Participation
UNION_POS            Union Position
UNION_SENIORITY_DT   Union Seniority Date
VALUE_1_FRA          Value 1
VALUE_2_FRA          Value 2
VALUE_3_FRA          Value 3
VALUE_4_FRA          Value 4
VALUE_5_FRA          Value 5
WORK_DAY_HOURS       Number of Hours in a Work Day
WPP_STOP_FLAG        Stop Wage Progression
WRKS_CNCL_FUNCTION   Works Council Function
WRKS_CNCL_ROLE_CHE   Work Council Role
Return to Record List
  JOB_EARNS_DIST - EE Job Earnings Distribution

Field                 Description
ACCT_CD                Account Code
BUSINESS_UNIT          Business Unit
COMPRATE               Compensation Rate
DEPTID                 Department
DIST_PCT               Percent of Distribution
EFFDT                  Effective Date
EFFSEQ                 Effective Sequence
EMPLID                 EmplID
EMPL_RCD               Empl Rcd Nbr
ERNCD                  Earnings Code
GL_PAY_TYPE            General Ledger Pay Type
JOBCODE                Job Code
LOCATION               Location Code
POSITION_NBR           Position Number
SHIFT                  Regular Shift
STD_HOURS              Standard Hours
Return to Record List
                  JOBCODE_TBL - Job Codes

Field                    Description
ACTIVITY_TYPE_FRA        Activity Type
ANN_CNTACT_HRS_AUS       Annual Contact Hours
ASCO_CD_AUS              ASCO Code
AVAIL_TELEWORK           Available for Telework
BARG_UNIT                Bargaining Unit
BA_CD                    BA Code
BPS_ACTIVITY_CD          BPS Activity
CAN_NOC_CD               National Occupational Classif
CAN_PAYEQ_JOB_CLS        Canadian Pay Equity Job Class
CASUAL_TYPE_AUS          Type of Work Performed
COMPANY                  Company
COMP_FREQUENCY           Compensation Frequency
CURRENCY_CD              Currency Code
DESCR                    Description
DESCRLONG                Description
DESCRSHORT               Short Description
DIRECTLY_TIPPED          Tipped
EEO1CODE                 EEO - 1 Job Category
EEO4CODE                 EEO - 4 Job Category
EEO5CODE                 EEO - 5 Job Category
EEO6CODE                 EEO - 6 Job Category
EEO_JOB_GROUP            EEO Job Group
EFFDT                    Effective Date
EFF_STATUS               Status as of Effective Date
EG_ACADEMIC_RANK         Academic Rank
EG_GROUP                 Service Calculation Group
ELECTION_GROUP           Election Group
EMP_CATEGRY_FRA          Employee Category
ENCUMBER_INDC            Encumbrance Indicator
ENCUMB_SAL_AMT           Encumber Salary Amount
ENCUMB_SAL_OPTN          Encumber Salary Option
FA_PAY_PROGRAM           Festive Advance Pay Program
FLSA_STATUS              FLSA Status
FP_ATCH_AREA             Attachment Sector
FP_AUTO_RATFY            Auto Hire Validation
FP_BUSINESS_CD           Occupation Code
FP_JOBCD_ACC             Match Competencies
FP_JOB_FMLY              CS Job Code
FP_JOB_TYP               Job Type
FP_MATRIX_CD             Salary Grade Table Code
FP_MATRIX_TYP            Salary Grade Table Type
FP_OFF_COLAG             Job Outside Coll Lbor Agrment
FP_PROF_CATG             Labor Agreement Category
FUNCTION_AUS         Job Function
FUNCTION_CD          Function Code
GRADE                Salary Grade
GVT_CLASSIFIER_ID    Classifier's ID
GVT_CLS_STANDARD     Classification Standard
GVT_DT_CLASSIFIED    Date Classified
GVT_EMP_FIN_INT      Employee Financial Interests
GVT_EXEC_FIN_DISCL   Executive Financial Disclosure
GVT_FUNC_CLASS       Functional Class
GVT_FUND_SOURCE      Fund Source
GVT_IA_ACTIONS       IA Actions
GVT_LEO_POSITION     LEO/Fire Position
GVT_NFC_FUNCTN_CD    NFC Function Code
GVT_NFC_PI_IND_OVR   Override NFC Indicator
GVT_OCC_SERIES       Occupational Series
GVT_OFFICIAL_DESCR   Official Position Title
GVT_OFF_TITLEPREFX   Official Title Prefix
GVT_OPM_CERT_NBR     OPM Certification Number
GVT_ORG_TTL_CD       Organization Posn Title Cd
GVT_ORG_TTL_DESCR    Organization Position Title
GVT_PAREN_TITLE      Parenthetical Title
GVT_PATCOB_CD        PATCOB Code
GVT_PAY_BASIS        Pay Basis
GVT_PAY_PLAN         Pay Plan
GVT_PERF_PLAN        Performance Plan
GVT_PI_UPD_IND       PI upd ind
GVT_POI              Personnel Office ID
GVT_POSN_CLASS_STD   Position Classification Stds
GVT_POSN_SENS_CD     Sensitivity Code
GVT_POSN_TITLE_CD    Official Posn Title Code
GVT_SUB_AGENCY       Sub - Agency
GVT_TARGET_GRADE     Target Grade
HP_STATS_DUTIES      Stats - Can Duties
HP_STATS_RPT_FLAG    Stats - Can Report Flag
INAIL_CODE           INAIL Code
INSEE_CD_FRA         INSEE Code
IPEDSSCODE           IPEDS - S Job Category
JOBCODE              Job Code
JOB_ACCNTAB_PCT      Accountability - Percent
JOB_ACCNTAB_POINTS   Accountability - Points
JOB_CTG_FRA_CD       Job Category Code
JOB_FAMILY           Job Family
JOB_FUNCTION         Job Function Code
JOB_KNOWHOW_PCT      Knowhow - Percent
JOB_KNOWHOW_POINTS   Knowhow - Points
JOB_POINTS_TOTAL     Total Points
JOB_PROBSLV_PCT      Problem - Solving - Percent
JOB_PROBSLV_POINTS   Problem - Solving - Points
JOB_SUB_FUNC         Job Subfunction
LABOR_AGREEMENT      Labor Agreement
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
LAST_UPDATE_DATE     Date of last update
MANAGER_LEVEL        Manager Level
MED_CHKUP_REQ        Medical Checkup Required
MED_SURV_REQ         Medical Surveillance Required
MILITARY_SERVICE     Military Service
MIL_RANK             Military Rank
PKG_RULE_ID          Package Rule ID
PKG_TEMPLATE_ID      Package Template ID
POSN_MGMT_INDC       Used by Position Management
REG_REGION           Regulatory Region
REG_TEMP             Regular/Temporary
RETRO_PERCENT        Retroactive Percent
RETRO_RATE           Retroactive Rate
SAL_ADMIN_PLAN       Salary Administration Plan
SAL_RANGE_CURRENCY   Salary Range Currency
SAL_RANGE_FREQ       Salary Range Frequency
SAL_RANGE_MAX_RATE   Salary Range Maximum Rate
SAL_RANGE_MID_RATE   Salary Range Midpoint Rate
SAL_RANGE_MIN_RATE   Salary Range Minimum Rate
SEASONAL             Seasonal
SETID                SetID
SETID_SALARY         Salary SetID
STD_HOURS            Standard Hours
STD_HRS_FREQUENCY    Standard Work Period
STEP                 Step
SURVEY_JOB_CODE      Salary Survey Job Code
SURVEY_SALARY        Survey Salary
TEACH_WEEKS_AUS      Total Weeks in Teaching Job
TECHNICAL            Technical
TRN_PROGRAM          Training Program
UK_SOC_CD            Standard Occupational Classif
UNION_CD             # Months
US_OCC_CD            Occupational Classif. Code
US_SOC_CD            Standard Occupational Classif
WORKERS_COMP_CD      Workers' Comp Code
WORK_DAY_HOURS       Number of Hours in a Work Day
Return to Record List
            LEAVE_ACCRUAL - EE Leave Accruals

Field                   Description
ACCRUAL_PROC_DT          Accrual Process Date
COMPANY                  Company
EMPLID                   EmplID
EMPL_RCD                 Empl Rcd Nbr
HRS_ADJUST_UNPROC        Hours Adjusted Unprocessed
HRS_ADJUST_YTD           Hours Adjusted Year - to - Date
HRS_BOUGHT_UNPROC        Hours Bought Unprocessed
HRS_BOUGHT_YTD           Hours Bought Year - to - Date
HRS_CARRYOVER            Hours Carried Over - Prev Year
HRS_EARNED_YTD           Hours Earned Year - to - Date
HRS_SOLD_UNPROC          Hours Sold Unprocessed
HRS_SOLD_YTD             Hours Sold Year - to - Date
HRS_TAKEN_UNPROC         Hours Taken Unprocessed
HRS_TAKEN_YTD            Hours Taken Year - to - Date
PLAN_TYPE                Plan Type
SERVICE_HRS              Hours of Service
SERVICE_HRS_UNPROC       Service Hours Unprocessed
Return to Record List
    LEAVE_PLAN - EE Leave Benefit Enrollments

Field                  Description
BENEFIT_NBR            (Not Implemented!)
BENEFIT_PLAN           Benefit Plan
COVERAGE_ELECT         Coverage Election
COVERAGE_ELECT_DT      Coverage Elect Date
DEDUCTION_END_DT       Deduction End Date
EFFDT                  Effective Date
EMPLID                 EmplID
EMPL_RCD               Empl Rcd Nbr
GVT_GFATH_CYOVER       Grandfathered Carryover
PLAN_TYPE              Plan Type
Return to Record List
          LOCATION_TBL - Company Site Locations

Field                 Description
ADDRESS1               Address Line 1
ADDRESS2               Address Line 2
ADDRESS3               Address Line 3
ADDRESS4               Address Line 4
ADDR_FIELD1            Address Field 1
ADDR_FIELD2            Address Field 2
ADDR_FIELD3            Address Field 3
ATTN_TO                Attention
BUILDING               Building #
CAN_CMA                Canadian Census Metropol Area
CAN_OEE_AREACD         CEC Management Area
CITY                   City
COMMENTS_2000          Comments Text
COUNTRY                Country
COUNTRY_CODE           Country Code
COUNTY                 County
DESCR                  Description
DESCRSHORT             Short Description
DESCR_AC               Alternate Char Description
EFFDT                  Effective Date
EFF_STATUS             Status as of Effective Date
ESTABID                Establishment ID
EXTENSION              Phone Extension
FAX                    Fax Number
FLOOR                  Floor #
FON_ER_ID_MEX          Fonacot ID Number
FON_OFFICE_MEX         FONACOT Office
GEOLOC_CODE            Geographical Location Code
GEO_CODE               Tax Vendor Geographical Code
GVT_DESIG_AGENT        Designated Agent Code
GVT_GEOLOC_CD          Geog Location Code
HOLIDAY_SCHEDULE       Holiday Schedule
HOUSE_TYPE             House Type
INDUST_INSP_ID_GER     Industrial Inspection ID
IN_CITY_LIMIT          In City Limit
JURISDICTION           Jurisdiction
LABEL_FORMAT_ID2       Carton Label Format ID
LABEL_FORMAT_ID3       Ship Container Label Format ID
LANG_CD                Language Code
LOCALITY               Locality
LOCATION               Location Code
LOC_TAX_MEX            Local Tax
LOC_TAX_SPCL_MEX       Special Local Tax
MATRICULA_NBR       Matricula Number
MESSAGE_TEXT2       Check Cashing Location
NCR_SW_CAN          National Capital Region
NI_REPORT_SW_UK     Northern Ireland report Locati
NUM1                Number 1
NUM2                Number 2
OFFICE_TYPE         Office Type
PHONE               Telephone
POSTAL              Postal Code
REG_REGION          Regulatory Region
SAL_ADMIN_PLAN      Salary Administration Plan
SECTOR              Sector
SETID               SetID
SETID_SALARY        Salary SetID
SPK_COMM_ID_GER     Spokesmen Committee ID
STATE               State
TARIFF_AREA_GER     Tariff Area
TARIFF_GER          Tariff
TBS_OFFICE_CD_CAN   Treassury Board Office Code
TELE_LOCATION       Telework Location
USG_LBL_FORMAT_ID    Item Usage Label Format
Return to Record List
    MAJOR_TBL - College Major Subject Codes

Field                Description
DESCR                 Description
DESCRSHORT            Short Description
GVT_DESCR70           Description
MAJOR_CODE            Major Code
Return to Record List
    NAME_CURR_VW - Current Name Vw all types

Field                 Description
ASOFDATE               As Of Date
COUNTRY_NM_FORMAT      Format Using
EMPLID                 EmplID
FIRST_NAME             First Name
FIRST_NAME_SRCH        First Name
LAST_NAME              Last Name
LAST_NAME_PREF_NLD     Last Name Preference
LAST_NAME_SRCH         Last Name
MIDDLE_NAME            Middle Name
NAME                   Name
NAME_AC                Alternate Character Name
NAME_DISPLAY           Display Name
NAME_FORMAL            Formal Name
NAME_INITIALS          Name Initials
NAME_PREFIX            Name Prefix
NAME_ROYAL_PREFIX      Name Royal Prefix
NAME_ROYAL_SUFFIX      Name Royal Suffix
NAME_SUFFIX            Name Suffix
NAME_TITLE             Title
NAME_TYPE              Type of Name
PARTNER_LAST_NAME      Last Name Partner
PARTNER_ROY_PREFIX     Prefix Partner
PREF_FIRST_NAME        Preferred First Name
SECOND_LAST_NAME       Second Last Name
SECOND_LAST_SRCH       Second Name
Return to Record List
               NAMES - Person Names

Field                  Description
COUNTRY_NM_FORMAT      Format Using
EFFDT                  Effective Date
EFF_STATUS             Status as of Effective Date
EMPLID                 EmplID
FIRST_NAME             First Name
FIRST_NAME_SRCH        First Name
LASTUPDDTTM            Last Update Date/Time
LASTUPDOPRID           by
LAST_NAME              Last Name
LAST_NAME_PREF_NLD     Last Name Preference
LAST_NAME_SRCH         Last Name
MIDDLE_NAME            Middle Name
NAME                   Name
NAME_AC                Alternate Character Name
NAME_DISPLAY           Display Name
NAME_DISPLAY_SRCH      Name
NAME_FORMAL            Formal Name
NAME_INITIALS          Name Initials
NAME_PREFIX            Name Prefix
NAME_ROYAL_PREFIX      Name Royal Prefix
NAME_ROYAL_SUFFIX      Name Royal Suffix
NAME_SUFFIX            Name Suffix
NAME_TITLE             Title
NAME_TYPE              Type of Name
PARTNER_LAST_NAME      Last Name Partner
PARTNER_ROY_PREFIX     Prefix Partner
PREF_FIRST_NAME        Preferred First Name
SECOND_LAST_NAME       Second Last Name
SECOND_LAST_SRCH       Second Name
Return to Record List
          PERS_NID - PERS_NID Record

Field                Description
COUNTRY              Country
EMPLID               EmplID
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
NATIONAL_ID          National ID
NATIONAL_ID_TYPE     National ID Type
PRIMARY_NID          Primary ID
SSN_KEY_FRA          Social Security # Key
TAX_REF_ID_SGP       Tax Ref
Return to Record List
                 PERSON - PERSON record

Field                 Description
BIRTHCOUNTRY          Birth Country
BIRTHDATE             Date of Birth
BIRTHPLACE            Birth Location
BIRTHSTATE            Birth State
CU_STUDENT_ID         Clemson Student ID
DT_OF_DEATH           Date of Death
EMPLID                EmplID
LAST_CHILD_UPDDTM     Last Update to Assignment Data
Return to Record List
     PERSON_NAME - Current Primary Name View

Field                 Description
ASOFDATE               As Of Date
COUNTRY_NM_FORMAT      Format Using
EMPLID                 EmplID
FIRST_NAME             First Name
FIRST_NAME_SRCH        First Name
LAST_NAME              Last Name
LAST_NAME_PREF_NLD     Last Name Preference
LAST_NAME_SRCH         Last Name
MIDDLE_NAME            Middle Name
NAME                   Name
NAME_AC                Alternate Character Name
NAME_DISPLAY           Display Name
NAME_DISPLAY_SRCH      Name
NAME_FORMAL            Formal Name
NAME_INITIALS          Name Initials
NAME_PREFIX            Name Prefix
NAME_PSFORMAT          Name (LN,FN)
NAME_ROYAL_PREFIX      Name Royal Prefix
NAME_ROYAL_SUFFIX      Name Royal Suffix
NAME_SUFFIX            Name Suffix
NAME_TITLE             Title
NAME_TYPE              Type of Name
PARTNER_LAST_NAME      Last Name Partner
PARTNER_ROY_PREFIX     Prefix Partner
PREF_FIRST_NAME        Preferred First Name
SECOND_LAST_NAME       Second Last Name
SECOND_LAST_SRCH       Second Name
Return to Record List
       PERSONAL_DATA - PERSONAL_DATA for Rpting

Field                  Description
ADDRESS1               Address Line 1
ADDRESS1_AC            Alternate Character Address
ADDRESS1_OTHER         Address Line 1
ADDRESS2               Address Line 2
ADDRESS2_AC            Alternate Character Address 2
ADDRESS2_OTHER         Address Line 2
ADDRESS3               Address Line 3
ADDRESS3_AC            Alternate Character Address 3
ADDRESS3_OTHER         Address Line 3
ADDRESS4               Address Line 4
ADDRESS4_OTHER         Address Line 4
ADDR_FIELD1            Address Field 1
ADDR_FIELD1_OTHER      Address Field 1
ADDR_FIELD2            Address Field 2
ADDR_FIELD2_OTHER      Address Field 2
ADDR_FIELD3            Address Field 3
ADDR_FIELD3_OTHER      Address Field 3
ALTER_EMPLID           Alternate Employee ID
BARG_UNIT              Bargaining Unit
BILINGUALISM_CODE      Bilingualism Code
BIRTHCOUNTRY           Birth Country
BIRTHDATE              Date of Birth
BIRTHPLACE             Birth Location
BIRTHSTATE             Birth State
CAMPUS_ID              Campus ID
CITIZEN_PROOF1         Citizenship (Proof 1)
CITIZEN_PROOF2         Citizenship (Proof 2)
CITY                   City
CITY_AC                Alternate Character City
CITY_OTHER             City - Other
COUNTRY                Country
COUNTRY_CODE           Country Code
COUNTRY_NM_FORMAT      Format Using
COUNTRY_OTHER          Country - Other
COUNTY                 County
COUNTY_OTHER           County - Other
CPAMID                 CPAM ID
DEATH_CERTIF_NBR       Death Certificate Nbr
DISABLED               Disabled
DISABLED_VET           Disabled Veteran
DT_OF_DEATH            Date of Death
EMPLID                 EmplID
ENTRY_DT_FRA           Date of First Entry in France
EXPCTD_MILITARY_DT   Expected Military Date
EXTENSION            Phone Extension
FERPA                FERPA
FIRST_NAME           First Name
FIRST_NAME_SRCH      First Name
FT_STUDENT           Full - Time Student
GEO_CODE             Tax Vendor Geographical Code
GEO_CODE_OTHER       Geo Code Other
GRADE                Salary Grade
GVT_CHANGE_FLAG      Change Flag
GVT_CRED_MIL_SVCE    Creditable Military Service
GVT_CURR_AGCY_EMPL   Current Agency Employee
GVT_CURR_FED_EMPL    Current Federal Employee
GVT_DISABILITY_CD    Disability Code
GVT_DRAFT_STATUS     Draft Status
GVT_HIGH_GRADE       Highest Grade
GVT_HIGH_PAY_PLAN    Highest Pay Plan
GVT_MILITARY_COMP    Uniformed Service
GVT_MIL_GRADE        Military Grade
GVT_MIL_RESRVE_CAT   Reserve Category
GVT_MIL_SEP_RET      Military Separation Status
GVT_MIL_SVCE_END     Military Separation Date
GVT_MIL_SVCE_START   Military Service Start Date
GVT_MIL_VERIFY       Military Service Verified
GVT_PAR_NBR_LAST     Last Personnel Action Reqst #
GVT_PAY_PLAN         Pay Plan
GVT_PREV_AGCY_EMPL   Previous Agency Employee
GVT_PREV_FED_EMPL    Previous Federal Employee
GVT_SEP_INCENTIVE    Separation Incentive
GVT_SEP_INCENT_DT    Separation Incentive Date
GVT_TENURE           Highest Career Tenure
GVT_UNIF_SVC_CTR     Notify Military Pay Center
GVT_VET_PREF_APPT    Veterans Preference
GVT_VET_PREF_RIF     Veterans Preference RIF
GVT_YR_ATTAINED      Year Attained
HEALTH_CARE_NBR      Health Care Number
HEALTH_CARE_STATE    Health Care Province
HIGHEST_EDUC_LVL     Highest Education Level
HONSEKI_JPN          Honseki Prefecture
HOUSE_TYPE           House Type
HOUSE_TYPE_OTHER     House Type Other
HR_RESPONSIBLE_ID    HR Responsible ID
IN_CITY_LIMIT        In City Limit
IN_CITY_LMT_OTHER    In City Limit Other
LANG_CD              Language Code
LASTUPDDTTM          Last Update Date/Time
LAST_NAME            Last Name
LAST_NAME_PREF_NLD   Last Name Preference
LAST_NAME_SRCH       Last Name
MAR_STATUS           Marital Status
MAR_STATUS_DT        Marital Status Date
MEDICARE_ENTLD_DT    Date Entitled to Medicare
MIDDLE_NAME          Middle Name
MILITARY_END_ITA     Military End Date
MILITARY_RANK_ITA    Function or Rank
MILITARY_STATUS      Military Status
MILITARY_STAT_GER    Military Status
MILITARY_STAT_ITA    Military Status Italy
MILITARY_TYPE_ITA    Type of Service
MILIT_SITUATN_ESP    Military Status
MILIT_SITUATN_FRA    Military Status
NAME                 Name
NAME_AC              Alternate Character Name
NAME_DISPLAY         Display Name
NAME_FORMAL          Formal Name
NAME_INITIALS        Name Initials
NAME_PREFIX          Name Prefix
NAME_ROYAL_PREFIX    Name Royal Prefix
NAME_ROYAL_SUFFIX    Name Royal Suffix
NAME_SUFFIX          Name Suffix
NAME_TITLE           Title
NUM1                 Number 1
NUM1_OTHER           Number 1 Other
NUM2                 Number 2
NUM2_OTHER           Number 2 Other
PARTNER_LAST_NAME    Last Name Partner
PARTNER_ROY_PREFIX   Prefix Partner
PHONE                Telephone
PLACE_OF_DEATH       Place of Death
POSTAL               Postal Code
POSTAL_OTHER         Postal Code - Other
PREF_FIRST_NAME      Preferred First Name
SAL_ADMIN_PLAN       Salary Administration Plan
SECOND_LAST_NAME     Second Last Name
SECOND_LAST_SRCH     Second Name
SEX                  Gender
SMOKER               Smoker
SMOKER_DT            Smoker Date
SOC_SEC_AFF_DT       Social Security Affiliation Dt
STATE                State
STATE_OTHER          State - Other
US_WORK_ELIGIBILTY   Eligible to Work in U.S.
VA_BENEFIT           VA Benefit
Return to Record List
   PERSONAL_VW - Personal Data Name View

Field               Description
EMPLID              EmplID
NAME                Name
Return to Record List
              POSITION_DATA - Position Data

Field                   Description
ACTION                   Action
ACTION_DT                Action Date
ACTION_REASON            Reason Code
ADDS_TO_FTE_ACTUAL       Adds to FTE Actual Count
AVAIL_TELEWORK_POS       Position Eligible for Telework
BARG_UNIT                Bargaining Unit
BUDGETED_POSN            Budgeted Position
BUSINESS_UNIT            Business Unit
CLASS_INDC               Classified/Unclassified Indc
COMPANY                  Company
CONFIDENTIAL_POSN        Confidential Position
COUNTRY_CODE             Country Code
DEPTID                   Department
DESCR                    Description
DESCRLONG                Description
DESCRSHORT               Short Description
EFFDT                    Effective Date
EFF_STATUS               Status as of Effective Date
EG_ACADEMIC_RANK         Academic Rank
EG_GROUP                 Service Calculation Group
ENCUMBER_INDC            Encumbrance Indicator
ENCUMB_SAL_AMT           Encumber Salary Amount
ENCUMB_SAL_OPTN          Encumber Salary Option
FLSA_STATUS              FLSA Status
FRI_HRS                  Friday
FTE                      FTE
FULL_PART_TIME           Full/Part Time
GRADE                    Salary Grade
GRADE_FROM               From Grade
GRADE_TO                 To Grade
GVT_AUDITED_BY_ID        Position Audited By
GVT_COMP_AREA            Competitive Area
GVT_COMP_LEVEL           Competitive Level
GVT_DRUG_TEST_REQ        Drug Test (Applicable)
GVT_DT_POSN_ESTAB        Date Position Established
GVT_EXEC_FIN_DISCL       Executive Financial Disclosure
GVT_FUND_SOURCE          Fund Source
GVT_INTEL_POSN           Intelligence Position
GVT_LAST_AUDIT_DT        Position Audit Date
GVT_LEO_POSITION         LEO/Fire Position
GVT_MAINT_REVIEWCD       Maintenance Review
GVT_MANTREV_RESULT       Maintenance Review Results
GVT_MOB_POSN_IND         Mobility Position
GVT_NFC_FUNCTN_CD    NFC Function Code
GVT_NFC_PI_IND_OVR   Override NFC Indicator
GVT_NTE_DATE         Not To Exceed Date
GVT_OBLIGATED_TO     Obligated To ID
GVT_OBLIG_EXPIR_DT   Obligation Expiration
GVT_OCC_SERIES       Occupational Series
GVT_ORG_NUMCD1       Numeric Cd 1
GVT_ORG_NUMCD2       Numeric Cd 2
GVT_ORG_NUMCD3       Numeric Cd 3
GVT_ORG_NUMCD4       Numeric Cd 4
GVT_ORG_NUMCD5       Numeric Cd 5
GVT_ORG_NUMCD6       Numeric Cd 6
GVT_ORG_NUMCD7       Numeric Cd 7
GVT_ORG_SUBAGENCY    Org Structure
GVT_ORG_TTL_CD       Organization Posn Title Cd
GVT_ORG_TTL_DESCR    Organization Position Title
GVT_PAREN_TITLE      Parenthetical Title
GVT_PAR_NBR          Personnel Action Request Nbr
GVT_PAY_PLAN         Pay Plan
GVT_PERF_PLAN        Performance Plan
GVT_PI_UPD_IND       PI upd ind
GVT_POI              Personnel Office ID
GVT_POSN_LOC         Position Location
GVT_POSN_OCCUPIED    Position Occupied
GVT_POSN_SENS_CD     Sensitivity Code
GVT_PRESIDENT_APPT   Presidential Appt Posn
GVT_PROC_INTEG_PSN   Procurement Integ Posn
GVT_STAFF_LINE       Staff/Line Position
GVT_STATUS_TYPE      Status Type
GVT_SUB_AGENCY       Sub - Agency
GVT_TARGET_GRADE     Target Grade
GVT_VACY_REVW_CD     Vacancy Review Code
GVT_WIP_STATUS       Work - in - Progress Status
GVT_WORK_SCHED       Work Schedule
HEALTH_CERTIFICATE   Health Certificate
INCLUDE_SALPLN_FLG   Include Salary Plan/Grade
JOBCODE              Job Code
JOB_SHARE            Job Sharing Permitted
KEY_POSITION         Key Position
LANGUAGE_SKILL       Language Required
LASTUPDDTTM          Last Update Date/Time
LASTUPDOPRID         by
LOCATION             Location Code
MAIL_DROP            Mail Drop ID
MANAGER_LEVEL        Manager Level
MAX_HEAD_COUNT       Max Head Count
MILITARY_SERVICE     Military Service
MIL_RANK             Military Rank
MIL_SVC_COMP_CD      Service Component
MON_HRS              Monday
ORGCODE              Organization Hierarchy Code
ORGCODE_FLAG         Organization Hierarchy Flag
PHONE                Telephone
PKG_RULE_ID          Package Rule ID
PKG_TEMPLATE_ID      Package Template ID
POSITION_NBR         Position Number
POSITION_POOL_ID     Position Pool ID
POSN_STATUS          Position Status
REG_REGION           Regulatory Region
REG_TEMP             Regular/Temporary
REPORTS_TO           Reports To Position Number
REPORT_DOTTED_LINE   Dotted - Line Report
SAL_ADMIN_PLAN       Salary Administration Plan
SAT_HRS              Saturday
SEASONAL             Seasonal
SEC_CLEARANCE_TYPE   Security Clearance Type
SHIFT                Regular Shift
SIGN_AUTHORITY       Signature Authority
STATUS_DT            Status Date
STD_HOURS            Standard Hours
STD_HRS_FREQUENCY    Standard Work Period
STEP                 Step
STEP_FROM            Step
STEP_TO              Step
SUN_HRS              Sunday
SUPV_LVL_ID          Supervisor Level
THURS_HRS            Thursday
TRN_PROGRAM          Training Program
TUES_HRS             Tuesday
UNION_CD             # Months
UPDATE_INCUMBENTS    Update Incumbents
WED_HRS              Wednesday
Return to Record List
        POSN_INCUMBENT - Posn Incumbents - Emplid Only

Field                Description
EFFDT                Effective Date
EMPLID               EmplID
POSITION_NBR         Position Number
Return to Record List
   POSN_VACANT - Vacant Budgeted Posns by Dept

Field                Description
BUSINESS_UNIT        Business Unit
COMPANY              Company
CONFIDENTIAL_POSN    Confidential Position
DEPTID               Department
DESCR                Description
DESCRLONG            Description
FULL_PART_TIME       Full/Part Time
GRADE                Salary Grade
JOBCODE              Job Code
LOCATION             Location Code
MANAGER_LEVEL        Manager Level
MAX_HEAD_COUNT       Max Head Count
POSITION_NBR         Position Number
POSN_STATUS          Position Status
REG_TEMP             Regular/Temporary
REPORTS_TO           Reports To Position Number
SAL_ADMIN_PLAN       Salary Administration Plan
SETID                SetID
STATUS_DT            Status Date
STEP                 Step
Return to Record List
        PSXLATITEM - Translate Value Items

Field                 Description
EFFDT                 Effective Date
EFF_STATUS            Status as of Effective Date
FIELDNAME             Field Name
FIELDVALUE            Field Value
LASTUPDDTTM           Last Update Date/Time
LASTUPDOPRID          Last Update User ID
SYNCID                Synchronization ID
XLATLONGNAME          Translate Long Name
XLATSHORTNAME         Translate Short Name
Return to Record List
     SCRTY_TBL_DEPT - OprID Access to Departments

Field                   Description
ACCESS_CD               Access Code
DEPTID                  Department
ROWSECCLASS             Row Security Permission List
SETID                   SetID
TREE_EFFDT              Effective Date of Tree
TREE_NODE_NUM           Tree Node Number
TREE_NODE_NUM_END       Tree Node Number End
Return to Record List
  VISA_PMT_DATA - EE/Dependent Visa Data

Field                 Description
COUNTRY               Country
DEPENDENT_ID          Dependent ID
DT_ISSUED             Issue Date
DURATION_TIME         Duration Time
DURATION_TYPE         Type of Duration
EFFDT                 Effective Date
EMPLID                EmplID
ENTRY_DT              Entry Date
EXPIRATN_DT           Expiration Date
ISSUING_AUTHORITY     Issuing Authority
PLACE_ISSUED          Place of Issue
SEVIS_ID_CU           SEVIS ID
STATUS_DT             Status Date
VISA_PERMIT_TYPE      Visa/Permit Type
VISA_WRKPMT_NBR       Visa/Permit Number
VISA_WRKPMT_STATUS    Visa/Permit Status

				
DOCUMENT INFO
Description: Professional Record Company Business Plan document sample