Model Directory Data Upload
| Object Name | Object Type | Layer Name |
|---|---|---|
| APRCRVW | TABLE | Default |
| APRDRVW | TABLE | Default |
| APRERVW | TABLE | Default |
| APRSRVW | TABLE | Default |
Table APRCRVW
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| APRCRVW_PIDM | APRCRVW_PIDM | NUMBER(8,0) | No | * | |
| APRCRVW_DSRC_CODE | APRCRVW_DSRC_CODE | VARCHAR2(10) | No | * | * |
| APRCRVW_LOAD_DATE | APRCRVW_LOAD_DATE | DATE | No | * | |
| APRCRVW_ACCEPTED_IND | APRCRVW_ACCEPTED_IND | VARCHAR2(1) | No | ||
| APRCRVW_ACTIVITY_DATE | APRCRVW_ACTIVITY_DATE | DATE | No | ||
| APRCRVW_USER | APRCRVW_USER | VARCHAR2(30) | No | ||
| APRCRVW_SEQ_NO | APRCRVW_SEQ_NO | NUMBER(2,0) | No | * | |
| APRCRVW_SOURCE_DATE | APRCRVW_SOURCE_DATE | DATE | No | ||
| APRCRVW_LAST_NAME | APRCRVW_LAST_NAME | VARCHAR2(25) | Yes | ||
| APRCRVW_FIRST_NAME | APRCRVW_FIRST_NAME | VARCHAR2(15) | Yes | ||
| APRCRVW_MI | APRCRVW_MI | VARCHAR2(1) | Yes | ||
| APRCRVW_SEX | APRCRVW_SEX | VARCHAR2(1) | Yes | ||
| APRCRVW_BIRTH_DATE | APRCRVW_BIRTH_DATE | DATE | Yes | ||
| APRCRVW_SSN | APRCRVW_SSN | VARCHAR2(9) | Yes | ||
| APRCRVW_ATYP_CODE | APRCRVW_ATYP_CODE | VARCHAR2(2) | Yes | ||
| APRCRVW_XREF_CODE | APRCRVW_XREF_CODE | VARCHAR2(3) | Yes | ||
| APRCRVW_CHLD_PIDM | APRCRVW_CHLD_PIDM | NUMBER(8,0) | Yes | ||
| APRCRVW_DISP_WEB_IND | APRCRVW_DISP_WEB_IND | VARCHAR2(1) | Yes | ||
| APRCRVW_DECEASED_IND | APRCRVW_DECEASED_IND | VARCHAR2(1) | Yes | ||
| APRCRVW_DECEASED_DATE | APRCRVW_DECEASED_DATE | DATE | Yes | ||
| APRCRVW_OK_FOR_NOTES_IND | APRCRVW_OK_FOR_NOTES_IND | VARCHAR2(1) | Yes | ||
| APRCRVW_OTHR_PIDM | APRCRVW_OTHR_PIDM | NUMBER(8,0) | Yes | ||
| APRCRVW_OTHR_XREF_CODE | APRCRVW_OTHR_XREF_CODE | VARCHAR2(3) | Yes | ||
| APRCRVW_COMMENT | APRCRVW_COMMENT | LONG | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| APRCRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_APRCRVW | Unique | APRCRVW_PIDM |
| PK_APRCRVW | Unique | APRCRVW_DSRC_CODE |
| PK_APRCRVW | Unique | APRCRVW_LOAD_DATE |
| PK_APRCRVW | Unique | APRCRVW_SEQ_NO |
Table APRDRVWTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| APRDRVW_PIDM | APRDRVW_PIDM | NUMBER(8,0) | No | * | |
| APRDRVW_DSRC_CODE | APRDRVW_DSRC_CODE | VARCHAR2(10) | No | * | * |
| APRDRVW_LOAD_DATE | APRDRVW_LOAD_DATE | DATE | No | * | |
| APRDRVW_ACCEPTED_IND | APRDRVW_ACCEPTED_IND | VARCHAR2(1) | No | ||
| APRDRVW_ACTIVITY_DATE | APRDRVW_ACTIVITY_DATE | DATE | No | ||
| APRDRVW_USER | APRDRVW_USER | VARCHAR2(30) | No | ||
| APRDRVW_SEQ_NO | APRDRVW_SEQ_NO | NUMBER(2,0) | No | * | |
| APRDRVW_SOURCE_DATE | APRDRVW_SOURCE_DATE | DATE | No | ||
| APRDRVW_SBGI_CODE | APRDRVW_SBGI_CODE | VARCHAR2(6) | Yes | ||
| APRDRVW_INST_NAME | APRDRVW_INST_NAME | VARCHAR2(60) | Yes | ||
| APRDRVW_DEG_NAME | APRDRVW_DEG_NAME | VARCHAR2(15) | Yes | ||
| APRDRVW_MAJOR_NAME | APRDRVW_MAJOR_NAME | VARCHAR2(60) | Yes | ||
| APRDRVW_MAJOR_NAME2 | APRDRVW_MAJOR_NAME2 | VARCHAR2(60) | Yes | ||
| APRDRVW_MAJOR_NAME3 | APRDRVW_MAJOR_NAME3 | VARCHAR2(60) | Yes | ||
| APRDRVW_DEGC_CODE | APRDRVW_DEGC_CODE | VARCHAR2(6) | Yes | ||
| APRDRVW_DATE | APRDRVW_DATE | DATE | Yes | ||
| APRDRVW_ACYR_CODE | APRDRVW_ACYR_CODE | VARCHAR2(4) | Yes | ||
| APRDRVW_MAJR_CODE | APRDRVW_MAJR_CODE | VARCHAR2(4) | Yes | ||
| APRDRVW_MAJR_CODE2 | APRDRVW_MAJR_CODE2 | VARCHAR2(4) | Yes | ||
| APRDRVW_MAJR_CODE3 | APRDRVW_MAJR_CODE3 | VARCHAR2(4) | Yes | ||
| APRDRVW_COLL_CODE | APRDRVW_COLL_CODE | VARCHAR2(2) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| APRDRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_APRDRVW | Unique | APRDRVW_PIDM |
| PK_APRDRVW | Unique | APRDRVW_DSRC_CODE |
| PK_APRDRVW | Unique | APRDRVW_LOAD_DATE |
| PK_APRDRVW | Unique | APRDRVW_SEQ_NO |
Table APRERVWTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| APRERVW_PIDM | APRERVW_PIDM | NUMBER(8,0) | No | * | |
| APRERVW_DSRC_CODE | APRERVW_DSRC_CODE | VARCHAR2(10) | No | * | * |
| APRERVW_LOAD_DATE | APRERVW_LOAD_DATE | DATE | No | * | |
| APRERVW_ACCEPTED_IND | APRERVW_ACCEPTED_IND | VARCHAR2(1) | No | ||
| APRERVW_ACTIVITY_DATE | APRERVW_ACTIVITY_DATE | DATE | No | ||
| APRERVW_USER | APRERVW_USER | VARCHAR2(30) | No | ||
| APRERVW_SEQ_NO | APRERVW_SEQ_NO | NUMBER(2,0) | No | * | |
| APRERVW_SOURCE_DATE | APRERVW_SOURCE_DATE | DATE | No | ||
| APRERVW_EMPR_NAME | APRERVW_EMPR_NAME | VARCHAR2(60) | Yes | ||
| APRERVW_JOBC_CODE | APRERVW_JOBC_CODE | VARCHAR2(3) | Yes | ||
| APRERVW_EMPL_POSITION | APRERVW_EMPL_POSITION | VARCHAR2(60) | Yes | ||
| APRERVW_FROM_DATE | APRERVW_FROM_DATE | DATE | Yes | ||
| APRERVW_TO_DATE | APRERVW_TO_DATE | DATE | Yes | ||
| APRERVW_EMPR_PIDM | APRERVW_EMPR_PIDM | NUMBER(8,0) | Yes | ||
| APRERVW_SICC_CODE | APRERVW_SICC_CODE | VARCHAR2(4) | Yes | ||
| APRERVW_XREF_CODE | APRERVW_XREF_CODE | VARCHAR2(3) | Yes | ||
| APRERVW_EMPS_CODE | APRERVW_EMPS_CODE | VARCHAR2(1) | Yes | ||
| APRERVW_WKLY_HOURS | APRERVW_WKLY_HOURS | NUMBER(5,2) | Yes | ||
| APRERVW_PRIMARY_IND | APRERVW_PRIMARY_IND | VARCHAR2(1) | Yes | ||
| APRERVW_JOBC_CODE2 | APRERVW_JOBC_CODE2 | VARCHAR2(3) | Yes | ||
| APRERVW_JOBC_CODE3 | APRERVW_JOBC_CODE3 | VARCHAR2(3) | Yes | ||
| APRERVW_JOBC_CODE4 | APRERVW_JOBC_CODE4 | VARCHAR2(3) | Yes | ||
| APRERVW_MG_IND | APRERVW_MG_IND | VARCHAR2(1) | Yes | ||
| APRERVW_ATYP_CODE | APRERVW_ATYP_CODE | VARCHAR2(2) | Yes | ||
| APRERVW_ASRC_CODE | APRERVW_ASRC_CODE | VARCHAR2(4) | Yes | ||
| APRERVW_ADDR_FROM_DATE | APRERVW_ADDR_FROM_DATE | DATE | Yes | ||
| APRERVW_ADDR_TO_DATE | APRERVW_ADDR_TO_DATE | DATE | Yes | ||
| APRERVW_STREET_LINE1 | APRERVW_STREET_LINE1 | VARCHAR2(30) | Yes | ||
| APRERVW_STREET_LINE2 | APRERVW_STREET_LINE2 | VARCHAR2(30) | Yes | ||
| APRERVW_STREET_LINE3 | APRERVW_STREET_LINE3 | VARCHAR2(30) | Yes | ||
| APRERVW_CITY | APRERVW_CITY | VARCHAR2(20) | Yes | ||
| APRERVW_STAT_CODE | APRERVW_STAT_CODE | VARCHAR2(3) | Yes | ||
| APRERVW_ZIP | APRERVW_ZIP | VARCHAR2(10) | Yes | ||
| APRERVW_CNTY_CODE | APRERVW_CNTY_CODE | VARCHAR2(5) | Yes | ||
| APRERVW_NATN_CODE | APRERVW_NATN_CODE | VARCHAR2(5) | Yes | ||
| APRERVW_DELIVERY_POINT | APRERVW_DELIVERY_POINT | NUMBER(2,0) | Yes | ||
| APRERVW_CORRECTION_DIGIT | APRERVW_CORRECTION_DIGIT | NUMBER(1,0) | Yes | ||
| APRERVW_CARRIER_ROUTE | APRERVW_CARRIER_ROUTE | VARCHAR2(4) | Yes | ||
| APRERVW_TELE_CODE | APRERVW_TELE_CODE | VARCHAR2(4) | Yes | ||
| APRERVW_PHONE_AREA | APRERVW_PHONE_AREA | VARCHAR2(3) | Yes | ||
| APRERVW_PHONE_NUMBER | APRERVW_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| APRERVW_PHONE_EXT | APRERVW_PHONE_EXT | VARCHAR2(4) | Yes | ||
| APRERVW_FAX_TELE_CODE | APRERVW_FAX_TELE_CODE | VARCHAR2(4) | Yes | ||
| APRERVW_FAX_AREA | APRERVW_FAX_AREA | VARCHAR2(3) | Yes | ||
| APRERVW_FAX_NUMBER | APRERVW_FAX_NUMBER | VARCHAR2(7) | Yes | ||
| APRERVW_EMAIL_CODE | APRERVW_EMAIL_CODE | VARCHAR2(4) | Yes | ||
| APRERVW_EMAIL_ADDRESS | APRERVW_EMAIL_ADDRESS | VARCHAR2(90) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| APRERVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_APRERVW | Unique | APRERVW_PIDM |
| PK_APRERVW | Unique | APRERVW_DSRC_CODE |
| PK_APRERVW | Unique | APRERVW_LOAD_DATE |
| PK_APRERVW | Unique | APRERVW_SEQ_NO |
Table APRSRVWTable Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| APRSRVW_PIDM | APRSRVW_PIDM | NUMBER(8,0) | No | * | |
| APRSRVW_DSRC_CODE | APRSRVW_DSRC_CODE | VARCHAR2(10) | No | * | * |
| APRSRVW_LOAD_DATE | APRSRVW_LOAD_DATE | DATE | No | * | |
| APRSRVW_ACCEPTED_IND | APRSRVW_ACCEPTED_IND | VARCHAR2(1) | No | ||
| APRSRVW_ACTIVITY_DATE | APRSRVW_ACTIVITY_DATE | DATE | No | ||
| APRSRVW_USER | APRSRVW_USER | VARCHAR2(30) | No | ||
| APRSRVW_SEQ_NO | APRSRVW_SEQ_NO | NUMBER(2,0) | No | * | |
| APRSRVW_SOURCE_DATE | APRSRVW_SOURCE_DATE | DATE | No | ||
| APRSRVW_MARS_IND | APRSRVW_MARS_IND | VARCHAR2(1) | Yes | ||
| APRSRVW_SPS_PIDM | APRSRVW_SPS_PIDM | NUMBER(8,0) | Yes | ||
| APRSRVW_LAST_NAME | APRSRVW_LAST_NAME | VARCHAR2(60) | Yes | ||
| APRSRVW_FIRST_NAME | APRSRVW_FIRST_NAME | VARCHAR2(15) | Yes | ||
| APRSRVW_MI | APRSRVW_MI | VARCHAR2(15) | Yes | ||
| APRSRVW_MAIDEN_NAME | APRSRVW_MAIDEN_NAME | VARCHAR2(60) | Yes | ||
| APRSRVW_NAME_PREFIX | APRSRVW_NAME_PREFIX | VARCHAR2(20) | Yes | ||
| APRSRVW_NAME_SUFFIX | APRSRVW_NAME_SUFFIX | VARCHAR2(20) | Yes | ||
| APRSRVW_BIRTH_DATE | APRSRVW_BIRTH_DATE | DATE | Yes | ||
| APRSRVW_SPS_COMMENT | APRSRVW_SPS_COMMENT | VARCHAR2(60) | Yes | ||
| APRSRVW_MRTL_CODE | APRSRVW_MRTL_CODE | VARCHAR2(1) | Yes | ||
| APRSRVW_MRTL_START_DATE | APRSRVW_MRTL_START_DATE | DATE | Yes | ||
| APRSRVW_MRTL_END_DATE | APRSRVW_MRTL_END_DATE | DATE | Yes | ||
| APRSRVW_DEAD_IND | APRSRVW_DEAD_IND | VARCHAR2(1) | Yes | ||
| APRSRVW_DEAD_DATE | APRSRVW_DEAD_DATE | DATE | Yes | ||
| APRSRVW_XREF_CODE | APRSRVW_XREF_CODE | VARCHAR2(3) | Yes | ||
| APRSRVW_ATYP_CODE | APRSRVW_ATYP_CODE | VARCHAR2(2) | Yes | ||
| APRSRVW_ASRC_CODE | APRSRVW_ASRC_CODE | VARCHAR2(4) | Yes | ||
| APRSRVW_ADDR_FROM_DATE | APRSRVW_ADDR_FROM_DATE | DATE | Yes | ||
| APRSRVW_ADDR_TO_DATE | APRSRVW_ADDR_TO_DATE | DATE | Yes | ||
| APRSRVW_STREET_LINE1 | APRSRVW_STREET_LINE1 | VARCHAR2(30) | Yes | ||
| APRSRVW_STREET_LINE2 | APRSRVW_STREET_LINE2 | VARCHAR2(30) | Yes | ||
| APRSRVW_STREET_LINE3 | APRSRVW_STREET_LINE3 | VARCHAR2(30) | Yes | ||
| APRSRVW_CITY | APRSRVW_CITY | VARCHAR2(20) | Yes | ||
| APRSRVW_STAT_CODE | APRSRVW_STAT_CODE | VARCHAR2(3) | Yes | ||
| APRSRVW_ZIP | APRSRVW_ZIP | VARCHAR2(10) | Yes | ||
| APRSRVW_CNTY_CODE | APRSRVW_CNTY_CODE | VARCHAR2(5) | Yes | ||
| APRSRVW_NATN_CODE | APRSRVW_NATN_CODE | VARCHAR2(5) | Yes | ||
| APRSRVW_DELIVERY_POINT | APRSRVW_DELIVERY_POINT | NUMBER(2,0) | Yes | ||
| APRSRVW_CORRECTION_DIGIT | APRSRVW_CORRECTION_DIGIT | NUMBER(1,0) | Yes | ||
| APRSRVW_CARRIER_ROUTE | APRSRVW_CARRIER_ROUTE | VARCHAR2(4) | Yes | ||
| APRSRVW_TELE_CODE | APRSRVW_TELE_CODE | VARCHAR2(4) | Yes | ||
| APRSRVW_PHONE_AREA | APRSRVW_PHONE_AREA | VARCHAR2(3) | Yes | ||
| APRSRVW_PHONE_NUMBER | APRSRVW_PHONE_NUMBER | VARCHAR2(7) | Yes | ||
| APRSRVW_PHONE_EXT | APRSRVW_PHONE_EXT | VARCHAR2(4) | Yes | ||
| APRSRVW_FAX_TELE_CODE | APRSRVW_FAX_TELE_CODE | VARCHAR2(4) | Yes | ||
| APRSRVW_FAX_AREA | APRSRVW_FAX_AREA | VARCHAR2(3) | Yes | ||
| APRSRVW_FAX_NUMBER | APRSRVW_FAX_NUMBER | VARCHAR2(7) | Yes | ||
| APRSRVW_EMAIL_CODE | APRSRVW_EMAIL_CODE | VARCHAR2(4) | Yes | ||
| APRSRVW_EMAIL_ADDRESS | APRSRVW_EMAIL_ADDRESS | VARCHAR2(90) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| APRSRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_APRSRVW | Unique | APRSRVW_PIDM |
| PK_APRSRVW | Unique | APRSRVW_DSRC_CODE |
| PK_APRSRVW | Unique | APRSRVW_LOAD_DATE |
| PK_APRSRVW | Unique | APRSRVW_SEQ_NO |