JOBCD_SURVEY_LN

(SQL Table)
Index Back

JBCD Sal Survey - Rel Lang TBL

This is the related language table of the Job Code Salary Survey table (JOBCD_SURVEY).

  • Related Language Record for JOBCD_SURVEY
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SURVEY_JOB_CODE Character(8) VARCHAR2(8) NOT NULL Salary Survey Job Code
    5 SURVEY_PROVIDER Character(8) VARCHAR2(8) NOT NULL Salary Survey Provider
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 SURVEY_PROV_DESC30 Character(30) VARCHAR2(30) NOT NULL Salary Survey Provider Description