• List of Objects
    • Comments
    • Model View
  • Table NBRBJOB
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for NBRBJOB_PIDM (1)
      • Source Code Comments

    • Columns Comments for NBRBJOB_POSN (2)
      • Source Code Comments

    • Columns Comments for NBRBJOB_SUFF (3)
      • Source Code Comments

    • Columns Comments for NBRBJOB_BEGIN_DATE (4)
      • Source Code Comments

    • Columns Comments for NBRBJOB_END_DATE (5)
      • Source Code Comments

    • Columns Comments for NBRBJOB_DEFER_BAL (6)
      • Source Code Comments

    • Columns Comments for NBRBJOB_CONTRACT_TYPE (7)
      • Source Code Comments

    • Columns Comments for NBRBJOB_SALARY_ENCUMBRANCE (8)
      • Source Code Comments

    • Columns Comments for NBRBJOB_CONTRACT_BEGIN_DATE (9)
      • Source Code Comments

    • Columns Comments for NBRBJOB_CONTRACT_END_DATE (10)
      • Source Code Comments

    • Columns Comments for NBRBJOB_TOTAL_CONTRACT_HRS (11)
      • Source Code Comments

    • Columns Comments for NBRBJOB_TOTAL_ENCUMBRANCE_HRS (12)
      • Source Code Comments

    • Columns Comments for NBRBJOB_STEP_INCR_MON (13)
      • Source Code Comments

    • Columns Comments for NBRBJOB_STEP_INCR_DAY (14)
      • Source Code Comments

    • Columns Comments for NBRBJOB_COAS_CODE (15)
      • Source Code Comments

    • Columns Comments for NBRBJOB_ACTIVITY_DATE (16)
      • Source Code Comments

    • Columns Comments for NBRBJOB_ACCRUE_LEAVE_IND (17)
      • Source Code Comments

    • Columns Comments for NBRBJOB_CIVIL_SERVICE_IND (18)
      • Source Code Comments

    • Columns Comments for NBRBJOB_ENCUMBRANCE_CHANGE_IND (19)
      • Source Code Comments

    • Columns Comments for NBRBJOB_FRINGE_ENCUMBRANCE (20)
      • Source Code Comments

    • Columns Comments for NBRBJOB_IPEDS_REPT_IND (21)
      • Source Code Comments

    • Columns Comments for NBRBJOB_FACL_STATSCAN_REPT_IND (22)
      • Source Code Comments

    • Columns Comments for NBRBJOB_PROBATION_BEGIN_DATE (23)
      • Source Code Comments

    • Columns Comments for NBRBJOB_PROBATION_END_DATE (24)
      • Source Code Comments

    • Columns Comments for NBRBJOB_PROBATION_UNITS (25)
      • Source Code Comments

    • Columns Comments for NBRBJOB_ELIGIBLE_DATE (26)
      • Source Code Comments

  • Table NBRJLBD
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for NBRJLBD_PIDM (1)
      • Source Code Comments

    • Columns Comments for NBRJLBD_POSN (2)
      • Source Code Comments

    • Columns Comments for NBRJLBD_SUFF (3)
      • Source Code Comments

    • Columns Comments for NBRJLBD_EFFECTIVE_DATE (4)
      • Source Code Comments

    • Columns Comments for NBRJLBD_COAS_CODE (5)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACCI_CODE (6)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FUND_CODE (7)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ORGN_CODE (8)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACCT_CODE (9)
      • Source Code Comments

    • Columns Comments for NBRJLBD_PROG_CODE (10)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACTV_CODE (11)
      • Source Code Comments

    • Columns Comments for NBRJLBD_LOCN_CODE (12)
      • Source Code Comments

    • Columns Comments for NBRJLBD_PROJ_CODE (13)
      • Source Code Comments

    • Columns Comments for NBRJLBD_CTYP_CODE (14)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACCT_CODE_EXTERNAL (15)
      • Source Code Comments

    • Columns Comments for NBRJLBD_PERCENT (16)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ENCD_NUM (17)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ENCD_SEQ_NUM (18)
      • Source Code Comments

    • Columns Comments for NBRJLBD_SALARY_ENCUMBRANCE (19)
      • Source Code Comments

    • Columns Comments for NBRJLBD_SALARY_ENC_TO_POST (20)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FRINGE_ENCUMBRANCE (21)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FRINGE_ENC_TO_POST (22)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FUND_CODE_FRINGE (23)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ORGN_CODE_FRINGE (24)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACCT_CODE_FRINGE (25)
      • Source Code Comments

    • Columns Comments for NBRJLBD_PROG_CODE_FRINGE (26)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACTV_CODE_FRINGE (27)
      • Source Code Comments

    • Columns Comments for NBRJLBD_LOCN_CODE_FRINGE (28)
      • Source Code Comments

    • Columns Comments for NBRJLBD_CHANGE_IND (29)
      • Source Code Comments

    • Columns Comments for NBRJLBD_ACTIVITY_DATE (30)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FRINGE_RESIDUAL (31)
      • Source Code Comments

    • Columns Comments for NBRJLBD_FRINGE_RES_TO_POST (32)
      • Source Code Comments

  • Table NBRJOBS
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for NBRJOBS_PIDM (1)
      • Source Code Comments

    • Columns Comments for NBRJOBS_POSN (2)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SUFF (3)
      • Source Code Comments

    • Columns Comments for NBRJOBS_EFFECTIVE_DATE (4)
      • Source Code Comments

    • Columns Comments for NBRJOBS_STATUS (5)
      • Source Code Comments

    • Columns Comments for NBRJOBS_DESC (6)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ECLS_CODE (7)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PICT_CODE (8)
      • Source Code Comments

    • Columns Comments for NBRJOBS_COAS_CODE_TS (9)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ORGN_CODE_TS (10)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SAL_TABLE (11)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SAL_GRADE (12)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SAL_STEP (13)
      • Source Code Comments

    • Columns Comments for NBRJOBS_APPT_PCT (14)
      • Source Code Comments

    • Columns Comments for NBRJOBS_FTE (15)
      • Source Code Comments

    • Columns Comments for NBRJOBS_HRS_DAY (16)
      • Source Code Comments

    • Columns Comments for NBRJOBS_HRS_PAY (17)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SHIFT (18)
      • Source Code Comments

    • Columns Comments for NBRJOBS_REG_RATE (19)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ASSGN_SALARY (20)
      • Source Code Comments

    • Columns Comments for NBRJOBS_FACTOR (21)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ANN_SALARY (22)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PER_PAY_SALARY (23)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PAYS (24)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PER_PAY_DEFER_AMT (25)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ACTIVITY_DATE (26)
      • Source Code Comments

    • Columns Comments for NBRJOBS_JCRE_CODE (27)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SGRP_CODE (28)
      • Source Code Comments

    • Columns Comments for NBRJOBS_EMPR_CODE (29)
      • Source Code Comments

    • Columns Comments for NBRJOBS_LGCD_CODE (30)
      • Source Code Comments

    • Columns Comments for NBRJOBS_LOCN_CODE (31)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SCHL_CODE (32)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SUPERVISOR_PIDM (33)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SUPERVISOR_POSN (34)
      • Source Code Comments

    • Columns Comments for NBRJOBS_SUPERVISOR_SUFF (35)
      • Source Code Comments

    • Columns Comments for NBRJOBS_WKCP_CODE (36)
      • Source Code Comments

    • Columns Comments for NBRJOBS_JBLN_CODE (37)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PERS_CHG_DATE (38)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PCAT_CODE (39)
      • Source Code Comments

    • Columns Comments for NBRJOBS_DFPR_CODE (40)
      • Source Code Comments

    • Columns Comments for NBRJOBS_ENCUMBRANCE_HRS (41)
      • Source Code Comments

    • Columns Comments for NBRJOBS_CONTRACT_NO (42)
      • Source Code Comments

    • Columns Comments for NBRJOBS_STRS_ASSN_CODE (43)
      • Source Code Comments

    • Columns Comments for NBRJOBS_STRS_PAY_CODE (44)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PERS_PAY_CODE (45)
      • Source Code Comments

    • Columns Comments for NBRJOBS_TIME_ENTRY_METHOD (46)
      • Source Code Comments

    • Columns Comments for NBRJOBS_TIME_ENTRY_TYPE (47)
      • Source Code Comments

    • Columns Comments for NBRJOBS_TIME_IN_OUT_IND (48)
      • Source Code Comments

    • Columns Comments for NBRJOBS_LCAT_CODE (49)
      • Source Code Comments

    • Columns Comments for NBRJOBS_LEAV_REPT_METHOD (50)
      • Source Code Comments

    • Columns Comments for NBRJOBS_PICT_CODE_LEAV_REPT (51)
      • Source Code Comments

  • Table PERDAYH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERDAYH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERDAYH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERDAYH_TIME_ENTRY_DATE (3)
      • Source Code Comments

    • Columns Comments for PERDAYH_JOBS_STATUS (4)
      • Source Code Comments

    • Columns Comments for PERDAYH_SHCD_CODE (5)
      • Source Code Comments

    • Columns Comments for PERDAYH_ACTIVITY_DATE (6)
      • Source Code Comments

  • Table PERDAYS
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERDAYS_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERDAYS_TIME_ENTRY_DATE (2)
      • Source Code Comments

    • Columns Comments for PERDAYS_JOBS_STATUS (3)
      • Source Code Comments

    • Columns Comments for PERDAYS_SHCD_CODE (4)
      • Source Code Comments

    • Columns Comments for PERDAYS_ACTIVITY_DATE (5)
      • Source Code Comments

  • Table PEREARH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PEREARH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PEREARH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PEREARH_EARN_CODE (3)
      • Source Code Comments

    • Columns Comments for PEREARH_SHIFT (4)
      • Source Code Comments

    • Columns Comments for PEREARH_SPECIAL_RATE (5)
      • Source Code Comments

    • Columns Comments for PEREARH_DEFAULT_HRS (6)
      • Source Code Comments

    • Columns Comments for PEREARH_ACTIVITY_DATE (7)
      • Source Code Comments

  • Table PEREARN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PEREARN_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PEREARN_EARN_CODE (2)
      • Source Code Comments

    • Columns Comments for PEREARN_SHIFT (3)
      • Source Code Comments

    • Columns Comments for PEREARN_SPECIAL_RATE (4)
      • Source Code Comments

    • Columns Comments for PEREARN_DEFAULT_HRS (5)
      • Source Code Comments

    • Columns Comments for PEREARN_ACTIVITY_DATE (6)
      • Source Code Comments

  • Table PERELBD
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERELBD_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERELBD_EARN_CODE (2)
      • Source Code Comments

    • Columns Comments for PERELBD_SHIFT (3)
      • Source Code Comments

    • Columns Comments for PERELBD_SPECIAL_RATE (4)
      • Source Code Comments

    • Columns Comments for PERELBD_SEQNO (6)
      • Source Code Comments

    • Columns Comments for PERELBD_COAS_CODE (7)
      • Source Code Comments

    • Columns Comments for PERELBD_ACCI_CODE (8)
      • Source Code Comments

    • Columns Comments for PERELBD_FUND_CODE (9)
      • Source Code Comments

    • Columns Comments for PERELBD_ORGN_CODE (10)
      • Source Code Comments

    • Columns Comments for PERELBD_ACCT_CODE (11)
      • Source Code Comments

    • Columns Comments for PERELBD_PROG_CODE (12)
      • Source Code Comments

    • Columns Comments for PERELBD_ACTV_CODE (13)
      • Source Code Comments

    • Columns Comments for PERELBD_LOCN_CODE (14)
      • Source Code Comments

    • Columns Comments for PERELBD_PROJ_CODE (15)
      • Source Code Comments

    • Columns Comments for PERELBD_CTYP_CODE (16)
      • Source Code Comments

    • Columns Comments for PERELBD_ACCT_CODE_EXTERNAL (17)
      • Source Code Comments

    • Columns Comments for PERELBD_HRS (18)
      • Source Code Comments

    • Columns Comments for PERELBD_ACTIVITY_DATE (19)
      • Source Code Comments

  • Table PERELBH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERELBH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERELBH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERELBH_EARN_CODE (3)
      • Source Code Comments

    • Columns Comments for PERELBH_SHIFT (4)
      • Source Code Comments

    • Columns Comments for PERELBH_SPECIAL_RATE (5)
      • Source Code Comments

    • Columns Comments for PERELBH_SEQNO (7)
      • Source Code Comments

    • Columns Comments for PERELBH_COAS_CODE (8)
      • Source Code Comments

    • Columns Comments for PERELBH_ACCI_CODE (9)
      • Source Code Comments

    • Columns Comments for PERELBH_FUND_CODE (10)
      • Source Code Comments

    • Columns Comments for PERELBH_ORGN_CODE (11)
      • Source Code Comments

    • Columns Comments for PERELBH_ACCT_CODE (12)
      • Source Code Comments

    • Columns Comments for PERELBH_PROG_CODE (13)
      • Source Code Comments

    • Columns Comments for PERELBH_ACTV_CODE (14)
      • Source Code Comments

    • Columns Comments for PERELBH_LOCN_CODE (15)
      • Source Code Comments

    • Columns Comments for PERELBH_PROJ_CODE (16)
      • Source Code Comments

    • Columns Comments for PERELBH_CTYP_CODE (17)
      • Source Code Comments

    • Columns Comments for PERELBH_ACCT_CODE_EXTERNAL (18)
      • Source Code Comments

    • Columns Comments for PERELBH_HRS (19)
      • Source Code Comments

    • Columns Comments for PERELBH_ACTIVITY_DATE (20)
      • Source Code Comments

  • Table PERHOUH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERHOUH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERHOUH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERHOUH_EARN_CODE (3)
      • Source Code Comments

    • Columns Comments for PERHOUH_SHIFT (4)
      • Source Code Comments

    • Columns Comments for PERHOUH_SPECIAL_RATE (5)
      • Source Code Comments

    • Columns Comments for PERHOUH_TIME_ENTRY_DATE (6)
      • Source Code Comments

    • Columns Comments for PERHOUH_HRS (7)
      • Source Code Comments

    • Columns Comments for PERHOUH_ACTIVITY_DATE (8)
      • Source Code Comments

  • Table PERHOUR
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Impact job : PERADJ_PIDM New Job
      • Impacted objects
    • Columns Comments for PERHOUR_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERHOUR_EARN_CODE (2)
      • Source Code Comments

    • Columns Comments for PERHOUR_SHIFT (3)
      • Source Code Comments

    • Columns Comments for PERHOUR_SPECIAL_RATE (4)
      • Source Code Comments

    • Columns Comments for PERHOUR_TIME_ENTRY_DATE (5)
      • Source Code Comments

    • Columns Comments for PERHOUR_HRS (6)
      • Source Code Comments

    • Columns Comments for PERHOUR_ACTIVITY_DATE (7)
      • Source Code Comments

  • Table PERJOBH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERJOBH_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERJOBH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERJOBH_YEAR (3)
      • Source Code Comments

    • Columns Comments for PERJOBH_PICT_CODE (4)
      • Source Code Comments

    • Columns Comments for PERJOBH_PAYNO (5)
      • Source Code Comments

    • Columns Comments for PERJOBH_MONTH (6)
      • Source Code Comments

    • Columns Comments for PERJOBH_ACTION_IND (7)
      • Source Code Comments

    • Columns Comments for PERJOBH_PIDM (8)
      • Source Code Comments

    • Columns Comments for PERJOBH_POSN (9)
      • Source Code Comments

    • Columns Comments for PERJOBH_SUFF (10)
      • Source Code Comments

    • Columns Comments for PERJOBH_COAS_CODE_TS (11)
      • Source Code Comments

    • Columns Comments for PERJOBH_ORGN_CODE_TS (12)
      • Source Code Comments

    • Columns Comments for PERJOBH_STATUS_IND (13)
      • Source Code Comments

    • Columns Comments for PERJOBH_JOB_TITLE (14)
      • Source Code Comments

    • Columns Comments for PERJOBH_ECLS_CODE (16)
      • Source Code Comments

    • Columns Comments for PERJOBH_TIME_ENTRY_METHOD (17)
      • Source Code Comments

    • Columns Comments for PERJOBH_TIME_ENTRY_TYPE (18)
      • Source Code Comments

    • Columns Comments for PERJOBH_TIME_IN_OUT_IND (19)
      • Source Code Comments

    • Columns Comments for PERJOBH_ACAT_CODE (20)
      • Source Code Comments

    • Columns Comments for PERJOBH_COMMENT (21)
      • Source Code Comments

    • Columns Comments for PERJOBH_COMMENT_DATE_TIME (22)
      • Source Code Comments

    • Columns Comments for PERJOBH_COMMENT_CONFID_IND (23)
      • Source Code Comments

    • Columns Comments for PERJOBH_ACTIVITY_DATE (24)
      • Source Code Comments

    • Columns Comments for PERJOBH_LCAT_CODE (25)
      • Source Code Comments

  • Table PERJOBS
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERJOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERJOBS_YEAR (2)
      • Source Code Comments

    • Columns Comments for PERJOBS_PICT_CODE (3)
      • Source Code Comments

    • Columns Comments for PERJOBS_PAYNO (4)
      • Source Code Comments

    • Columns Comments for PERJOBS_MONTH (5)
      • Source Code Comments

    • Columns Comments for PERJOBS_ACTION_IND (6)
      • Source Code Comments

    • Columns Comments for PERJOBS_PIDM (7)
      • Source Code Comments

    • Columns Comments for PERJOBS_POSN (8)
      • Source Code Comments

    • Columns Comments for PERJOBS_SUFF (9)
      • Source Code Comments

    • Columns Comments for PERJOBS_COAS_CODE_TS (10)
      • Source Code Comments

    • Columns Comments for PERJOBS_ORGN_CODE_TS (11)
      • Source Code Comments

    • Columns Comments for PERJOBS_STATUS_IND (12)
      • Source Code Comments

    • Columns Comments for PERJOBS_JOB_TITLE (13)
      • Source Code Comments

    • Columns Comments for PERJOBS_SHIFT (14)
      • Source Code Comments

    • Columns Comments for PERJOBS_ECLS_CODE (15)
      • Source Code Comments

    • Columns Comments for PERJOBS_TIME_ENTRY_METHOD (16)
      • Source Code Comments

    • Columns Comments for PERJOBS_TIME_ENTRY_TYPE (17)
      • Source Code Comments

    • Columns Comments for PERJOBS_TIME_IN_OUT_IND (18)
      • Source Code Comments

    • Columns Comments for PERJOBS_ACAT_CODE (19)
      • Source Code Comments

    • Columns Comments for PERJOBS_COMMENT (20)
      • Source Code Comments

    • Columns Comments for PERJOBS_COMMENT_DATE_TIME (21)
      • Source Code Comments

    • Columns Comments for PERJOBS_COMMENT_CONFID_IND (22)
      • Source Code Comments

    • Columns Comments for PERJOBS_ACTIVITY_DATE (23)
      • Source Code Comments

    • Columns Comments for PERJOBS_LCAT_CODE (24)
      • Source Code Comments

    • Columns Comments for PERJOBS_APPT_PCT (25)
      • Source Code Comments

    • Columns Comments for PERJOBS_FTE (26)
      • Source Code Comments

    • Columns Comments for PERJOBS_HRS_DAY (27)
      • Source Code Comments

  • Table PERLVTK
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERLVTK_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERLVTK_EARN_CODE (2)
      • Source Code Comments

    • Columns Comments for PERLVTK_LEAV_CODE (3)
      • Source Code Comments

    • Columns Comments for PERLVTK_USER_ID (4)
      • Source Code Comments

    • Columns Comments for PERLVTK_ACTIVITY_DATE (5)
      • Source Code Comments

    • Columns Comments for PERLVTK_HRS (6)
      • Source Code Comments

  • Table PERROUH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERROUH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERROUH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERROUH_APPR_SEQNO (3)
      • Source Code Comments

    • Columns Comments for PERROUH_APPR_POSN (4)
      • Source Code Comments

    • Columns Comments for PERROUH_APPR_PIDM (5)
      • Source Code Comments

    • Columns Comments for PERROUH_APPR_ACTION_IND (6)
      • Source Code Comments

    • Columns Comments for PERROUH_MANDATORY_APPR_IND (7)
      • Source Code Comments

    • Columns Comments for PERROUH_ACTION_PIDM (8)
      • Source Code Comments

    • Columns Comments for PERROUH_QUEUE_STATUS_IND (9)
      • Source Code Comments

    • Columns Comments for PERROUH_STATUS_DATE_TIME (10)
      • Source Code Comments

    • Columns Comments for PERROUH_ACTIVITY_DATE (11)
      • Source Code Comments

  • Table PERROUT
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERROUT_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERROUT_APPR_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERROUT_APPR_POSN (3)
      • Source Code Comments

    • Columns Comments for PERROUT_APPR_PIDM (4)
      • Source Code Comments

    • Columns Comments for PERROUT_APPR_ACTION_IND (5)
      • Source Code Comments

    • Columns Comments for PERROUT_MANDATORY_APPR_IND (6)
      • Source Code Comments

    • Columns Comments for PERROUT_ACTION_PIDM (7)
      • Source Code Comments

    • Columns Comments for PERROUT_QUEUE_STATUS_IND (8)
      • Source Code Comments

    • Columns Comments for PERROUT_STATUS_DATE_TIME (9)
      • Source Code Comments

    • Columns Comments for PERROUT_ACTIVITY_DATE (10)
      • Source Code Comments

  • Table PERTETH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERTETH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERTETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_TYPE_IND (3)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_ROLE_IND (4)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_PIDM (5)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_DATE_TIME (6)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_SOURCE_IND (7)
      • Source Code Comments

    • Columns Comments for PERTETH_ACTIVITY_DATE (8)
      • Source Code Comments

    • Columns Comments for PERTETH_TRANS_PROXY_FOR_PIDM (9)
      • Source Code Comments

  • Table PERTITH
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERTITH_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERTITH_TETH_SEQNO (2)
      • Source Code Comments

    • Columns Comments for PERTITH_EARN_CODE (3)
      • Source Code Comments

    • Columns Comments for PERTITH_TIME_ENTRY_DATE (4)
      • Source Code Comments

    • Columns Comments for PERTITH_TIME_IN (5)
      • Source Code Comments

    • Columns Comments for PERTITH_TIME_OUT (6)
      • Source Code Comments

    • Columns Comments for PERTITH_SHIFT (7)
      • Source Code Comments

    • Columns Comments for PERTITH_SPECIAL_RATE (8)
      • Source Code Comments

    • Columns Comments for PERTITH_ACTIVITY_DATE (9)
      • Source Code Comments

  • Table PERTITO
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PERTITO_JOBS_SEQNO (1)
      • Source Code Comments

    • Columns Comments for PERTITO_EARN_CODE (2)
      • Source Code Comments

    • Columns Comments for PERTITO_TIME_ENTRY_DATE (3)
      • Source Code Comments

    • Columns Comments for PERTITO_TIME_IN (4)
      • Source Code Comments

    • Columns Comments for PERTITO_TIME_OUT (5)
      • Source Code Comments

    • Columns Comments for PERTITO_SHIFT (6)
      • Source Code Comments

    • Columns Comments for PERTITO_SPECIAL_RATE (7)
      • Source Code Comments

    • Columns Comments for PERTITO_ACTIVITY_DATE (8)
      • Source Code Comments

  • Table PTRCALN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PTRCALN_YEAR (1)
      • Source Code Comments

    • Columns Comments for PTRCALN_PICT_CODE (2)
      • Source Code Comments

    • Columns Comments for PTRCALN_PAYNO (3)
      • Source Code Comments

    • Columns Comments for PTRCALN_START_DATE (4)
      • Source Code Comments

    • Columns Comments for PTRCALN_END_DATE (5)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_DATE (6)
      • Source Code Comments

    • Columns Comments for PTRCALN_PAY_OF_MONTH_IND (7)
      • Source Code Comments

    • Columns Comments for PTRCALN_FISC_CODE (8)
      • Source Code Comments

    • Columns Comments for PTRCALN_ACTIVITY_DATE (9)
      • Source Code Comments

    • Columns Comments for PTRCALN_ETOT_IND (10)
      • Source Code Comments

    • Columns Comments for PTRCALN_JTOT_IND (11)
      • Source Code Comments

    • Columns Comments for PTRCALN_DTOT_IND (12)
      • Source Code Comments

    • Columns Comments for PTRCALN_DEDN_IND (13)
      • Source Code Comments

    • Columns Comments for PTRCALN_JOBS_IND (14)
      • Source Code Comments

    • Columns Comments for PTRCALN_DEFER_IND (15)
      • Source Code Comments

    • Columns Comments for PTRCALN_TERM_IND (16)
      • Source Code Comments

    • Columns Comments for PTRCALN_LEAV_IND (17)
      • Source Code Comments

    • Columns Comments for PTRCALN_STATS_CANADA_YEAR (18)
      • Source Code Comments

    • Columns Comments for PTRCALN_STATS_CANADA_MONTH (19)
      • Source Code Comments

    • Columns Comments for PTRCALN_TIME_ENTRY_START_DATE (20)
      • Source Code Comments

    • Columns Comments for PTRCALN_TIME_ENTRY_END_DATE (21)
      • Source Code Comments

    • Columns Comments for PTRCALN_TIME_ENTRY_CUTOFF_TIME (22)
      • Source Code Comments

    • Columns Comments for PTRCALN_WEB_VIEW_CUTOFF_DATE (23)
      • Source Code Comments

    • Columns Comments for PTRCALN_LEAV_REPT_START_DATE (24)
      • Source Code Comments

    • Columns Comments for PTRCALN_LEAV_REPT_END_DATE (25)
      • Source Code Comments

    • Columns Comments for PTRCALN_LEAV_REPT_CUTOFF_TIME (26)
      • Source Code Comments

    • Columns Comments for PTRCALN_LR_WEBVIEW_CUTOFF_DATE (27)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE1 (28)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE2 (29)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE3 (30)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE4 (31)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE5 (32)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE6 (33)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE7 (34)
      • Source Code Comments

    • Columns Comments for PTRCALN_CHECK_MESG_LINE8 (35)
      • Source Code Comments

  • Table PTRLVAS
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PTRLVAS_LCAT_CODE (1)
      • Source Code Comments

    • Columns Comments for PTRLVAS_LEAV_CODE (2)
      • Source Code Comments

    • Columns Comments for PTRLVAS_FREQ_IND (3)
      • Source Code Comments

    • Columns Comments for PTRLVAS_SEQ_NO (4)
      • Source Code Comments

    • Columns Comments for PTRLVAS_ACTIVITY_DATE (5)
      • Source Code Comments

    • Columns Comments for PTRLVAS_BASE_DATE (6)
      • Source Code Comments

    • Columns Comments for PTRLVAS_ANN_DAY (7)
      • Source Code Comments

    • Columns Comments for PTRLVAS_EXCESS_IND (8)
      • Source Code Comments

    • Columns Comments for PTRLVAS_MIN_HRS (9)
      • Source Code Comments

    • Columns Comments for PTRLVAS_PRORATE_HRS (10)
      • Source Code Comments

    • Columns Comments for PTRLVAS_BANK_IND (11)
      • Source Code Comments

    • Columns Comments for PTRLVAS_ROLL_MONTH (12)
      • Source Code Comments

    • Columns Comments for PTRLVAS_ROLL_DAY (13)
      • Source Code Comments

    • Columns Comments for PTRLVAS_AVAIL_DAYS (14)
      • Source Code Comments

    • Columns Comments for PTRLVAS_AVAIL_MTHS (15)
      • Source Code Comments

    • Columns Comments for PTRLVAS_MIN_PCT (16)
      • Source Code Comments

    • Columns Comments for PTRLVAS_PRORATE_PCT (17)
      • Source Code Comments

    • Columns Comments for PTRLVAS_WEEK1_IND (18)
      • Source Code Comments

    • Columns Comments for PTRLVAS_WEEK2_IND (19)
      • Source Code Comments

    • Columns Comments for PTRLVAS_WEEK3_IND (20)
      • Source Code Comments

    • Columns Comments for PTRLVAS_WEEK4_IND (21)
      • Source Code Comments

    • Columns Comments for PTRLVAS_WEEK5_IND (22)
      • Source Code Comments

  • Table PTVLCAT
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Columns Comments for PTVLCAT_CODE (1)
      • Source Code Comments

    • Columns Comments for PTVLCAT_DESC (2)
      • Source Code Comments

    • Columns Comments for PTVLCAT_ACTIVITY_DATE (3)
      • Source Code Comments

    • Columns Comments for PTVLCAT_REPORT_IND (4)
      • Source Code Comments

    • Columns Comments for PTVLCAT_HOUR_DAY_IND (5)
      • Source Code Comments

    • Columns Comments for PTVLCAT_USER_ID (6)
      • Source Code Comments

  • Table SPRIDEN
    • Table Columns informations
    • Foreign Key information
    • Index
    • Comments
      • Source Code Comments

    • Impact job : LN_last_name_col New Job
    • Impact job : SPRIDEN_LAST_NAME New Job
      • Impacted objects
    • Impact job : spriden_last_name3 New Job
      • Impacted objects
    • Columns Comments for SPRIDEN_PIDM (1)
      • Source Code Comments

    • Columns Comments for SPRIDEN_ID (2)
      • Source Code Comments

    • Columns Comments for SPRIDEN_LAST_NAME (3)
      • Source Code Comments

    • Columns Comments for SPRIDEN_FIRST_NAME (4)
      • Source Code Comments

    • Columns Comments for SPRIDEN_MI (5)
      • Source Code Comments

    • Columns Comments for SPRIDEN_CHANGE_IND (6)
      • Source Code Comments

    • Columns Comments for SPRIDEN_ENTITY_IND (7)
      • Source Code Comments

    • Columns Comments for SPRIDEN_ACTIVITY_DATE (8)
      • Source Code Comments

    • Columns Comments for SPRIDEN_SEARCH_LAST_NAME (11)
      • Source Code Comments

    • Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (12)
      • Source Code Comments

    • Columns Comments for SPRIDEN_SEARCH_MI (13)
      • Source Code Comments

    • Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (14)
      • Source Code Comments

    • Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (15)
      • Source Code Comments

    • Columns Comments for SPRIDEN_CREATE_USER (17)
      • Source Code Comments

    • Columns Comments for SPRIDEN_CREATE_DATE (18)
      • Source Code Comments

  • Link between NBRBJOB and NBRJOBS
    • Join Information
    • Link List
    • Link Between NBRBJOB and NBRJOBS
      • Foreign Key information
    • Comments
  • Link between SPRIDEN and NBRBJOB
    • Join Information
    • Link List
    • Link Between SPRIDEN and NBRBJOB
      • Foreign Key information
    • Comments
  • Link between SPRIDEN and NBRJOBS
    • Join Information
    • Link List
    • Link Between SPRIDEN and NBRJOBS
      • Foreign Key information
    • Comments
  • Link between PTVLCAT and NBRJOBS
    • Join Information
    • Link List
    • Link Between PTVLCAT and NBRJOBS
      • Foreign Key information
    • Comments
  • Link between SPRIDEN and PERTETH
    • Join Information
    • Link List
    • Link Between SPRIDEN and PERTETH
      • Foreign Key information
    • Comments
  • Link between PERTETH and PERJOBH
    • Join Information
    • Link List
    • Link Between PERTETH and PERJOBH
      • Foreign Key information
    • Comments
  • Link between SPRIDEN and PERJOBS
    • Join Information
    • Link List
    • Link Between SPRIDEN and PERJOBS
      • Foreign Key information
    • Comments