• • Model View
    
• Table PTRATRM
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTRATRM_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTRATRM_TERM_CODE (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTRATRM_USER_ID (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTRATRM_ACTIVITY_DATE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTRATRM_DATA_ORIGIN (# 5)
    
    • Source Code Comments
      
• Table PTRBDCA
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTRBDCA_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_SHORT_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_LONG_DESC (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_PRIORITY (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_CALC_RULE (# 5)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEEK1_IND (# 6)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEEK2_IND (# 7)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEEK3_IND (# 8)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEEK4_IND (# 9)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEEK5_IND (# 10)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT1_IND (# 11)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT2_IND (# 12)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT3_IND (# 13)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT4_IND (# 14)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT1_TITLE (# 15)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT2_TITLE (# 16)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT3_TITLE (# 17)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT4_TITLE (# 18)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION1_IND (# 19)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION2_IND (# 20)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION3_IND (# 21)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION4_IND (# 22)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION5_IND (# 23)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION1_TITLE (# 24)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION2_TITLE (# 25)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION3_TITLE (# 26)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION4_TITLE (# 27)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION5_TITLE (# 28)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_GROSS_REPORT_IND (# 29)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_BENEFIT_IND (# 30)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_TXCD_CODE (# 31)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_TAX_TYPE_IND (# 32)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OVERLOAD_IND (# 33)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_ARREAR_IND (# 34)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_ACTIVITY_DATE (# 35)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_BDTY_CODE (# 36)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT1_DESC (# 37)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT2_DESC (# 38)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT3_DESC (# 39)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT4_DESC (# 40)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_1099_CODE (# 41)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_FLAT_AMT_IND (# 42)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_YTD_START_MONTH (# 43)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEB_DESC (# 44)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_WEB_INFO_URL (# 45)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION1_WEB_DESC (# 46)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION2_WEB_DESC (# 47)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION3_WEB_DESC (# 48)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION4_WEB_DESC (# 49)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_OPTION5_WEB_DESC (# 50)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT1_WEB_DESC (# 51)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT2_WEB_DESC (# 52)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT3_WEB_DESC (# 53)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_AMT4_WEB_DESC (# 54)
    
    • Source Code Comments
      
  • Columns Comments for PTRBDCA_BDCL_CODE (# 55)
    
    • Source Code Comments
      
• Table PTRECLS
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTRECLS_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_SHORT_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_LONG_DESC (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PICT_CODE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_SHCD_CODE (# 5)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_HOURS_PER_PAY (# 6)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_HOURS_PER_DAY (# 7)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_SALARY_ENCUMBRANCE_IND (# 8)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TS_ROSTER_IND (# 9)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_DEFAULT_HOURS_IND (# 10)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_SALARY_IND (# 11)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_BUDGET_ROLL_IND (# 12)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_LCAT_CODE (# 13)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_BCAT_CODE (# 14)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_ACTIVITY_DATE (# 15)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_EEOG_CODE (# 16)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_EMPR_CODE (# 17)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_INSTRUCT_CODE (# 18)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_STCA_CODE (# 19)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_STGR_CODE (# 20)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_WKPR_CODE (# 21)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_LGCD_CODE (# 22)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_FLSA_IND (# 23)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_WKSH_CODE (# 24)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TIME_ENTRY_IND (# 25)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TIME_ENTRY_DAY (# 26)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_DFPR_CODE (# 27)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PCAT_CODE (# 28)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PREMIUM_ROLL_IND (# 29)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_INTERNAL_FT_PT_IND (# 30)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_EGRP_CODE (# 31)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_STRS_ASSN_CODE (# 32)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_STRS_PAY_CODE (# 33)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PERS_GROUP (# 34)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PERS_PAY_CODE (# 35)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TIME_ENTRY_METHOD (# 36)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TIME_ENTRY_TYPE (# 37)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_LEAVE_REQUEST_IND (# 38)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_EXCEPTION_APPROVAL_IND (# 39)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_TIME_IN_OUT_IND (# 40)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_OVERRIDE_LD_WEB_IND (# 41)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_OVERRIDE_LD_DEPT_IND (# 42)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_BUDG_BASIS (# 43)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_ANN_BASIS (# 44)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_CREATE_JFTE_IND (# 45)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_LEAV_REPT_METHOD (# 46)
    
    • Source Code Comments
      
  • Columns Comments for PTRECLS_PICT_CODE_LEAV_REPT (# 47)
    
    • Source Code Comments
      
• Table PTRSCRD
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTRSCRD_ATRM_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_LEVL_CODE (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_MIN_HOURS (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_USER_ID (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_ACTIVITY_DATE (# 5)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_DATA_ORIGIN (# 6)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_START_DATE (# 7)
    
    • Source Code Comments
      
  • Columns Comments for PTRSCRD_END_DATE (# 8)
    
    • Source Code Comments
      
• Table PTRSTDE
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTRSTDE_ECLS_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_BDCA_CODE (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_FT_STATUS (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_PT_STATUS (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_USER_ID (# 5)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_ACTIVITY_DATE (# 6)
    
    • Source Code Comments
      
  • Columns Comments for PTRSTDE_DATA_ORIGIN (# 7)
    
    • Source Code Comments
      
• Table PTVATRM
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for PTVATRM_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for PTVATRM_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for PTVATRM_USER_ID (# 3)
    
    • Source Code Comments
      
  • Columns Comments for PTVATRM_ACTIVITY_DATE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for PTVATRM_DATA_ORIGIN (# 5)
    
    • Source Code Comments
      
• Table STVLEVL
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for STVLEVL_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_ACTIVITY_DATE (# 3)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_ACAD_IND (# 4)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_CEU_IND (# 5)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_SYSTEM_REQ_IND (# 6)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_VR_MSG_NO (# 7)
    
    • Source Code Comments
      
  • Columns Comments for STVLEVL_EDI_EQUIV (# 8)
    
    • Source Code Comments
      
• Table STVTERM
  
  • Object Full Name
    
  • Source Code Comments
    
  • Columns Comments for STVTERM_CODE (# 1)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_DESC (# 2)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_START_DATE (# 3)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_END_DATE (# 4)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_FA_PROC_YR (# 5)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_ACTIVITY_DATE (# 6)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_FA_TERM (# 7)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_FA_PERIOD (# 8)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_FA_END_PERIOD (# 9)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_ACYR_CODE (# 10)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_HOUSING_START_DATE (# 11)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_HOUSING_END_DATE (# 12)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_SYSTEM_REQ_IND (# 13)
    
    • Source Code Comments
      
  • Columns Comments for STVTERM_TRMT_CODE (# 14)
    
    • Source Code Comments
      
• Link between PTRATRM and PTVATRM
  
• Link between PTRSTDE and PTRBDCA
  
• Link between PTRSTDE and PTRECLS
  
• Link between PTRSCRD and PTVATRM
  
• Link between PTRSCRD and STVLEVL
  
• Link between PTRATRM and STVTERM