LM_PERSON_JOB

(SQL Table)
 Index Back

Person Job Data

Contains Job Data

  • Parent Record Of LM_ACTV_LRNR_VW LM_PERSON_ATTRB LM_PER_ATTAD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 LM_EFFSEQ Number(3,0) SMALLINT NOT NULL ELM Effective Sequence
    5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    6 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active

    Default Value: Y

    7 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Prompt Table: %EDITTABLE

    8 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID

    Prompt Table: LM_JOBCD_ALL_VW

    9 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    10 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number

    Prompt Table: LM_POS_ALL_VW

    11 LM_SUPERVISOR_ID Number(15,0) DECIMAL(15) NOT NULL Supervisor ID

    Prompt Table: LM_SUPERVISR_VW

    12 LM_REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    14 LM_HLDAY_SCHED_ID Character(6) VARCHAR2(6) NOT NULL Holiday Schedule ID
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    16 LM_ACTION Character(3) VARCHAR2(3) NOT NULL Action/Reason from HR
    17 LM_ACTION_DT Date(10) DATE Action/Reason Date
    18 LM_ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Action/Reason
    19 LM_TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
    20 LM_SHIFT Character(1) VARCHAR2(1) NOT NULL Shift
    1=1
    2=2
    3=3
    C=Compressed
    N=Not Applicable
    R=Rotating
    21 LM_REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary
    22 LM_FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full Time/Part Time
    F=Full-Time
    P=Part-Time
    23 LM_PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    24 LM_EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    25 LM_STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    26 LM_STD_HRS_FREQ Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    27 LM_OFFICER_CD Character(1) VARCHAR2(1) NOT NULL Officer Code
    C=Chairman
    D=Director
    N=None
    O=Officer
    P=President
    S=Secretary
    T=Treasurer
    V=Vice President
    28 LM_EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Class
    29 LM_GRADE Character(4) VARCHAR2(4) NOT NULL Grade for the Enrollment. Grade can be PASS / FAIL. A grade scheme table will provided with some defaults. These defaults can be customized by the customer at installation time. E.g. A means Pass, B means Pass, C means Fail
    FAIL=Failed
    NGRA=Not Graded
    PASS=Passed
    SEL=Select...
    30 LM_STEP Number(2,0) SMALLINT NOT NULL Step
    31 LM_GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    32 LM_ACCT_CD Character(25) VARCHAR2(25) NOT NULL Account Code
    33 LM_REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    34 LM_FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL Fair Labor Standards Act (FLSA) Status
    A=Administrative
    E=Executive
    M=Management
    N=Nonexempt
    O=Outside Salesperson
    P=Professional
    X=No FLSA Required
    35 LM_EEO_CLASS Character(1) VARCHAR2(1) NOT NULL Equal Employment Opportunity (EEO) Classification
    E=Exclude from Count
    N=None of the Above
    P=Production Trainee
    W=White-Collar Trainee
    36 LM_CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    37 LM_JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL Primary Job Indicator
    N=Not Applicable
    P=Primary Job
    S=Secondary Job
    38 LM_WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
    39 LM_FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code
    40 LM_TARIFF_GER Character(2) VARCHAR2(2) NOT NULL German Tariff
    01=Metal Processing
    02=Banking
    03=Building and Civil Engineering
    04=Clothing Industry
    05=Chemical Industry
    06=Printing Industry
    07=Retail Trade
    08=Fossil Oil and Gas Extraction
    09=Glass Industry
    10=Wholesale and Foreign Trade
    11=Wood Processing
    12=Rubber Processing
    13=Ceramics
    14=Agriculture
    15=Leather Processing
    16=Public Sector
    17=Paper Industry
    18=Paper Processing
    19=Sawing Industry
    20=German Seaports
    21=Hard-Coal Mining
    22=Textile Industry
    23=Insurance
    24=Housing Industry
    25=Periodical Publishers
    26=Newspaper Publishers
    27=Tobacco Industry
    41 LM_TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL German Tariff Area
    42 LM_PERFORM_GRP_GER Character(2) VARCHAR2(2) NOT NULL German Performance group
    A1=Blue Collar Performance G1
    A2=Blue Collar Performance G2
    A3=Blue Collar Performance G3
    K2=Commercial White Collar G2
    K3=Commercial White Collar G3
    K4=Commercial White Collar K4
    K5=Commercial White Collar K5
    T2=Technical White Collar G2
    T3=Technical White Collar G3
    T4=Technical White Collar G4
    T5=Technical White Collar G5
    43 LM_LABOR_TYPE_GER Character(1) VARCHAR2(1) NOT NULL German Labor Type
    M=Management
    N=Non-Management
    44 LM_SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL German Spokesman Committee
    45 LM_UNION_FULL_PART Character(1) VARCHAR2(1) NOT NULL Union Participation
    F=Full Time
    P=Part Time
    46 LM_UNION_POS Character(1) VARCHAR2(1) NOT NULL Union Position
    L=Leader of the union
    N=National Leader
    R=Registered
    S=Leader of S.O.C.
    47 LM_MATRICULA_NBR Number(5,0) INTEGER NOT NULL Matricula Number
    48 LM_SOC_SEC_RISK_CD Character(3) VARCHAR2(3) NOT NULL Social Security Risk Code
    49 LM_UNION_FEE_AMT Number(9,2) DECIMAL(8,2) NOT NULL Union Fee Amount
    50 LM_EXEMPT_JOB_LBR Character(1) VARCHAR2(1) NOT NULL Exempted Job
    51 LM_EXMPT_HRS_MONTH Number(3,0) SMALLINT NOT NULL Exempted Hours per Month
    52 LM_WRKS_CNCL_FUNC Character(1) VARCHAR2(1) NOT NULL Works Council Function
    M=Member
    P=President
    S=Secretary
    53 LM_INTER_WRKS_CNCL Character(1) VARCHAR2(1) NOT NULL Intercenter Works Council Function
    1=Member 1
    2=Member 2
    3=Member 3
    54 LM_PAY_UNION_FEE Character(1) VARCHAR2(1) NOT NULL Pay Union Fee
    55 LM_UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    56 LM_BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2
    57 LM_LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
    58 LM_EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
    59 LM_EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
    60 LM_EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2
    61 LM_HR_SUPERVISOR Character(15) VARCHAR2(15) NOT NULL HR Supervisor ID
    62 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.

    Prompt Table: LM_ORG_PO_VW

    63 LM_TU_POOL_ID Number(10,0) DECIMAL(10) NOT NULL Training Unit Pool No. Unique key for Training Unit Pool Record.

    Prompt Table: LM_ORG_TU_VW

    64 LM_PER_ORG Character(3) VARCHAR2(3) NOT NULL Persons Organizational Relationship. Brought over from HCM.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person Of Interest
    65 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

    Default Value: 0

    66 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.
    67 LM_HR_ESTAB_ID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    68 LM_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Location Id
    69 LM_SETID_LBR_AGR Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
    70 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    71 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    72 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    73 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    74 LM_LRN_TYPE Character(3) VARCHAR2(3) NOT NULL Learner Type
    JBS=Job Seeker
    OTH=Other
    PBI=Paid by Individual
    SPC=Salary for Prof Contract
    SPE=Salary Paid by Employer