SPRIDEN
SPRIDEN
SPRIDEN
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NBRJOBS
NHRDIST
NHRDIST
NHRDIST
NBRBJOB
NHRDIST
SPRIDEN
NBRBJOB
NBRBJOB
PTREARN
Subquery
Subquery
Subquery
Subquery
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PUBLIC
PAYROLL
FNJWT
FNJWT
FNJWT
FNJWT
BETWEEN :NHRDIST_PAYNO AND :NHRDIST_PAYNO1
IN ('010', '290')
NBRBJOB.NBRBJOB_BEGIN_DATE <= NHRDIST.NHRDIST_TRANS_DATE
= :NHRDIST_YEAR
IS NULL
ASC
ASC
ASC
ASC
ASC
ASC
ASC
ASC
ASC
ASC
True
True
True
True
True
True
True
True
True
True
True
True
True
False
False
False
True
True
True
True
True
True
True
SUMAMT
SPRIDEN
SPRIDEN
SPRIDEN
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NHRDIST
NBRJOBS
NHRDIST
NHRDIST
NHRDIST
NBRBJOB
NHRDIST
SPRIDEN
NBRBJOB
NBRBJOB
PTREARN
GRANT_INFO
GRANT_INFO
GRANT_INFO
GRANT_INFO
RPTP.ALASKA.EDU (FNJWT), FNJWT
<Connection type="Oracle" autoCommit="False"><Path>Oracle</Path><AutoConnect>False</AutoConnect><DefaultOnStartup>False</DefaultOnStartup><Database>FNJWT</Database><Host>RPTP.ALASKA.EDU</Host><User>FNJWT</User><WinAuth>False</WinAuth><LastConnectionDate>2020-10-22T23:10:55.0127570</LastConnectionDate><ConnectionMode>Default</ConnectionMode><Port>1521</Port><Sid></Sid><ConnectionType>Client</ConnectionType><Home></Home><Is64Bit>true</Is64Bit><ExplainPlanTable></ExplainPlanTable></Connection>
SPRIDEN_ID False False False SPRIDEN_LAST_NAME False False False SPRIDEN_FIRST_NAME False False False NHRDIST_PAYNO False False False NHRDIST_SEQ_NO False False False NHRDIST_TRANS_DATE False False False NHRDIST_EARN_CODE False False False NHRDIST_HRS False False False 9D643BCF-D886-4754-B4DA-28EC916672D1SUMAMT False False False NBRJOBS_ORGN_CODE_TS False False False NHRDIST_FUND_CODE False False False NHRDIST_ORGN_CODE False False False NHRDIST_ACCT_CODE False False False NBRBJOB_BEGIN_DATE False False False NHRDIST_YEAR False False False SPRIDEN_CHANGE_IND False False False NBRBJOB_POSN False False False NBRBJOB_SUFF False False False PTREARN_SHORT_DESC False False False GRNT False False False GRNT_TITLE False False False PROJ_START False False False PROJ_END False False False 8.6.1.299 True True True True 100 Window False NBRJOBS NBRJOBS False False False False False 56, 0, 250, 200 False True Fixed3D True 00000000000000000000000000000000000000000000000000000000FF6699CCFF66666600000000FF6699CCFF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF6699CCFF666666FFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF333366000000000000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF6699CC00000000000000000000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF666666FFF1F1F1FF6666660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FF333366FFFFFFFFFF333366FFF1F1F1FF333366000000000000000000000000000000000000000000000000FF6699CCFF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FFFFFFFFFF333366FF333366FF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF333366FF6699CC00000000 All False False None False Regular * False False None False Regular NBRJOBS_PIDM False False None False Regular NBRJOBS_POSN False False None False Regular NBRJOBS_SUFF False False None False Regular NBRJOBS_EFFECTIVE_DATE False False None False Regular NBRJOBS_STATUS False False None False Regular NBRJOBS_DESC False False None False Regular NBRJOBS_ECLS_CODE False False None False Regular NBRJOBS_PICT_CODE False False None False Regular NBRJOBS_COAS_CODE_TS False False None False Regular NBRJOBS_ORGN_CODE_TS False True Ascending False Regular NBRJOBS_SAL_TABLE False False None False Regular NBRJOBS_SAL_GRADE False False None False Regular NBRJOBS_SAL_STEP False False None False Regular NBRJOBS_APPT_PCT False False None False Regular NBRJOBS_FTE False False None False Regular NBRJOBS_HRS_DAY False False None False Regular NBRJOBS_HRS_PAY False False None False Regular NBRJOBS_SHIFT False False None False Regular NBRJOBS_REG_RATE False False None False Regular NBRJOBS_ASSGN_SALARY False False None False Regular NBRJOBS_FACTOR False False None False Regular NBRJOBS_ANN_SALARY False False None False Regular NBRJOBS_PER_PAY_SALARY False False None False Regular NBRJOBS_PAYS False False None False Regular NBRJOBS_PER_PAY_DEFER_AMT False False None False Regular NBRJOBS_ACTIVITY_DATE False False None False Regular NBRJOBS_JCRE_CODE False False None False Regular NBRJOBS_SGRP_CODE False False None False Regular NBRJOBS_EMPR_CODE False False None False Regular NBRJOBS_LGCD_CODE False False None False Regular NBRJOBS_LOCN_CODE False False None False Regular NBRJOBS_SCHL_CODE False False None False Regular NBRJOBS_SUPERVISOR_PIDM False False None False Regular NBRJOBS_SUPERVISOR_POSN False False None False Regular NBRJOBS_SUPERVISOR_SUFF False False None False Regular NBRJOBS_WKCP_CODE False False None False Regular NBRJOBS_JBLN_CODE False False None False Regular NBRJOBS_PERS_CHG_DATE False False None False Regular NBRJOBS_PCAT_CODE False False None False Regular NBRJOBS_DFPR_CODE False False None False Regular NBRJOBS_ENCUMBRANCE_HRS False False None False Regular NBRJOBS_CONTRACT_NO False False None False Regular NBRJOBS_STRS_ASSN_CODE False False None False Regular NBRJOBS_STRS_PAY_CODE False False None False Regular NBRJOBS_PERS_PAY_CODE False False None False Regular NBRJOBS_TIME_ENTRY_METHOD False False None False Regular NBRJOBS_TIME_ENTRY_TYPE False False None False Regular NBRJOBS_TIME_IN_OUT_IND False False None False Regular NBRJOBS_LCAT_CODE False False None False Regular NBRJOBS_LEAV_REPT_METHOD False False None False Regular NBRJOBS_PICT_CODE_LEAV_REPT False False None False Regular NBRJOBS_USER_ID False False None False Regular NBRJOBS_DATA_ORIGIN False False None False Regular
SPRIDEN SPRIDEN False False False False False 508, 7, 250, 200 False True Fixed3D True 00000000000000000000000000000000000000000000000000000000FF6699CCFF66666600000000FF6699CCFF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF6699CCFF666666FFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF333366000000000000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF6699CC00000000000000000000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF666666FFF1F1F1FF6666660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FF333366FFFFFFFFFF333366FFF1F1F1FF333366000000000000000000000000000000000000000000000000FF6699CCFF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FFFFFFFFFF333366FF333366FF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF333366FF6699CC00000000 All False False None False Regular * False False None False Regular SPRIDEN_PIDM False False None False Regular SPRIDEN_ID False True Ascending False Regular SPRIDEN_LAST_NAME False True Ascending False Regular SPRIDEN_FIRST_NAME False True Ascending False Regular SPRIDEN_MI False False None False Regular SPRIDEN_CHANGE_IND False True None False Regular SPRIDEN_ENTITY_IND False False None False Regular SPRIDEN_ACTIVITY_DATE False False None False Regular SPRIDEN_USER False False None False Regular SPRIDEN_ORIGIN False False None False Regular SPRIDEN_SEARCH_LAST_NAME False False None False Regular SPRIDEN_SEARCH_FIRST_NAME False False None False Regular SPRIDEN_SEARCH_MI False False None False Regular SPRIDEN_SOUNDEX_LAST_NAME False False None False Regular SPRIDEN_SOUNDEX_FIRST_NAME False False None False Regular SPRIDEN_NTYP_CODE False False None False Regular SPRIDEN_CREATE_USER False False None False Regular SPRIDEN_CREATE_DATE False False None False Regular SPRIDEN_DATA_ORIGIN False False None False Regular SPRIDEN_CREATE_FDMN_CODE False False None False Regular SPRIDEN_NAME_ERROR_CODE False False None False Regular
NHRDIST NHRDIST False False False False False 56, 220, 250, 363 False True Fixed3D True 00000000000000000000000000000000000000000000000000000000FF6699CCFF66666600000000FF6699CCFF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF6699CCFF666666FFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF333366000000000000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF6699CC00000000000000000000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF666666FFF1F1F1FF6666660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FF333366FFFFFFFFFF333366FFF1F1F1FF333366000000000000000000000000000000000000000000000000FF6699CCFF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FFFFFFFFFF333366FF333366FF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF333366FF6699CC00000000 All False False None False Regular * False False None False Regular NHRDIST_YEAR False True None False Regular NHRDIST_PICT_CODE False False None False Regular NHRDIST_PAYNO False True Ascending False Regular NHRDIST_PIDM False False None False Regular NHRDIST_SEQ_NO False True Ascending False Regular NHRDIST_HIST_TYPE_IND False False None False Regular NHRDIST_CATEGORY_CODE False False None False Regular NHRDIST_SOURCE False False None False Regular NHRDIST_FISC_CODE False False None False Regular NHRDIST_RUCL_CODE False False None False Regular NHRDIST_COAS_CODE False False None False Regular NHRDIST_FUND_CODE False True Ascending False Regular NHRDIST_ORGN_CODE False True Ascending False Regular NHRDIST_ACCT_CODE False True Ascending False Regular NHRDIST_PROG_CODE False False None False Regular NHRDIST_ACTV_CODE False False None False Regular NHRDIST_LOCN_CODE False False None False Regular NHRDIST_PROJ_CODE False False None False Regular NHRDIST_CTYP_CODE False False None False Regular NHRDIST_ACCT_CODE_EXTERNAL False False None False Regular NHRDIST_DR_CR_IND False False None False Regular NHRDIST_AMT False False None False Regular NHRDIST_TRANS_DATE False True Ascending False Regular NHRDIST_INTERFACED_IND False False None False Regular NHRDIST_OBUD_CODE False False None False Regular NHRDIST_OBPH_CODE False False None False Regular NHRDIST_POSN False False None False Regular NHRDIST_ENCD_NUM False False None False Regular NHRDIST_ENCD_ITEM_NUM False False None False Regular NHRDIST_ENCD_SEQ_NUM False False None False Regular NHRDIST_PTOT_STATUS False False None False Regular NHRDIST_HRS False True None False Regular NHRDIST_BDCA_CODE False False None False Regular NHRDIST_EARN_CODE False True None False Regular NHRDIST_ECLS_CODE False False None False Regular NHRDIST_SUFF False False None False Regular NHRDIST_ACTIVITY_DATE False False None False Regular NHRDIST_EARN_EXPENDS_PTOT_IND False False None False Regular NHRDIST_TNUM False False None False Regular NHRDIST_DOC_CODE False False None False Regular NHRDIST_POSNBUD_DOC_CODE False False None False Regular 9D643BCF-D886-4754-B4DA-28EC916672D1SUMAMT SUMAMT False True None False Regular
NBRBJOB NBRBJOB False False False False False 576, 283, 250, 278 False True Fixed3D True 00000000000000000000000000000000000000000000000000000000FF6699CCFF66666600000000FF6699CCFF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF6699CCFF666666FFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF333366FFFFFFFFFF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF333366000000000000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF6699CC00000000000000000000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFF666666FFF1F1F1FF6666660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FF333366FFFFFFFFFF333366FFF1F1F1FF333366000000000000000000000000000000000000000000000000FF6699CCFF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF666666FF6699CC0000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FFFFFFFFFF333366FF333366FF333366FF333366FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF666666FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF1F1F1FFF1F1F1FF3333660000000000000000000000000000000000000000000000000000000000000000FF6699CCFF333366FF333366FF333366FF333366FF333366FF333366FF6699CC00000000 All False False None False Regular * False False None False Regular NBRBJOB_PIDM False False None False Regular NBRBJOB_POSN False True None False Regular NBRBJOB_SUFF False True None False Regular NBRBJOB_BEGIN_DATE False True None False Regular NBRBJOB_END_DATE False False None False Regular NBRBJOB_DEFER_BAL False False None False Regular NBRBJOB_CONTRACT_TYPE False False None False Regular NBRBJOB_SALARY_ENCUMBRANCE False False None False Regular NBRBJOB_CONTRACT_BEGIN_DATE False False None False Regular NBRBJOB_CONTRACT_END_DATE False False None False Regular NBRBJOB_TOTAL_CONTRACT_HRS False False None False Regular NBRBJOB_TOTAL_ENCUMBRANCE_HRS False False None False Regular NBRBJOB_STEP_INCR_MON False False None False Regular NBRBJOB_STEP_INCR_DAY False False None False Regular NBRBJOB_COAS_CODE False False None False Regular NBRBJOB_ACTIVITY_DATE False False None False Regular NBRBJOB_ACCRUE_LEAVE_IND False False None False Regular NBRBJOB_CIVIL_SERVICE_IND False False None False Regular NBRBJOB_ENCUMBRANCE_CHANGE_IND False False None False Regular NBRBJOB_FRINGE_ENCUMBRANCE False False None False Regular NBRBJOB_IPEDS_REPT_IND False False None False Regular NBRBJOB_FACL_STATSCAN_REPT_IND False False None False Regular NBRBJOB_PROBATION_BEGIN_DATE False False None False Regular NBRBJOB_PROBATION_END_DATE False False None False Regular NBRBJOB_PROBATION_UNITS False False None False Regular NBRBJOB_ELIGIBLE_DATE False False None False Regular NBRBJOB_USER_ID False False None False Regular NBRBJOB_DATA_ORIGIN False False None False Regular
PTREARN PTREARN False False False False False 1169, 298, 250, 200 False True Fixed3D True 00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFF7DA4F4FF7DA4F4FF7DA4F4FF7DA4F4FF7895C7FF7895C7FF7895C7FF7895C7FF7895C7FF7895C7FF7895C7FF7895C7FF7895C7FF7895C700FFFFFF00FFFFFFFF7DA4F4FFF5FAFDFFD7EBF7FF7DA4F4FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF79A0F2FFD3E8F7FFBBDBF3FF79A0F1FFFFFFFFFFB6BCF0FFFBFCFFFFB5BBF0FFF9F9FEFFB0B6EBFFF6F8FDFFA5ACE5FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF749BEFFFCEE4F8FFB2D4F5FF749BEFFFFFFFFFFFB6BCF0FFF9FBFEFFB2B9EEFFF5F7FDFFAAB1E8FFF3F4FDFFA0A7E1FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF6E94EBFFC9DEF9FFA9CCF6FF6E94ECFFFFFFFFFFF9F9FEFFF6F7FEFFF5F6FDFFF2F3FCFFEFF1FCFFEFF1FCFFEDEEFBFFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF678EE7FFC2D9FBFF9EC2F7FF678EE8FFFFFFFFFFF6F7FDFFF3F5FDFFF1F2FCFFEEF0FBFFEBEDFBFFEBEDFBFFE8EBFAFFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF6087E3FFBBD3FCFF93BAFAFF6086E3FFFFFFFFFFAFB5EBFFEFF1FCFFA6ACE5FFEAECFBFF9BA2DDFFE7E9FBFF9198D6FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF587EDFFFB4CDFCFF88B0FBFF597EDFFFFFFFFFFFABB1E8FFECEDFBFFA1A7E1FFE6E8FAFF959DD9FFE3E5FAFF8D95D3FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF5178DBFFAEC8FEFF7FA8FDFF5077DBFFFFFFFFFFEAECFBFFE7E9FBFFE5E7FAFFE2E4FAFFDFE2F8FFDFE2F8FFDDDFF8FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF5178DBFFAEC8FEFF7FA8FDFF5077DBFFFFFFFFFFE6E8FAFFE3E6FAFFE0E3F9FFDEE1F8FFDCDFF8FFDCDFF8FFD9DCF8FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF4A70D6FFA9C4FEFF77A1FEFF4A70D6FFFFFFFFFF9BA1DDFFDFE2F9FF9199D6FFDADDF8FF8A92D1FFD9DBF7FF8A92D1FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF4A70D6FFA9C4FEFF77A1FEFF4A70D6FFFFFFFFFF959DD9FFDFE2F9FF8D94D3FFDADDF8FF8A92D1FFD9DBF7FF8B92D1FFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF446AD3FFA5C0FFFF719CFFFF446AD3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF2F3F7700FFFFFF00FFFFFFFF3F65D1FF3F65D0FF3F65D0FF3E64D1FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F77FF2F3F7700FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF All False False None False Regular * False False None False Regular PTREARN_CODE False False None False Regular PTREARN_SHORT_DESC False True None False Regular PTREARN_LONG_DESC False False None False Regular PTREARN_RATE_IND False False None False Regular PTREARN_RATE False False None False Regular PTREARN_MULT_FACTOR False False None False Regular PTREARN_TYPE_IND False False None False Regular PTREARN_CASH_IND False False None False Regular PTREARN_SHFT_DIFF_IND False False None False Regular PTREARN_TAX_METHOD_IND False False None False Regular PTREARN_LEAV_CODE_TAKEN False False None False Regular PTREARN_LEAV_CODE_EARNED False False None False Regular PTREARN_LEAV_PRORATION_IND False False None False Regular PTREARN_LEAV_MINIMUM_IND False False None False Regular PTREARN_ECLD_IND False False None False Regular PTREARN_BASE_SAL_IND False False None False Regular PTREARN_EXCEPTION_IND False False None False Regular PTREARN_EXPENDED_BUD_IND False False None False Regular PTREARN_UNIT_IND False False None False Regular PTREARN_LONGEVITY_IND False False None False Regular PTREARN_FLSA_HRS_IND False False None False Regular PTREARN_FLSA_AMT_IND False False None False Regular PTREARN_RUCL_CODE False False None False Regular PTREARN_1099_CODE False False None False Regular PTREARN_PENSIONABLE_HRS_IND False False None False Regular PTREARN_FRINGE_IND False False None False Regular PTREARN_ACTIVITY_DATE False False None False Regular PTREARN_STIPEND_IND False False None False Regular PTREARN_ERGR_CODE False False None False Regular PTREARN_SPECIAL_COMP_IND False False None False Regular PTREARN_WEB_DISP_IND False False None False Regular PTREARN_NOT_DETERMINED_IND False False None False Regular PTREARN_OSHA_HRS_IND False False None False Regular PTREARN_MIS_ADDL_EARN_IND False False None False Regular PTREARN_RUCL_CODE_FRNG False False None False Regular PTREARN_FMLA_ELIGIBLE_HRS_IND False False None False Regular PTREARN_FMLA_USAGE_HRS_IND False False None False Regular PTREARN_DISP_WEB_PAYSTUB_IND False False None False Regular PTREARN_SURROGATE_ID False False None False Regular PTREARN_VERSION False False None False Regular PTREARN_USER_ID False False None False Regular PTREARN_DATA_ORIGIN False False None False Regular PTREARN_VPDI_CODE False False None False Regular
Subquery GRANT_INFO False False False False False 934, 16, 250, 200 False True Fixed3D Subquery True 00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFFCECECEFF000000FFCECECE00FFFFFFFF61616100FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF00000000FFFFFF00FFFFFF00FFFFFFFFCF7B7BFFE62B2BFFED0707FFA43232FFE4E3E300FFFFFF00FFFFFF00FFFFFFFF62553300FFFFFFFF837863FF000000FF6C6C6C00FFFFFF00FFFFFFFFCE8686FFEF8383FFFF7979FFFF0C0DFFFB0000FF92565600FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFFC55151FFFF8180FFFF7D7FFFEA282DFFAD431CFF7F5B16FF638B5CFFD9DED900FFFFFFFFCECECEFF000000FF000000FF000000FFCECECE00FFFFFF00FFFFFFFFAB8F8FFFE55D5DFFFD3E48FF97562CFF8EFB91FF6AE142FF6BDB31FF59864900FFFFFFFF000000FFE5E5E5FFFFFFFFFFE5E5E5FF00000000FFFFFF00FFFFFF00FFFFFFFFAA656EFF902D1AFF6EDD4EFF9AFF68FF86E950FF5FCC33FF52C533FF6F8472FF000000FFCECECEFFFFFFFFFFB9B9B9FF000000FF95959500FFFFFF00FFFFFFFFDE9D68FFB4A109FF5DC331FF71DD3BFF4AC13AFF06A135FF099333FF55655BFFCECECEFF000000FF000000FF00000000FFFFFFFF00000000FFFFFFFFF9B494FFFDDD08FFFFE300FFA99F08FF37B52EFF059D34FF009837FF26513AFFE1E1E100FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFFE99522FFFFCC00FFFFC500FFF99A00FFB67B0AFF896211FF415144FFC0C0C000FFFFFFFF000000FF000000FF000000FF000000FF00000000FFFFFF00FFFFFFFFCA9A7DFFF8A601FFFFA200FFFF7400FFFF6700FF8D4D3B00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFF00000000FFFFFF00FFFFFF00FFFFFFFFB88050FFCE5D00FFCF5100FF8A3C19FFCCCCCC00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFFFF00000000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF All False False None False Regular * False False None False Regular FUND False False None False Regular GRNT False True None False Regular GRNT_TITLE False True None False Regular PROJ_START False True None False Regular PROJ_END False True None False Regular
5056dc57-0554-4dda-9943-bcbcb6a88ff9 1c9663a5-fcf8-4a35-a64e-fee0b46ddc6e RightJoin 3 True True True 1 3acfa5b1-3566-41f6-9544-0c0ac7fd9bfe a24a368f-a437-43f5-a7e0-bb213a38da6d Equal 1 Solid Line ArrowSolid And d2ac79af-fdb8-4962-a6a2-3bb19a76a321 1b9ddab0-ad2f-4f14-97b7-86d9f83b6ae9 Equal 1 Solid Line ArrowSolid And e4843428-1c71-4891-8a63-1db6186d2138 0dc6b829-c890-4cd0-baee-3890819c39a1 Equal 1 Solid Line ArrowSolid And 3435843a-3a76-413f-b475-ad724abeab6f 5056dc57-0554-4dda-9943-bcbcb6a88ff9 RightJoin 3 True True True 1 cdbd607a-81b8-49f2-b4b3-6ef11073cbe2 3acfa5b1-3566-41f6-9544-0c0ac7fd9bfe Equal 1 Solid Line ArrowSolid And fc04e19e-427a-4bba-88bf-0e0d6d500e78 d2ac79af-fdb8-4962-a6a2-3bb19a76a321 Equal 1 Solid Line ArrowSolid And bb412572-1193-4520-a998-43154ef77772 e4843428-1c71-4891-8a63-1db6186d2138 Equal 1 Solid Line ArrowSolid And 73180303-e5cc-4cd9-a5cf-9795571f1d9e 3435843a-3a76-413f-b475-ad724abeab6f InnerJoin 1 True True True 1 b4de326c-10a1-4e9f-872f-f514518b0f84 cdbd607a-81b8-49f2-b4b3-6ef11073cbe2 Equal 1 Solid Line ArrowSolid And 3435843a-3a76-413f-b475-ad724abeab6f 5ab4b82f-53ab-4e8f-a143-707c46010ade InnerJoin 1 True True True 1 81aa7ed2-5e0b-4446-b081-503f2c617c71 e7635bc6-483e-429a-9a84-eee0d469d5ee Equal 1 Solid Line ArrowSolid And 3435843a-3a76-413f-b475-ad724abeab6f 999b1468-99cf-48d6-8a8c-401de8189e92 LeftJoin 1 True True True 1 abd3f4f0-0b03-4168-875c-a96b4cb4edb5 0b77ba92-ac59-497c-896d-b5711cab42d2 Equal 1 Solid Line ArrowSolid And True 131, 440, 100, 50 0, 0, 16, 16 Regular Window False Oracle False False FNJWT RPTP.ALASKA.EDU FNJWT False 2020-10-22T23:10:55.0127570 Default 1521 Client true SQL (Oracle) ֓~4pODo]r6[
#ϸ_A*[@n`Sm-hxN CD~ ,
m%4"fGRy3ZalMCg$\GY&>"ab#FV"$v[apCݨm3!