Model Applicant
| Object Name | Object Type | Layer Name |
|---|---|---|
| NBBPOSN | TABLE | Default |
| NTRPCLS | TABLE | Default |
| PABAPPL | TABLE | Default |
| PABPFAC | TABLE | Default |
| PABREQU | TABLE | Default |
| PARAPIN | TABLE | Default |
| PARAPST | TABLE | Default |
| PARCDES | TABLE | Default |
| PARPCER | TABLE | Default |
| PARPCMT | TABLE | Default |
| PARPCON | TABLE | Default |
| PARPDEG | TABLE | Default |
| PARPEND | TABLE | Default |
| PARPEXM | TABLE | Default |
| PARPMAJ | TABLE | Default |
| PARPMIN | TABLE | Default |
| PARPSKL | TABLE | Default |
| PEBEMPL | TABLE | Default |
| PTVASRC | TABLE | Default |
| PTVESKL | TABLE | Default |
| SPBPERS | TABLE | Default |
| SPRIDEN | TABLE | Default |

Table NBBPOSN
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| NBBPOSN_POSN | NBBPOSN_POSN | VARCHAR2(6) | No | * | |
| NBBPOSN_STATUS | NBBPOSN_STATUS | VARCHAR2(1) | No | ||
| NBBPOSN_TITLE | NBBPOSN_TITLE | VARCHAR2(30) | No | ||
| NBBPOSN_PLOC_CODE | NBBPOSN_PLOC_CODE | VARCHAR2(6) | Yes | ||
| NBBPOSN_BEGIN_DATE | NBBPOSN_BEGIN_DATE | DATE | No | ||
| NBBPOSN_END_DATE | NBBPOSN_END_DATE | DATE | Yes | ||
| NBBPOSN_TYPE | NBBPOSN_TYPE | VARCHAR2(1) | No | ||
| NBBPOSN_PCLS_CODE | NBBPOSN_PCLS_CODE | VARCHAR2(5) | No | * | |
| NBBPOSN_ECLS_CODE | NBBPOSN_ECLS_CODE | VARCHAR2(2) | No | * | |
| NBBPOSN_POSN_REPORTS | NBBPOSN_POSN_REPORTS | VARCHAR2(6) | Yes | ||
| NBBPOSN_AUTH_NUMBER | NBBPOSN_AUTH_NUMBER | VARCHAR2(9) | Yes | ||
| NBBPOSN_TABLE | NBBPOSN_TABLE | VARCHAR2(2) | No | ||
| NBBPOSN_GRADE | NBBPOSN_GRADE | VARCHAR2(5) | No | ||
| NBBPOSN_STEP | NBBPOSN_STEP | NUMBER(3,0) | Yes | ||
| NBBPOSN_APPT_PCT | NBBPOSN_APPT_PCT | NUMBER(5,2) | No | ||
| NBBPOSN_CIPC_CODE | NBBPOSN_CIPC_CODE | VARCHAR2(6) | Yes | ||
| NBBPOSN_ROLL_IND | NBBPOSN_ROLL_IND | VARCHAR2(1) | No | ||
| NBBPOSN_COAS_CODE | NBBPOSN_COAS_CODE | VARCHAR2(1) | Yes | ||
| NBBPOSN_ACTIVITY_DATE | NBBPOSN_ACTIVITY_DATE | DATE | No | ||
| NBBPOSN_SGRP_CODE | NBBPOSN_SGRP_CODE | VARCHAR2(6) | Yes | ||
| NBBPOSN_PGRP_CODE | NBBPOSN_PGRP_CODE | VARCHAR2(4) | Yes | ||
| NBBPOSN_WKSH_CODE | NBBPOSN_WKSH_CODE | VARCHAR2(4) | Yes | * | |
| NBBPOSN_PREMIUM_ROLL_IND | NBBPOSN_PREMIUM_ROLL_IND | VARCHAR2(1) | No | ||
| NBBPOSN_PFOC_CODE | NBBPOSN_PFOC_CODE | VARCHAR2(3) | Yes | ||
| NBBPOSN_PNOC_CODE | NBBPOSN_PNOC_CODE | VARCHAR2(6) | Yes | ||
| NBBPOSN_DOTT_CODE | NBBPOSN_DOTT_CODE | VARCHAR2(11) | Yes | ||
| NBBPOSN_CHANGE_DATE_TIME | NBBPOSN_CHANGE_DATE_TIME | DATE | No | ||
| NBBPOSN_CALIF_TYPE | NBBPOSN_CALIF_TYPE | VARCHAR2(1) | Yes | ||
| NBBPOSN_EXEMPT_IND | NBBPOSN_EXEMPT_IND | VARCHAR2(1) | No | ||
| NBBPOSN_JBLN_CODE | NBBPOSN_JBLN_CODE | VARCHAR2(6) | Yes | ||
| NBBPOSN_BARG_CODE | NBBPOSN_BARG_CODE | VARCHAR2(2) | Yes | ||
| NBBPOSN_PROBATION_UNITS | NBBPOSN_PROBATION_UNITS | NUMBER(3,0) | Yes | ||
| NBBPOSN_COMMENT | NBBPOSN_COMMENT | VARCHAR2(2000) | Yes | ||
| NBBPOSN_ACCRUE_SENIORITY_IND | NBBPOSN_ACCRUE_SENIORITY_IND | VARCHAR2(1) | No | ||
| NBBPOSN_JOBP_CODE | NBBPOSN_JOBP_CODE | VARCHAR2(5) | Yes | ||
| NBBPOSN_BPRO_CODE | NBBPOSN_BPRO_CODE | VARCHAR2(6) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| NBBPOSN_WKSH_CODE | NTVWKSH_CODE | NTVWKSH |
| NBBPOSN_PCLS_CODE | NTRPCLS_CODE | NTRPCLS |
| NBBPOSN_PCLS_CODE | PERSNBL_PCLS_CODE | PERSNBL |
| NBBPOSN_ECLS_CODE | PTRECLS_CODE | PTRECLS |
| NBBPOSN_ECLS_CODE | PEBEMPL_ECLS_CODE | PEBEMPL |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| NBBPOSN_BPRO_INDEX | NBBPOSN_BPRO_CODE | |
| PK_NBBPOSN | Unique | NBBPOSN_POSN |