Model Time Entry
| Object Name | Object Type | Layer Name |
|---|---|---|
| NBRBJOB | TABLE | Default |
| NBRJLBD | TABLE | Default |
| NBRJOBS | TABLE | Default |
| PERDAYH | TABLE | Default |
| PERDAYS | TABLE | Default |
| PEREARH | TABLE | Default |
| PEREARN | TABLE | Default |
| PERELBD | TABLE | Default |
| PERELBH | TABLE | Default |
| PERHOUH | TABLE | Default |
| PERHOUR | TABLE | Default |
| PERJOBH | TABLE | Default |
| PERJOBS | TABLE | Main Objects |
| PERLVTK | TABLE | Default |
| PERROUH | TABLE | Default |
| PERROUT | TABLE | Default |
| PERTETH | TABLE | Main Objects |
| PERTITH | TABLE | Default |
| PERTITO | TABLE | Default |
| PTRCALN | TABLE | Default |
| PTRLVAS | TABLE | Default |
| PTVLCAT | TABLE | Default |
| SPRIDEN | TABLE | Default |
Table NBRBJOB
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NBRBJOB_PIDM | NBRBJOB_PIDM | NUMBER(8,0) | No | * | * |
| NBRBJOB_POSN | NBRBJOB_POSN | VARCHAR2(6) | No | * | * |
| NBRBJOB_SUFF | NBRBJOB_SUFF | VARCHAR2(2) | No | * | * |
| NBRBJOB_BEGIN_DATE | NBRBJOB_BEGIN_DATE | DATE | No | ||
| NBRBJOB_END_DATE | NBRBJOB_END_DATE | DATE | Yes | ||
| NBRBJOB_DEFER_BAL | NBRBJOB_DEFER_BAL | NUMBER(11,2) | No | ||
| NBRBJOB_CONTRACT_TYPE | NBRBJOB_CONTRACT_TYPE | VARCHAR2(1) | No | ||
| NBRBJOB_SALARY_ENCUMBRANCE | NBRBJOB_SALARY_ENCUMBRANCE | NUMBER(11,2) | No | ||
| NBRBJOB_CONTRACT_BEGIN_DATE | NBRBJOB_CONTRACT_BEGIN_DATE | DATE | Yes | ||
| NBRBJOB_CONTRACT_END_DATE | NBRBJOB_CONTRACT_END_DATE | DATE | Yes | ||
| NBRBJOB_TOTAL_CONTRACT_HRS | NBRBJOB_TOTAL_CONTRACT_HRS | NUMBER(6,2) | Yes | ||
| NBRBJOB_TOTAL_ENCUMBRANCE_HRS | NBRBJOB_TOTAL_ENCUMBRANCE_HRS | NUMBER(6,2) | Yes | ||
| NBRBJOB_STEP_INCR_MON | NBRBJOB_STEP_INCR_MON | VARCHAR2(2) | Yes | ||
| NBRBJOB_STEP_INCR_DAY | NBRBJOB_STEP_INCR_DAY | VARCHAR2(2) | Yes | ||
| NBRBJOB_COAS_CODE | NBRBJOB_COAS_CODE | VARCHAR2(1) | Yes | ||
| NBRBJOB_ACTIVITY_DATE | NBRBJOB_ACTIVITY_DATE | DATE | No | ||
| NBRBJOB_ACCRUE_LEAVE_IND | NBRBJOB_ACCRUE_LEAVE_IND | VARCHAR2(1) | No | ||
| NBRBJOB_CIVIL_SERVICE_IND | NBRBJOB_CIVIL_SERVICE_IND | VARCHAR2(1) | Yes | ||
| NBRBJOB_ENCUMBRANCE_CHANGE_IND | NBRBJOB_ENCUMBRANCE_CHANGE_IND | VARCHAR2(1) | No | ||
| NBRBJOB_FRINGE_ENCUMBRANCE | NBRBJOB_FRINGE_ENCUMBRANCE | NUMBER(11,2) | Yes | ||
| NBRBJOB_IPEDS_REPT_IND | NBRBJOB_IPEDS_REPT_IND | VARCHAR2(1) | No | ||
| NBRBJOB_FACL_STATSCAN_REPT_IND | NBRBJOB_FACL_STATSCAN_REPT_IND | VARCHAR2(1) | No | ||
| NBRBJOB_PROBATION_BEGIN_DATE | NBRBJOB_PROBATION_BEGIN_DATE | DATE | Yes | ||
| NBRBJOB_PROBATION_END_DATE | NBRBJOB_PROBATION_END_DATE | DATE | Yes | ||
| NBRBJOB_PROBATION_UNITS | NBRBJOB_PROBATION_UNITS | NUMBER(3,0) | Yes | ||
| NBRBJOB_ELIGIBLE_DATE | NBRBJOB_ELIGIBLE_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NBRBJOB_POSN | NBBPOSN_POSN | NBBPOSN |
| NBRBJOB_PIDM | PERJLEV_PIDM | PERJLEV |
| NBRBJOB_POSN | PERJLEV_POSN | PERJLEV |
| NBRBJOB_SUFF | PERJLEV_SUFF | PERJLEV |
| NBRBJOB_PIDM | NBRJOBS_PIDM | NBRJOBS |
| NBRBJOB_POSN | NBRJOBS_POSN | NBRJOBS |
| NBRBJOB_SUFF | NBRJOBS_SUFF | NBRJOBS |
| NBRBJOB_PIDM | NBREARN_PIDM | NBREARN |
| NBRBJOB_POSN | NBREARN_POSN | NBREARN |
| NBRBJOB_SUFF | NBREARN_SUFF | NBREARN |
| NBRBJOB_PIDM | NBRJOBS_PIDM | NBRJOBS |
| NBRBJOB_POSN | NBRJOBS_POSN | NBRJOBS |
| NBRBJOB_SUFF | NBRJOBS_SUFF | NBRJOBS |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| NBRBJOB_KEY2_INDEX | NBRBJOB_PIDM | |
| NBRBJOB_KEY2_INDEX | NBRBJOB_CONTRACT_TYPE | |
| NBRBJOB_KEY_INDEX | NBRBJOB_POSN | |
| PK_NBRBJOB | Unique | NBRBJOB_PIDM |
| PK_NBRBJOB | Unique | NBRBJOB_POSN |
| PK_NBRBJOB | Unique | NBRBJOB_SUFF |