JOB_APPROVALS

(SQL Table)
 Index Back

Job Action Approvals

Job Action Approvals is a record in the database that carries Initiated, Requested, Approved, and Denied job change requests.

  • Parent record: PER_ORG_ASGN_VW

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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 JOB_EFFDT Date(10) DATE NOT NULL Job Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    5 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    7 JOB_RQST_STATUS Character(1) VARCHAR2(1) NOT NULL Job Action Request Status
    A=Approved
    D=Denied
    I=Initiated
    P=Processed
    R=Requested

    Default Value: I

    8 JOB_RQST_STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %Date

    9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

    12 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    13 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: JOB.CURRENCY_CD

    15 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Default Value: JOB.COMP_FREQUENCY

    Prompt Table: COMP_FREQ_VW

    16 COMMENTS Long Character CLOB Comment