Model Web_Management
| Object Name | Object Type | Layer Name |
|---|---|---|
| GOBDIRO | TABLE | Default |
| GOBFNXR | TABLE | Default |
| GOBSRVR | TABLE | Default |
| GOBTPAC | TABLE | Default |
| GORADRL | TABLE | Default |
| GORDADD | TABLE | Default |
| GORDPRF | TABLE | Default |
| GOREMAL | TABLE | Default |
| GORPAUD | TABLE | Default |
| GORPPRM | TABLE | Default |
| GORSRVR | TABLE | Default |
| GORTCTL | TABLE | Default |
| GOVSRVR | VIEW | Default |
| GTVDIRO | TABLE | Default |
| GTVEMAL | TABLE | Default |
| GUBSRVY | TABLE | Default |
| GURSRVQ | TABLE | Default |
| GURSVRL | TABLE | Default |
| GURUPRF | TABLE | Default |
| SPBPERS | TABLE | Default |
| SPBPERS link | User Object | Default |
| SPRADDR | TABLE | Default |
| SPRIDEN | TABLE | Default |
| SPRIDEN link | User Object | Default |
| STVATYP | TABLE | Default |

Table GOBDIRO| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBDIRO_DIRO_CODE | GOBDIRO_DIRO_CODE | VARCHAR2(8) | No | * | * |
| GOBDIRO_DIRECTORY_TYPE | GOBDIRO_DIRECTORY_TYPE | VARCHAR2(1) | No |   |   |
| GOBDIRO_ITEM_TYPE | GOBDIRO_ITEM_TYPE | VARCHAR2(1) | No |   |   |
| GOBDIRO_DISP_PROFILE_IND | GOBDIRO_DISP_PROFILE_IND | VARCHAR2(1) | No |   |   |
| GOBDIRO_UPD_PROFILE_IND | GOBDIRO_UPD_PROFILE_IND | VARCHAR2(1) | No |   |   |
| GOBDIRO_NON_PROFILE_DEF_IND | GOBDIRO_NON_PROFILE_DEF_IND | VARCHAR2(1) | No |   |   |
| GOBDIRO_SYSTEM_REQ_IND | GOBDIRO_SYSTEM_REQ_IND | VARCHAR2(1) | No |   |   |
| GOBDIRO_ACTIVITY_DATE | GOBDIRO_ACTIVITY_DATE | DATE | No |   |   |
| GOBDIRO_SEQ_NO | GOBDIRO_SEQ_NO | NUMBER(2,0) | No |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GOBDIRO_DIRO_CODE | GTVDIRO_CODE | GTVDIRO |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GOBDIRO | Unique | GOBDIRO_DIRO_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| sel_gobdiro_list | C/C++ Function | [F:\BANNER\C\HWPREDIR.PC] | Use (select) |
| sel_gobdiro_list | C/C++ Function | [F:\BANNER\C\BWPREDIR.PC] | Use (select) |
| GOBDIRO | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORDADD | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| GORDPRF | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| GOBDIRO_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Rely On |
| GOBDIROC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (select) |
| GOBDIROC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Use (select) |
| GOBDIRO_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Rely On |
| GOBDIROLISTC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (select)Rely On |
| GOBDIROREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GOBDIRO | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GTVDIRO | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:28:000 |
Table GOBFNXR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBFNXR_FUNCTION | GOBFNXR_FUNCTION | VARCHAR2(30) | No | * |   |
| GOBFNXR_PACKAGE | GOBFNXR_PACKAGE | VARCHAR2(80) | No | * |   |
| GOBFNXR_SYS_REQ_IND | GOBFNXR_SYS_REQ_IND | VARCHAR2(1) | No |   |   |
| GOBFNXR_ACTIVITY_DATE | GOBFNXR_ACTIVITY_DATE | DATE | No |   |   |
| GOBFNXR_USER_ID | GOBFNXR_USER_ID | VARCHAR2(30) | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GOBFNXR | Unique | GOBFNXR_PACKAGE |
| PK_GOBFNXR | Unique | GOBFNXR_FUNCTION |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GOBFNXR | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GOBSRVR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBSRVR_PIDM | GOBSRVR_PIDM | NUMBER(8,0) | No | * |   |
| GOBSRVR_NAME | GOBSRVR_NAME | VARCHAR2(15) | No | * |   |
| GOBSRVR_ACTIVITY_DATE | GOBSRVR_ACTIVITY_DATE | DATE | No |   |   |
| GOBSRVR_USER | GOBSRVR_USER | VARCHAR2(30) | No |   |   |
| GOBSRVR_DECLINED_IND | GOBSRVR_DECLINED_IND | VARCHAR2(1) | No |   |   |
| GOBSRVR_COMPLETE_IND | GOBSRVR_COMPLETE_IND | VARCHAR2(1) | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GOBSRVR | Unique | GOBSRVR_PIDM |
| PK_GOBSRVR | Unique | GOBSRVR_NAME |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSRVR | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORSRVR | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| SPRIDEN | TABLE | "S4B70.SCT.COM".SATURN | Join |
| GOVSRVR | VIEW | "S4B70.SCT.COM".BANINST1 | Use (select) |
| GOBSRVR_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Rely On |
| P_MODIFYRESPONSEHEAD | Package procedure | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (Insert,update) |
| GOBSRVRREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GOBSRVR | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GOBTPAC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBTPAC_PIDM | GOBTPAC_PIDM | NUMBER(8,0) | No | * |   |
| GOBTPAC_PIN_DISABLED_IND | GOBTPAC_PIN_DISABLED_IND | VARCHAR2(1) | No |   |   |
| GOBTPAC_USAGE_ACCEPT_IND | GOBTPAC_USAGE_ACCEPT_IND | VARCHAR2(1) | No |   |   |
| GOBTPAC_ACTIVITY_DATE | GOBTPAC_ACTIVITY_DATE | DATE | No |   |   |
| GOBTPAC_USER | GOBTPAC_USER | VARCHAR2(30) | No |   |   |
| GOBTPAC_PIN | GOBTPAC_PIN | VARCHAR2(6) | Yes |   |   |
| GOBTPAC_PIN_EXP_DATE | GOBTPAC_PIN_EXP_DATE | DATE | Yes |   |   |
| GOBTPAC_EXTERNAL_USER | GOBTPAC_EXTERNAL_USER | VARCHAR2(30) | Yes |   |   |
| GOBTPAC_QUESTION | GOBTPAC_QUESTION | VARCHAR2(90) | Yes |   |   |
| GOBTPAC_RESPONSE | GOBTPAC_RESPONSE | VARCHAR2(30) | Yes |   |   |
| GOBTPAC_INSERT_SOURCE | GOBTPAC_INSERT_SOURCE | VARCHAR2(8) | Yes |   |   |
| GOBTPAC_LDAP_USER | GOBTPAC_LDAP_USER | VARCHAR2(255) | Yes |   |   |
| GOBTPAC_DATA_ORIGIN | GOBTPAC_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| GOBTPAC_KEY_INDEX | Unique | GOBTPAC_EXTERNAL_USER |
| PK_GOBTPAC | Unique | GOBTPAC_PIDM |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GORADRL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORADRL_ATYP_CODE | GORADRL_ATYP_CODE | VARCHAR2(2) | No | * | * |
| GORADRL_ROLE | GORADRL_ROLE | VARCHAR2(30) | No | * |   |
| GORADRL_PRIV_IND | GORADRL_PRIV_IND | VARCHAR2(1) | No |   |   |
| GORADRL_ACTIVITY_DATE | GORADRL_ACTIVITY_DATE | DATE | No |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORADRL_ATYP_CODE | STVATYP_CODE | STVATYP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORADRL | Unique | GORADRL_ATYP_CODE |
| PK_GORADRL | Unique | GORADRL_ROLE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORADRL | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GETSTVATYPC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKALOG | Use (select) |
| GORADRLPRIVC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOADR | Use (select) |
| GORADRLVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWLKOSAD | Use (select) |
| SPRADDRLINKC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOADR | Use (select) |
| STVATYPUPDATEC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOADR | Use (select) |
| STVATYPVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOADR | Use (select) |
| STVATYPVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWLKOSAD | Use (select) |
| UROLE | Package variable | "S4B70.SCT.COM".BANINST1.BWLKOSAD | Rely On |
| F_ROLEPRIV | Package function | "S4B70.SCT.COM".BANINST1.BWGKOADR | Use (select) |
| P_PREF_ADDRESS | Package procedure | "S4B70.SCT.COM".BANINST1.BWAKPREF | Use (select) |
| F_ROLEPRIV | Package function | "S4B70.SCT.COM".BANINST1.BWLKOSAD | Use (select) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORADRL | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| STVATYP | TABLE | "S4B70.SCT.COM".SATURN | Join |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GORDADD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORDADD_DIRO_CODE | GORDADD_DIRO_CODE | VARCHAR2(8) | No | * | * |
| GORDADD_PRIORITY_NO | GORDADD_PRIORITY_NO | NUMBER(1,0) | No | * |   |
| GORDADD_ATYP_CODE | GORDADD_ATYP_CODE | VARCHAR2(2) | Yes |   |   |
| GORDADD_TELE_CODE | GORDADD_TELE_CODE | VARCHAR2(4) | Yes |   |   |
| GORDADD_ACTIVITY_DATE | GORDADD_ACTIVITY_DATE | DATE | No |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORDADD_DIRO_CODE | GOBDIRO_DIRO_CODE | GOBDIRO |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORDADD | Unique | GORDADD_DIRO_CODE |
| PK_GORDADD | Unique | GORDADD_PRIORITY_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| sel_gordadd | C/C++ Function | [F:\BANNER\C\HWPREDIR.PC] | Use (select) |
| sel_gordadd | C/C++ Function | [F:\BANNER\C\BWPREDIR.PC] | Use (select) |
| GORDADD | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORDADD_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Rely On |
| P_GETPHONES | Package procedure | "S4B70.SCT.COM".BANINST1.BWPKEDIR | Use (select) |
| GORDADDC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORDADD | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GOBDIRO | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GORDPRF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORDPRF_PIDM | GORDPRF_PIDM | NUMBER(8,0) | No | * |   |
| GORDPRF_DIRO_CODE | GORDPRF_DIRO_CODE | VARCHAR2(8) | No | * | * |
| GORDPRF_DISP_DIRECTORY_IND | GORDPRF_DISP_DIRECTORY_IND | VARCHAR2(1) | No |   |   |
| GORDPRF_USER_ID | GORDPRF_USER_ID | VARCHAR2(30) | No |   |   |
| GORDPRF_ACTIVITY_DATE | GORDPRF_ACTIVITY_DATE | DATE | No |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORDPRF_DIRO_CODE | GOBDIRO_DIRO_CODE | GOBDIRO |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORDPRF | Unique | GORDPRF_PIDM |
| PK_GORDPRF | Unique | GORDPRF_DIRO_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| sel_gordprf_list | C/C++ Function | [F:\BANNER\C\BWPREDIR.PC] | Use (select) |
| sel_gordprf_list | C/C++ Function | [F:\BANNER\C\HWPREDIR.PC] | Use (select) |
| GORDPRF | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORDPRFC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (select) |
| GORDPRFC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Use (select) |
| GORDPRF_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Rely On |
| GORDPRF_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Rely On |
| P_MODIFYDIROITEM | Package procedure | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (Insert,update) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORDPRF | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GOBDIRO | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GOREMAL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOREMAL_PIDM | GOREMAL_PIDM | NUMBER(8,0) | No | * |   |
| GOREMAL_EMAL_CODE | GOREMAL_EMAL_CODE | VARCHAR2(4) | No | * | * |
| GOREMAL_EMAIL_ADDRESS | GOREMAL_EMAIL_ADDRESS | VARCHAR2(90) | No | * |   |
| GOREMAL_STATUS_IND | GOREMAL_STATUS_IND | VARCHAR2(1) | No |   |   |
| GOREMAL_PREFERRED_IND | GOREMAL_PREFERRED_IND | VARCHAR2(1) | No |   |   |
| GOREMAL_ACTIVITY_DATE | GOREMAL_ACTIVITY_DATE | DATE | No |   |   |
| GOREMAL_USER_ID | GOREMAL_USER_ID | VARCHAR2(30) | No |   |   |
| GOREMAL_COMMENT | GOREMAL_COMMENT | VARCHAR2(60) | Yes |   |   |
| GOREMAL_DISP_WEB_IND | GOREMAL_DISP_WEB_IND | VARCHAR2(1) | No |   |   |
| GOREMAL_DATA_ORIGIN | GOREMAL_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GOREMAL_EMAL_CODE | GTVEMAL_CODE | GTVEMAL |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GOREMAL | Unique | GOREMAL_PIDM |
| PK_GOREMAL | Unique | GOREMAL_EMAL_CODE |
| PK_GOREMAL | Unique | GOREMAL_EMAIL_ADDRESS |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GOREMAL | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GT_GOREMAL_AIR_IC | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (Insert,after,each row) |
| GT_GOREMAL_AIS_IC | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (Insert,after,all rows) |
| GT_GOREMAL_AR_LDI | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (Insert,update,delete,after,each row) |
| GT_GOREMAL_AS_LDI | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (Insert,update,delete,after,all rows) |
| GT_GOREMAL_AUR_IC | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (update,after,each row) |
| GT_GOREMAL_AUS_IC | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (update,after,all rows) |
| GTVEMAL | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GORPAUD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORPAUD_PIDM | GORPAUD_PIDM | NUMBER(8,0) | No |   |   |
| GORPAUD_ACTIVITY_DATE | GORPAUD_ACTIVITY_DATE | DATE | No |   |   |
| GORPAUD_USER | GORPAUD_USER | VARCHAR2(30) | No |   |   |
| GORPAUD_PIN | GORPAUD_PIN | VARCHAR2(6) | Yes |   |   |
| GORPAUD_EXTERNAL_USER | GORPAUD_EXTERNAL_USER | VARCHAR2(30) | Yes |   |   |
| GORPAUD_CHG_IND | GORPAUD_CHG_IND | VARCHAR2(1) | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| GORPAUD_KEY_INDEX |   | GORPAUD_PIDM |
| GORPAUD_KEY_INDEX2 |   | GORPAUD_EXTERNAL_USER |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORPAUD_KEY_INDEX | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GORPAUD_KEY_INDEX2 | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GORPPRM| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORPPRM_PACKAGE | GORPPRM_PACKAGE | VARCHAR2(80) | No |   |   |
| GORPPRM_SEQ | GORPPRM_SEQ | NUMBER(0,0) | No |   |   |
| GORPPRM_NAME | GORPPRM_NAME | VARCHAR2(30) | No |   |   |
| GORPPRM_KEY_POS | GORPPRM_KEY_POS | NUMBER(0,0) | No |   |   |
| GORPPRM_OUTPUT_IND | GORPPRM_OUTPUT_IND | VARCHAR2(1) | No |   |   |
| GORPPRM_TYPE_IND | GORPPRM_TYPE_IND | VARCHAR2(1) | No |   |   |
| GORPPRM_MIN_LEN | GORPPRM_MIN_LEN | NUMBER(0,0) | No |   |   |
| GORPPRM_MAX_LEN | GORPPRM_MAX_LEN | NUMBER(0,0) | No |   |   |
| GORPPRM_SYS_REQ_IND | GORPPRM_SYS_REQ_IND | VARCHAR2(1) | No |   |   |
| GORPPRM_ACTIVITY_DATE | GORPPRM_ACTIVITY_DATE | DATE | No |   |   |
| GORPPRM_USER_ID | GORPPRM_USER_ID | VARCHAR2(30) | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| GORPPRM_KEY_INDEX | Unique | GORPPRM_PACKAGE |
| GORPPRM_KEY_INDEX | Unique | GORPPRM_SEQ |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORPPRM | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORPPRM_ROW_BY_PKG_C | Package cursor | "S4B70.SCT.COM".BANINST1.GOKSELS | Rely On |
| GORPPRMC | Package cursor | "S4B70.SCT.COM".BANINST1.VRGKOINT | Use (select)Rely On |
| GORPPRM_TYP | Package Type | "S4B70.SCT.COM".BANINST1.VRGKOINT | Rely On |
| GORPPRM_REC | Package variable | "S4B70.SCT.COM".BANINST1.VRGKOINT | Rely On |
| P_VR_END_INFC_TABLE | Package procedure | "S4B70.SCT.COM".BANINST1.VRGKOCTL | Rely On |
| P_VR_INIT_INFC_TABLE | Package procedure | "S4B70.SCT.COM".BANINST1.VRGKOCTL | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORPPRM_KEY_INDEX | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GORSRVR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSRVR_PIDM | GORSRVR_PIDM | NUMBER(8,0) | No | * | * |
| GORSRVR_NAME | GORSRVR_NAME | VARCHAR2(15) | No | * | * |
| GORSRVR_QUESTION_NO | GORSRVR_QUESTION_NO | NUMBER(3,0) | No | * |   |
| GORSRVR_ACTIVITY_DATE | GORSRVR_ACTIVITY_DATE | DATE | No |   |   |
| GORSRVR_USER | GORSRVR_USER | VARCHAR2(30) | No |   |   |
| GORSRVR_RESPONSE_1 | GORSRVR_RESPONSE_1 | VARCHAR2(1) | Yes |   |   |
| GORSRVR_RESPONSE_2 | GORSRVR_RESPONSE_2 | VARCHAR2(1) | Yes |   |   |
| GORSRVR_RESPONSE_3 | GORSRVR_RESPONSE_3 | VARCHAR2(1) | Yes |   |   |
| GORSRVR_RESPONSE_4 | GORSRVR_RESPONSE_4 | VARCHAR2(1) | Yes |   |   |
| GORSRVR_RESPONSE_5 | GORSRVR_RESPONSE_5 | VARCHAR2(1) | Yes |   |   |
| GORSRVR_COMMENTS | GORSRVR_COMMENTS | VARCHAR2(2000) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSRVR_PIDM | GOBSRVR_PIDM | GOBSRVR |
| GORSRVR_NAME | GOBSRVR_NAME | GOBSRVR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSRVR | Unique | GORSRVR_PIDM |
| PK_GORSRVR | Unique | GORSRVR_NAME |
| PK_GORSRVR | Unique | GORSRVR_QUESTION_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSRVR | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GORSRVR_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Rely On |
| P_MODIFYRESPONSES | Package procedure | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (Insert,update) |
| GORSRVRREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSRVR | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GOBSRVR | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GORTCTL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORTCTL_GROUP | GORTCTL_GROUP | VARCHAR2(15) | No |   |   |
| GORTCTL_FUNCTION | GORTCTL_FUNCTION | VARCHAR2(20) | No |   |   |
| GORTCTL_DESC | GORTCTL_DESC | VARCHAR2(60) | No |   |   |
| GORTCTL_TERM_YEAR | GORTCTL_TERM_YEAR | VARCHAR2(6) | No |   |   |
| GORTCTL_TCTL_NUM | GORTCTL_TCTL_NUM | NUMBER(2,0) | No |   |   |
| GORTCTL_VALUE | GORTCTL_VALUE | VARCHAR2(2) | No |   |   |
| GORTCTL_ACTIVE_IND | GORTCTL_ACTIVE_IND | VARCHAR2(1) | No |   |   |
| GORTCTL_SYS_REQ_IND | GORTCTL_SYS_REQ_IND | VARCHAR2(1) | No |   |   |
| GORTCTL_ACTIVITY_DATE | GORTCTL_ACTIVITY_DATE | DATE | No |   |   |
| GORTCTL_USER_ID | GORTCTL_USER_ID | VARCHAR2(30) | No |   |   |
| GORTCTL_TCTL_SEQNO | GORTCTL_TCTL_SEQNO | NUMBER(2,0) | Yes |   |   |
| GORTCTL_BEGIN_DATE | GORTCTL_BEGIN_DATE | DATE | Yes |   |   |
| GORTCTL_END_DATE | GORTCTL_END_DATE | DATE | Yes |   |   |
| GORTCTL_BEGIN_TIME | GORTCTL_BEGIN_TIME | VARCHAR2(4) | Yes |   |   |
| GORTCTL_END_TIME | GORTCTL_END_TIME | VARCHAR2(4) | Yes |   |   |
| GORTCTL_DAYS_AVAIL | GORTCTL_DAYS_AVAIL | VARCHAR2(9) | Yes |   |   |
| GORTCTL_YEAR | GORTCTL_YEAR | VARCHAR2(4) | Yes |   |   |
| GORTCTL_YEAR_2 | GORTCTL_YEAR_2 | VARCHAR2(4) | Yes |   |   |
| GORTCTL_VALUE_2 | GORTCTL_VALUE_2 | VARCHAR2(30) | Yes |   |   |
| GORTCTL_VALUE_3 | GORTCTL_VALUE_3 | VARCHAR2(30) | Yes |   |   |
| GORTCTL_VALUE_4 | GORTCTL_VALUE_4 | VARCHAR2(30) | Yes |   |   |
| GORTCTL_TERM_YEAR_2 | GORTCTL_TERM_YEAR_2 | VARCHAR2(6) | Yes |   |   |
| GORTCTL_DATE | GORTCTL_DATE | DATE | Yes |   |   |
| GORTCTL_SYSI_CODE | GORTCTL_SYSI_CODE | VARCHAR2(2) | Yes |   |   |
| GORTCTL_SYSI_CODE_2 | GORTCTL_SYSI_CODE_2 | VARCHAR2(2) | Yes |   |   |
| GORTCTL_RECORD_TYPE | GORTCTL_RECORD_TYPE | VARCHAR2(10) | Yes |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| GORTCTL_KEY_INDEX |   | GORTCTL_FUNCTION |
| GORTCTL_KEY_INDEX |   | GORTCTL_GROUP |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORTCTL_KEY_INDEX | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:28:000 |
Table GTVDIRO| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVDIRO_CODE | GTVDIRO_CODE | VARCHAR2(8) | No | * |   |
| GTVDIRO_DESC | GTVDIRO_DESC | VARCHAR2(30) | No |   |   |
| GTVDIRO_SYSTEM_REQ_IND | GTVDIRO_SYSTEM_REQ_IND | VARCHAR2(1) | No |   |   |
| GTVDIRO_ACTIVITY_DATE | GTVDIRO_ACTIVITY_DATE | DATE | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVDIRO | Unique | GTVDIRO_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| sel_gtvdiro_desc | C/C++ Function | [F:\BANNER\C\HWPREDIR.PC] | Use (select) |
| sel_gtvdiro_desc | C/C++ Function | [F:\BANNER\C\BWPREDIR.PC] | Use (select) |
| GTVDIRO | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GOBDIRO | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| GTVDIROC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Use (select) |
| GTVDIROC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Use (select) |
| GTVDIRO_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKOPRF | Rely On |
| GTVDIRO_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWAKSRCH | Rely On |
| P_GETDATALABELS | Package procedure | "S4B70.SCT.COM".BANINST1.BWPKEDIR | Use (select) |
| GTVDIRO_C | Package cursor | "S4B70.SCT.COM".BANINST1.GB_GTVDIRO | Rely On |
| GTVDIRO_C | Package cursor | "S4B70.SCT.COM".BANINST1.GB_GTVDIRO | Use (select)Rely On |
| F_CODE_EXISTS | Package function | "S4B70.SCT.COM".BANINST1.GB_GTVDIRO | Rely On |
| F_GET_DESCRIPTION | Package function | "S4B70.SCT.COM".BANINST1.GB_GTVDIRO | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVDIRO | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GTVEMAL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVEMAL_CODE | GTVEMAL_CODE | VARCHAR2(4) | No | * |   |
| GTVEMAL_DESC | GTVEMAL_DESC | VARCHAR2(60) | Yes |   |   |
| GTVEMAL_ACTIVITY_DATE | GTVEMAL_ACTIVITY_DATE | DATE | No |   |   |
| GTVEMAL_DISP_WEB_IND | GTVEMAL_DISP_WEB_IND | VARCHAR2(1) | No |   |   |
| GTVEMAL_URL_IND | GTVEMAL_URL_IND | VARCHAR2(1) | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVEMAL | Unique | GTVEMAL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVEMAL | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GUBSRVY| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GUBSRVY_NAME | GUBSRVY_NAME | VARCHAR2(15) | No | * |   |
| GUBSRVY_TITLE | GUBSRVY_TITLE | VARCHAR2(60) | No |   |   |
| GUBSRVY_DISP_WEB_IND | GUBSRVY_DISP_WEB_IND | VARCHAR2(1) | No |   |   |
| GUBSRVY_ACTIVITY_DATE | GUBSRVY_ACTIVITY_DATE | DATE | No |   |   |
| GUBSRVY_USER | GUBSRVY_USER | VARCHAR2(30) | No |   |   |
| GUBSRVY_FROM_DATE | GUBSRVY_FROM_DATE | DATE | Yes |   |   |
| GUBSRVY_TO_DATE | GUBSRVY_TO_DATE | DATE | Yes |   |   |
| GUBSRVY_EXTR_APPLICATION | GUBSRVY_EXTR_APPLICATION | VARCHAR2(30) | Yes |   |   |
| GUBSRVY_EXTR_SELECTION | GUBSRVY_EXTR_SELECTION | VARCHAR2(30) | Yes |   |   |
| GUBSRVY_EXTR_CREATOR_ID | GUBSRVY_EXTR_CREATOR_ID | VARCHAR2(30) | Yes |   |   |
| GUBSRVY_EXTR_USER_ID | GUBSRVY_EXTR_USER_ID | VARCHAR2(30) | Yes |   |   |
| GUBSRVY_INFO | GUBSRVY_INFO | VARCHAR2(2000) | Yes |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GUBSRVY | Unique | GUBSRVY_NAME |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GUBSRVY | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GURSRVQ | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| GURSVRL | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| GUBSRVY_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Rely On |
| GUBSRVYREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GUBSRVY | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GURSRVQ| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GURSRVQ_NAME | GURSRVQ_NAME | VARCHAR2(15) | No | * | * |
| GURSRVQ_QUESTION_NO | GURSRVQ_QUESTION_NO | NUMBER(3,0) | No | * |   |
| GURSRVQ_ACTIVITY_DATE | GURSRVQ_ACTIVITY_DATE | DATE | No |   |   |
| GURSRVQ_USER | GURSRVQ_USER | VARCHAR2(30) | No |   |   |
| GURSRVQ_MULT_RESP_IND | GURSRVQ_MULT_RESP_IND | VARCHAR2(1) | No |   |   |
| GURSRVQ_TEXT | GURSRVQ_TEXT | VARCHAR2(1000) | No |   |   |
| GURSRVQ_ALLOW_COMMENTS_IND | GURSRVQ_ALLOW_COMMENTS_IND | VARCHAR2(1) | No |   |   |
| GURSRVQ_RESPONSE_1_TEXT | GURSRVQ_RESPONSE_1_TEXT | VARCHAR2(60) | Yes |   |   |
| GURSRVQ_RESPONSE_2_TEXT | GURSRVQ_RESPONSE_2_TEXT | VARCHAR2(60) | Yes |   |   |
| GURSRVQ_RESPONSE_3_TEXT | GURSRVQ_RESPONSE_3_TEXT | VARCHAR2(60) | Yes |   |   |
| GURSRVQ_RESPONSE_4_TEXT | GURSRVQ_RESPONSE_4_TEXT | VARCHAR2(60) | Yes |   |   |
| GURSRVQ_RESPONSE_5_TEXT | GURSRVQ_RESPONSE_5_TEXT | VARCHAR2(60) | Yes |   |   |
| GURSRVQ_COMMENTS_TEXT | GURSRVQ_COMMENTS_TEXT | VARCHAR2(60) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GURSRVQ_NAME | GUBSRVY_NAME | GUBSRVY |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GURSRVQ | Unique | GURSRVQ_NAME |
| PK_GURSRVQ | Unique | GURSRVQ_QUESTION_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GURSRVQ | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GURSRVQ_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Rely On |
| GURSRVQREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GURSRVQ | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GUBSRVY | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table GURSVRL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GURSVRL_NAME | GURSVRL_NAME | VARCHAR2(15) | No | * | * |
| GURSVRL_ROLE | GURSVRL_ROLE | VARCHAR2(30) | No | * |   |
| GURSVRL_ACTIVITY_DATE | GURSVRL_ACTIVITY_DATE | DATE | No |   |   |
| GURSVRL_USER | GURSVRL_USER | VARCHAR2(30) | No |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GURSVRL_NAME | GUBSRVY_NAME | GUBSRVY |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GURSVRL | Unique | GURSVRL_NAME |
| PK_GURSVRL | Unique | GURSVRL_ROLE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GURSVRL | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| GURSVRL_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Rely On |
| GURSVRLREADC | Package cursor | "S4B70.SCT.COM".BANINST1.BWGKSRVY | Use (select)Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GURSVRL | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GUBSRVY | TABLE | "S4B70.SCT.COM".GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:29:000 |
Table GURUPRF| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GURUPRF_USER_ID | GURUPRF_USER_ID | VARCHAR2(30) | No | * |   |
| GURUPRF_GROUP | GURUPRF_GROUP | VARCHAR2(30) | No | * |   |
| GURUPRF_KEY | GURUPRF_KEY | VARCHAR2(30) | No | * |   |
| GURUPRF_STRING | GURUPRF_STRING | VARCHAR2(30) | No | * |   |
| GURUPRF_VALUE | GURUPRF_VALUE | VARCHAR2(200) | Yes |   |   |
| GURUPRF_SYSTEM_REQ_IND | GURUPRF_SYSTEM_REQ_IND | VARCHAR2(1) | Yes |   |   |
| GURUPRF_ACTIVITY_DATE | GURUPRF_ACTIVITY_DATE | DATE | No |   |   |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GURUPRF | Unique | GURUPRF_USER_ID |
| PK_GURUPRF | Unique | GURUPRF_GROUP |
| PK_GURUPRF | Unique | GURUPRF_KEY |
| PK_GURUPRF | Unique | GURUPRF_STRING |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GURUPRF | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| RMI_URL_REC | Package Type | "S4B70.SCT.COM".BANINST1.GB_MESSAGING | Rely On |
| ADD_DEFAULTS | Package procedure | "S4B70.SCT.COM".BANINST1.GENUTIL | Use (Insert,select) |
| F_GET_UPREF | Package function | "S4B70.SCT.COM".BANINST1.GOKSSSO | Use (select) |
| P_DISPLAY_PO | Package procedure | "S4B70.SCT.COM".BANINST1.BWFKEAPI | Use (select) |
| P_DISPLAY_REQ | Package procedure | "S4B70.SCT.COM".BANINST1.BWFKEAPI | Use (select) |
| F_GET_REPORTS_XML | Package function | "S4B70.SCT.COM".BANINST1.BWGCXCHN | Rely On |
| F_QUERY_RMI_URL | Package function | "S4B70.SCT.COM".BANINST1.GB_MESSAGING | Use (select) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GURUPRF | INDEX | "S4B70.SCT.COM".GENERAL | Rely On |
| GT_GURUPRF_PRE_UPDATE_ROW | TRIGGER | "S4B70.SCT.COM".GENERAL | Fire (update,before,each row) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:30:000 |
Table SPBPERS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPBPERS_PIDM | SPBPERS_PIDM | NUMBER(8,0) | No | * | * |
| SPBPERS_SSN | SPBPERS_SSN | VARCHAR2(9) | Yes |   |   |
| SPBPERS_BIRTH_DATE | SPBPERS_BIRTH_DATE | DATE | Yes |   |   |
| SPBPERS_LGCY_CODE | SPBPERS_LGCY_CODE | VARCHAR2(1) | Yes |   | * |
| SPBPERS_ETHN_CODE | SPBPERS_ETHN_CODE | VARCHAR2(2) | Yes |   | * |
| SPBPERS_MRTL_CODE | SPBPERS_MRTL_CODE | VARCHAR2(1) | Yes |   | * |
| SPBPERS_RELG_CODE | SPBPERS_RELG_CODE | VARCHAR2(2) | Yes |   | * |
| SPBPERS_SEX | SPBPERS_SEX | VARCHAR2(1) | Yes |   |   |
| SPBPERS_CONFID_IND | SPBPERS_CONFID_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_DEAD_IND | SPBPERS_DEAD_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_VETC_FILE_NUMBER | SPBPERS_VETC_FILE_NUMBER | VARCHAR2(10) | Yes |   |   |
| SPBPERS_LEGAL_NAME | SPBPERS_LEGAL_NAME | VARCHAR2(60) | Yes |   |   |
| SPBPERS_PREF_FIRST_NAME | SPBPERS_PREF_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
| SPBPERS_NAME_PREFIX | SPBPERS_NAME_PREFIX | VARCHAR2(20) | Yes |   |   |
| SPBPERS_NAME_SUFFIX | SPBPERS_NAME_SUFFIX | VARCHAR2(20) | Yes |   |   |
| SPBPERS_ACTIVITY_DATE | SPBPERS_ACTIVITY_DATE | DATE | No |   |   |
| SPBPERS_VERA_IND | SPBPERS_VERA_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_CITZ_IND | SPBPERS_CITZ_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_DEAD_DATE | SPBPERS_DEAD_DATE | DATE | Yes |   |   |
| SPBPERS_PIN | SPBPERS_PIN | RAW(1) | Yes |   |   |
| SPBPERS_CITZ_CODE | SPBPERS_CITZ_CODE | VARCHAR2(2) | Yes |   | * |
| SPBPERS_HAIR_CODE | SPBPERS_HAIR_CODE | VARCHAR2(2) | Yes |   |   |
| SPBPERS_EYES_CODE | SPBPERS_EYES_CODE | VARCHAR2(2) | Yes |   |   |
| SPBPERS_CITY_BIRTH | SPBPERS_CITY_BIRTH | VARCHAR2(20) | Yes |   |   |
| SPBPERS_STAT_CODE_BIRTH | SPBPERS_STAT_CODE_BIRTH | VARCHAR2(3) | Yes |   | * |
| SPBPERS_DRIVER_LICENSE | SPBPERS_DRIVER_LICENSE | VARCHAR2(20) | Yes |   |   |
| SPBPERS_STAT_CODE_DRIVER | SPBPERS_STAT_CODE_DRIVER | VARCHAR2(3) | Yes |   | * |
| SPBPERS_NATN_CODE_DRIVER | SPBPERS_NATN_CODE_DRIVER | VARCHAR2(5) | Yes |   | * |
| SPBPERS_UOMS_CODE_HEIGHT | SPBPERS_UOMS_CODE_HEIGHT | VARCHAR2(4) | Yes |   | * |
| SPBPERS_HEIGHT | SPBPERS_HEIGHT | NUMBER(2,0) | Yes |   |   |
| SPBPERS_UOMS_CODE_WEIGHT | SPBPERS_UOMS_CODE_WEIGHT | VARCHAR2(4) | Yes |   | * |
| SPBPERS_WEIGHT | SPBPERS_WEIGHT | NUMBER(4,0) | Yes |   |   |
| SPBPERS_SDVET_IND | SPBPERS_SDVET_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_LICENSE_ISSUED_DATE | SPBPERS_LICENSE_ISSUED_DATE | DATE | Yes |   |   |
| SPBPERS_LICENSE_EXPIRES_DATE | SPBPERS_LICENSE_EXPIRES_DATE | DATE | Yes |   |   |
| SPBPERS_INCAR_IND | SPBPERS_INCAR_IND | VARCHAR2(1) | Yes |   |   |
| SPBPERS_WEBID | SPBPERS_WEBID | RAW(1) | Yes |   |   |
| SPBPERS_WEB_LAST_ACCESS | SPBPERS_WEB_LAST_ACCESS | RAW(1) | Yes |   |   |
| SPBPERS_PIN_DISABLED_IND | SPBPERS_PIN_DISABLED_IND | RAW(1) | Yes |   |   |
| SPBPERS_ITIN | SPBPERS_ITIN | NUMBER(9,0) | Yes |   |   |
| SPBPERS_ACTIVE_DUTY_SEPR_DATE | SPBPERS_ACTIVE_DUTY_SEPR_DATE | DATE | Yes |   |   |
| SPBPERS_DATA_ORIGIN | SPBPERS_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
| SPBPERS_USER_ID | SPBPERS_USER_ID | VARCHAR2(30) | Yes |   |   |
| SPBPERS_ETHN_CDE |   | VARCHAR2(1) | Yes |   |   |
| SPBPERS_CONFIRMED_RE_CDE |   | VARCHAR2(1) | Yes |   |   |
| SPBPERS_CONFIRMED_RE_DATE |   | DATE | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPBPERS_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPBPERS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPBPERS_LGCY_CODE | STVLGCY_CODE | STVLGCY |
| SPBPERS_ETHN_CODE | STVETHN_CODE | STVETHN |
| SPBPERS_STAT_CODE_DRIVER | STVSTAT_CODE | STVSTAT |
| SPBPERS_STAT_CODE_BIRTH | STVSTAT_CODE | STVSTAT |
| SPBPERS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
| SPBPERS_RELG_CODE | STVRELG_CODE | STVRELG |
| SPBPERS_NATN_CODE_DRIVER | STVNATN_CODE | STVNATN |
| SPBPERS_CITZ_CODE | STVCITZ_CODE | STVCITZ |
| SPBPERS_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPBPERS_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPBPERS_UOMS_CODE_WEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_UOMS_CODE_HEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPBPERS_CITZ_CODE | SARDCSN_CITZ_CODE | SARDCSN |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SPBPERS | Unique | SPBPERS_PIDM |
| SPBPERS_SSN_INDEX |   | SPBPERS_SSN |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:43:000 |
Table SPRADDR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPRADDR_PIDM | SPRADDR_PIDM | NUMBER(8,0) | No |   | * |
| SPRADDR_ATYP_CODE | SPRADDR_ATYP_CODE | VARCHAR2(2) | No |   | * |
| SPRADDR_SEQNO | SPRADDR_SEQNO | NUMBER(2,0) | No |   | * |
| SPRADDR_FROM_DATE | SPRADDR_FROM_DATE | DATE | Yes |   |   |
| SPRADDR_TO_DATE | SPRADDR_TO_DATE | DATE | Yes |   |   |
| SPRADDR_STREET_LINE1 | SPRADDR_STREET_LINE1 | VARCHAR2(30) | Yes |   |   |
| SPRADDR_STREET_LINE2 | SPRADDR_STREET_LINE2 | VARCHAR2(30) | Yes |   |   |
| SPRADDR_STREET_LINE3 | SPRADDR_STREET_LINE3 | VARCHAR2(30) | Yes |   |   |
| SPRADDR_CITY | SPRADDR_CITY | VARCHAR2(20) | No |   | * |
| SPRADDR_STAT_CODE | SPRADDR_STAT_CODE | VARCHAR2(3) | Yes |   | * |
| SPRADDR_ZIP | SPRADDR_ZIP | VARCHAR2(10) | Yes |   |   |
| SPRADDR_CNTY_CODE | SPRADDR_CNTY_CODE | VARCHAR2(5) | Yes |   | * |
| SPRADDR_NATN_CODE | SPRADDR_NATN_CODE | VARCHAR2(5) | Yes |   | * |
| SPRADDR_PHONE_AREA | SPRADDR_PHONE_AREA | VARCHAR2(3) | Yes |   |   |
| SPRADDR_PHONE_NUMBER | SPRADDR_PHONE_NUMBER | VARCHAR2(7) | Yes |   |   |
| SPRADDR_PHONE_EXT | SPRADDR_PHONE_EXT | VARCHAR2(4) | Yes |   |   |
| SPRADDR_STATUS_IND | SPRADDR_STATUS_IND | VARCHAR2(1) | Yes |   |   |
| SPRADDR_ACTIVITY_DATE | SPRADDR_ACTIVITY_DATE | DATE | No |   |   |
| SPRADDR_USER | SPRADDR_USER | VARCHAR2(30) | Yes |   |   |
| SPRADDR_ASRC_CODE | SPRADDR_ASRC_CODE | VARCHAR2(4) | Yes |   | * |
| SPRADDR_DELIVERY_POINT | SPRADDR_DELIVERY_POINT | NUMBER(2,0) | Yes |   |   |
| SPRADDR_CORRECTION_DIGIT | SPRADDR_CORRECTION_DIGIT | NUMBER(1,0) | Yes |   |   |
| SPRADDR_CARRIER_ROUTE | SPRADDR_CARRIER_ROUTE | VARCHAR2(4) | Yes |   |   |
| SPRADDR_GST_TAX_ID | SPRADDR_GST_TAX_ID | VARCHAR2(15) | Yes |   |   |
| SPRADDR_REVIEWED_IND | SPRADDR_REVIEWED_IND | VARCHAR2(1) | Yes |   |   |
| SPRADDR_REVIEWED_USER | SPRADDR_REVIEWED_USER | VARCHAR2(30) | Yes |   |   |
| SPRADDR_DATA_ORIGIN | SPRADDR_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPRADDR_PIDM | SPRIDEN_PIDM | SPRIDEN |
| SPRADDR_ATYP_CODE | AOBORGN_ATYP_CODE | AOBORGN |
| SPRADDR_PIDM | AMRINFO_PIDM | AMRINFO |
| SPRADDR_CITY | SORGEOR_START_RANGE | SORGEOR |
| SPRADDR_STAT_CODE | SORGEOR_END_RANGE | SORGEOR |
| SPRADDR_STAT_CODE | SORGEOR_START_RANGE | SORGEOR |
| SPRADDR_CNTY_CODE | SORGEOR_START_RANGE | SORGEOR |
| SPRADDR_NATN_CODE | SORGEOR_START_RANGE | SORGEOR |
| SPRADDR_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
| SPRADDR_ATYP_CODE | FRBGRNT_AGENCY_ADDR_CODE | FRBGRNT |
| SPRADDR_SEQNO | FRBGRNT_AGENCY_ADDR_SEQ_NUM | FRBGRNT |
| SPRADDR_SEQNO | FRRGRPI_ADDR_SEQNO | FRRGRPI |
| SPRADDR_ATYP_CODE | FRRGRPI_ADDR_TYPE | FRRGRPI |
| SPRADDR_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
| SPRADDR_ATYP_CODE | GORSVAS_ATYP_CODE | GORSVAS |
| SPRADDR_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
| SPRADDR_ATYP_CODE | GORSVEI_ATYP_CODE | GORSVEI |
| SPRADDR_NATN_CODE | STVNATN_CODE | STVNATN |
| SPRADDR_ASRC_CODE | STVASRC_CODE | STVASRC |
| SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP |
| SPRADDR_CNTY_CODE | STVCNTY_CODE | STVCNTY |
| SPRADDR_STAT_CODE | STVSTAT_CODE | STVSTAT |
| SPRADDR_ATYP_CODE | FTVVEND_VEND_CHECK_ATYP_CODE | FTVVEND |
| SPRADDR_SEQNO | FTVVEND_VEND_CHECK_ADDR_SEQNO | FTVVEND |
| SPRADDR_PIDM | FTVVEND_PIDM | FTVVEND |
| SPRADDR_ATYP_CODE | FTVVEND_ATYP_CODE | FTVVEND |
| SPRADDR_SEQNO | FTVVEND_ADDR_SEQNO | FTVVEND |
| SPRADDR_PIDM | SPRTELE_PIDM | SPRTELE |
| SPRADDR_ATYP_CODE | SPRTELE_ATYP_CODE | SPRTELE |
| SPRADDR_SEQNO | SPRTELE_SEQNO | SPRTELE |
| Index Name | Index Type | Column Name |
|---|---|---|
| SPRADDR_KEY_INDEX | Unique | SPRADDR_PIDM |
| SPRADDR_KEY_INDEX | Unique | SPRADDR_ATYP_CODE |
| SPRADDR_KEY_INDEX | Unique | SPRADDR_SEQNO |
| SPRADDR_KEY_INDEX | Unique | SPRADDR_STATUS_IND |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_PIDM |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_ATYP_CODE |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_SEQNO |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_STATUS_IND |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_FROM_DATE |
| SPRADDR_KEY_INDEX2 |   | SPRADDR_TO_DATE |
| SPRADDR_KEY_INDEX3 |   | SPRADDR_USER |
| SPRADDR_KEY_INDEX3 |   | SPRADDR_ASRC_CODE |
| SPRADDR_KEY_INDEX3 |   | SPRADDR_ACTIVITY_DATE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Table SPRIDEN| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPRIDEN_PIDM | SPRIDEN_PIDM | NUMBER(8,0) | No |   | * |
| SPRIDEN_ID | SPRIDEN_ID | VARCHAR2(9) | No |   | * |
| SPRIDEN_LAST_NAME | SPRIDEN_LAST_NAME | VARCHAR2(60) | No |   |   |
| SPRIDEN_FIRST_NAME | SPRIDEN_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
| SPRIDEN_MI | SPRIDEN_MI | VARCHAR2(15) | Yes |   |   |
| SPRIDEN_CHANGE_IND | SPRIDEN_CHANGE_IND | VARCHAR2(1) | Yes |   |   |
| SPRIDEN_ENTITY_IND | SPRIDEN_ENTITY_IND | VARCHAR2(1) | Yes |   |   |
| SPRIDEN_ACTIVITY_DATE | SPRIDEN_ACTIVITY_DATE | DATE | No |   |   |
| SPRIDEN_USER | SPRIDEN_USER | VARCHAR2(30) | Yes |   |   |
| SPRIDEN_ORIGIN | SPRIDEN_ORIGIN | VARCHAR2(30) | Yes |   |   |
| SPRIDEN_SEARCH_LAST_NAME | SPRIDEN_SEARCH_LAST_NAME | VARCHAR2(60) | Yes |   |   |
| SPRIDEN_SEARCH_FIRST_NAME | SPRIDEN_SEARCH_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
| SPRIDEN_SEARCH_MI | SPRIDEN_SEARCH_MI | VARCHAR2(15) | Yes |   |   |
| SPRIDEN_SOUNDEX_LAST_NAME | SPRIDEN_SOUNDEX_LAST_NAME | CHAR(4) | Yes |   |   |
| SPRIDEN_SOUNDEX_FIRST_NAME | SPRIDEN_SOUNDEX_FIRST_NAME | CHAR(4) | Yes |   |   |
| SPRIDEN_NTYP_CODE | SPRIDEN_NTYP_CODE | VARCHAR2(4) | Yes |   |   |
| SPRIDEN_CREATE_USER | SPRIDEN_CREATE_USER | VARCHAR2(30) | Yes |   |   |
| SPRIDEN_CREATE_DATE | SPRIDEN_CREATE_DATE | DATE | Yes |   |   |
| SPRIDEN_DATA_ORIGIN | SPRIDEN_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
| SPRIDEN_CREATE_FDMN_CODE | SPRIDEN_CREATE_FDMN_CODE | VARCHAR2(30) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
| SPRIDEN_PIDM | AGRPIDS_XREF_PIDM | AGRPIDS |
| SPRIDEN_PIDM | AGRPIDS_PIDM | AGRPIDS |
| SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
| SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
| SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
| SPRIDEN_PIDM | AGRGIDS_XREF_PIDM | AGRGIDS |
| SPRIDEN_PIDM | AGRGIDS_PIDM | AGRGIDS |
| SPRIDEN_PIDM | AGBPLDG_PIDM | AGBPLDG |
| SPRIDEN_PIDM | AGRPMEM_PIDM | AGRPMEM |
| SPRIDEN_PIDM | AGRPMEM_MEMO_PIDM | AGRPMEM |
| SPRIDEN_PIDM | AGRGMEM_PIDM | AGRGMEM |
| SPRIDEN_PIDM | AGRGMEM_MEMO_PIDM | AGRGMEM |
| SPRIDEN_PIDM | AGRGPAY_PIDM | AGRGPAY |
| SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
| SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
| SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
| SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
| SPRIDEN_PIDM | FRRPRPI_ID_PIDM | FRRPRPI |
| SPRIDEN_PIDM | FIRBOND_IMGR_CODE_PIDM | FIRBOND |
| SPRIDEN_PIDM | FPBAGRH_VEND_PIDM | FPBAGRH |
| SPRIDEN_PIDM | FTVAGCY_AGCY_CODE_PIDM | FTVAGCY |
| SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
| SPRIDEN_PIDM | AARMEMB_RENEWAL_PIDM | AARMEMB |
| SPRIDEN_PIDM | AARMEMB_REMINDER_PIDM | AARMEMB |
| SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
| SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
| SPRIDEN_PIDM | FRRGRPI_ID_PIDM | FRRGRPI |
| SPRIDEN_PIDM | FPRBIDV_VEND_PIDM | FPRBIDV |
| SPRIDEN_PIDM | FPBREQH_VEND_PIDM | FPBREQH |
| SPRIDEN_PIDM | FIRCERD_IMGR_CODE_PIDM | FIRCERD |
| SPRIDEN_PIDM | FIRMMKT_IMGR_CODE_PIDM | FIRMMKT |
| SPRIDEN_PIDM | FIRPRTY_IMGR_CODE_PIDM | FIRPRTY |
| SPRIDEN_PIDM | FTVFMGR_FMGR_CODE_PIDM | FTVFMGR |
| SPRIDEN_PIDM | FIRSTCK_IMGR_CODE_PIDM | FIRSTCK |
| SPRIDEN_PIDM | FIRSTOP_IMGR_CODE_PIDM | FIRSTOP |
| SPRIDEN_PIDM | GERFGST_PIDM | GERFGST |
| SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
| SPRIDEN_PIDM | GEBFUNC_SPNSR_ORGN_PIDM | GEBFUNC |
| SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
| SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
| SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
| SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
| SPRIDEN_PIDM | PERHSIP_PIDM | PERHSIP |
| SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
| SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
| SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
| SPRIDEN_PIDM | NOBTRAN_PIDM | NOBTRAN |
| SPRIDEN_PIDM | PCBPERS_COBRA_BFCTR_PIDM | PCBPERS |
| SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
| SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
| SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
| SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
| SPRIDEN_PIDM | TBBCONT_PIDM | TBBCONT |
| SPRIDEN_PIDM | TBRCOLC_PIDM | TBRCOLC |
| SPRIDEN_PIDM | TBBCSTU_STU_PIDM | TBBCSTU |
| SPRIDEN_PIDM | TBBACCT_PIDM | TBBACCT |
| SPRIDEN_PIDM | TBBESTU_PIDM | TBBESTU |
| SPRIDEN_PIDM | TBRACCD_PIDM | TBRACCD |
| SPRIDEN_PIDM | FTVCARD_CARDHOLDER_PIDM | FTVCARD |
| SPRIDEN_PIDM | FCREMPO_PIDM | FCREMPO |
| SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
| SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
| SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
| SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
| SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
| SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
| SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
| SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
| SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
| SPRIDEN_PIDM | SMBAOGN_PIDM | SMBAOGN |
| SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
| SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
| SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
| SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
| SPRIDEN_PIDM | SHBDIPL_PIDM | SHBDIPL |
| SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
| SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
| SPRIDEN_PIDM | SHBCATT_PIDM | SHBCATT |
| SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
| SPRIDEN_PIDM | GERPART_PIDM | GERPART |
| SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
| SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
| SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
| SPRIDEN_PIDM | FTVCUST_PIDM | FTVCUST |
| SPRIDEN_PIDM | FRBPROP_AGENCY_PIDM | FRBPROP |
| SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
| SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
| SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
| SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
| SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
| SPRIDEN_PIDM | SMBPOGN_PIDM | SMBPOGN |
| SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
| SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
| SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
| SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
| SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPRIDEN_PIDM | AMRCONF_PIDM | AMRCONF |
| Index Name | Index Type | Column Name |
|---|---|---|
| SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
| SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
| SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
| SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
| SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
| SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
| SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
| SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
| SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
| SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
| SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
| SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
| SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
| SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Table STVATYP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVATYP_CODE | STVATYP_CODE | VARCHAR2(2) | No | * |   |
| STVATYP_DESC | STVATYP_DESC | VARCHAR2(30) | Yes |   |   |
| STVATYP_ACTIVITY_DATE | STVATYP_ACTIVITY_DATE | DATE | No |   |   |
| STVATYP_SYSTEM_REQ_IND | STVATYP_SYSTEM_REQ_IND | VARCHAR2(1) | Yes |   |   |
| STVATYP_TELE_CODE | STVATYP_TELE_CODE | VARCHAR2(4) | Yes |   | * |
| STVATYP_UPDATE_WEB_IND | STVATYP_UPDATE_WEB_IND | RAW(1) | Yes |   |   |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| STVATYP_TELE_CODE | STVTELE_CODE | STVTELE |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVATYP | Unique | STVATYP_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_STVATYP | INDEX | "S4B70.SCT.COM".SATURN | Rely On |
| STVTELE | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
View GOVSRVR| Column Name | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|
| GOVSRVR_PIDM | NUMBER(8,0) | No |   |   |
| GOVSRVR_NAME | VARCHAR2(15) | No |   |   |
| GOVSRVR_DECLINED_IND | VARCHAR2(1) | No |   |   |
| GOVSRVR_COMPLETE_IND | VARCHAR2(1) | No |   |   |
| GOVSRVR_ID | VARCHAR2(9) | No |   |   |
| GOVSRVR_FULL_NAME | VARCHAR2(80) | Yes |   |   |
| GOVSRVR_LAST_NAME | VARCHAR2(60) | No |   |   |
| GOVSRVR_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
| GOVSRVR_MI | VARCHAR2(15) | Yes |   |   |
| GOVSRVR_NAME_PREFIX | VARCHAR2(20) | Yes |   |   |
| GOVSRVR_NAME_SUFFIX | VARCHAR2(20) | Yes |   |   |
| GOVSRVR_USER | VARCHAR2(30) | No |   |   |
| GOVSRVR_ACTIVITY_DATE | DATE | No |   |   |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOVSRVR | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSRVR | SYNONYM | "S4B70.SCT.COM".PUBLIC | Use (select) |
| SPBPERS | SYNONYM | "S4B70.SCT.COM".PUBLIC | Use (select) |
| SPRIDEN | SYNONYM | "S4B70.SCT.COM".PUBLIC | Use (select) |
| GOBSRVR | TABLE | "S4B70.SCT.COM".GENERAL | Use (select) |
| SPBPERS | TABLE | "S4B70.SCT.COM".SATURN | Use (select) |
| SPRIDEN | TABLE | "S4B70.SCT.COM".SATURN | Use (select) |
| DATE | Package Type | "S4B70.SCT.COM".SYS.STANDARD | Rely On |
| NUMBER | Package Type | "S4B70.SCT.COM".SYS.STANDARD | Rely On |
| VARCHAR2 | Package Type | "S4B70.SCT.COM".SYS.STANDARD | Rely On |
| DECODE | Package function | "S4B70.SCT.COM".SYS.STANDARD | Call |
| SUBSTR | Package function | "S4B70.SCT.COM".SYS.STANDARD | Call |
| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 01:46:40:000 | 01/03/2006 23:18:09:000 |
Report on SPBPERS link| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 05:14:42:000 | 01/01/1900 00:00:00:000 |
Report on SPRIDEN link| Creation Date | Analysis Date |
|---|---|
| 12/13/2005 05:14:42:000 | 01/01/1900 00:00:00:000 |
Link between GORADRL and STVATYP| Objects list |
|---|
| forms-data-block-item-trigger : BANNER7_FORMS.SAAWAPP.SARWAPP.SARWAPP_ATYP_CODE."POST-CHANGE"
forms-module-record-group : BANNER7_FORMS.SAAWAPP.STVATYP_RG forms-data-block-item-trigger : BANNER7_FORMS_10G.SAAWAPP.SARWAPP.SARWAPP_ATYP_CODE."POST-CHANGE" forms-module-record-group : BANNER7_FORMS_10G.SAAWAPP.STVATYP_RG |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GORADRL and STVATYP | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | GORADRL | STVATYP |
Link between SPRIDEN and SPBPERS| Objects list |
|---|
| forms-pl/sql-library-procedure : BANNER7_FORMS.GOQRPLS.G$_SEL_SPRIDEN_ID_NAME
forms-pl/sql-library-procedure : BANNER7_FORMS.GOQRPLS.G$_VALID_ALL_ID forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS.AMAPROS.LOAD_STAFF_BLOCK forms-module-record-group : BANNER7_FORMS.AGAPMEM.THIRDPP_IDS_RG forms-module-procedure : BANNER7_FORMS.AMACONT.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS.AGAGMEM.THIRDPP_IDS_RG forms-module-record-group : BANNER7_FORMS.AGATPAY.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS.APACHLD.APRCHLD.APRCHLD_OTHR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.APACHLD.APRCHLD.OTHR_ID."POST-CHANGE" forms-module-record-group : BANNER7_FORMS.APACOMB.APRXREF_RG forms-module-record-group : BANNER7_FORMS.APACOMB.XREF_ID_RG forms-module-record-group : BANNER7_FORMS.AGAPIDS.THIRDPP_MEM_RG forms-module-record-group : BANNER7_FORMS.AGAGIDS.THIRDPP_MEM_RG forms-data-block-trigger : BANNER7_FORMS.AMASTAF.AMRCONT2."POST-QUERY" forms-module-procedure : BANNER7_FORMS.ASAMRES.SEL_SOLICITOR_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASIGN.SEL_CTYP_SOL_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASIGN.SEL_KEY_SOL_ID_INFO forms-module-procedure : BANNER7_FORMS.ASASANG.SEL_SOLICITOR_ID_INFO forms-module-procedure : BANNER7_FORMS.APAIDEN.SEL_ID_INFO_CUSTOM forms-data-block-item-trigger : BANNER7_FORMS.APACRVW.APRCRVW.APRCRVW_OTHR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.APACRVW.APRCRVW.OTHR_ID."WHEN-VALIDATE-ITEM" forms-data-block-trigger : BANNER7_FORMS.APASBIO.APRXREF."POST-QUERY" schema-view : S4B70.BANINST1.APVBRWS forms-module-procedure : BANNER7_FORMS.ASAASCT.SEL_SOLICITOR_ID_INFO forms-data-block-item-trigger : BANNER7_FORMS.APACONS.APRCSPS.SPS_ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.ASICONT.SEL_NON_CONS_ID_INFO forms-module-function : BANNER7_FORMS.FAAONLC.SELECT_SPRIDEN_1 forms-data-block-trigger : BANNER7_FORMS.GOASEVS.GORSEVD.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS.GOAADDR.SELECT_SPRIDEN_2 forms-data-block-trigger : BANNER7_FORMS.PCABENE.PCRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS.PDAASGN.PERNASG.ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS.PDABENE.PDRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS.PDAMR87.PDRMR87.ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.NOAEPAF.EDIT_ID forms-data-block-item-trigger : BANNER7_FORMS.PDAPERS.PDRPERS.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDICLST.KEY_BLOCK.BENE_ID."POST-CHANGE" schema-view : S4B70.BANINST1.GOVSRVR forms-module-trigger : BANNER7_FORMS.PEAFMLA.EDIT_ID forms-data-block-trigger : BANNER7_FORMS.PEAFMLA.KEY_BLOCK.CHECK_KEYS forms-data-block-item-trigger : BANNER7_FORMS.GUAMESG.GURTKLR.GURTKLR_PIDM."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.GUAMESG.GURTKLR.IDNO."POST-CHANGE" schema-view : S4B70.BANINST1.GUVALTI forms-data-block-item-trigger : BANNER7_FORMS.NHIEDST.KEY_BLOCK.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDADEMO.PERDEMO.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS.PDAF496.PDRF496.ID."POST-CHANGE" schema-view : S4B70.BANINST1.SPVPERS forms-data-block-trigger : BANNER7_FORMS.RJASEME.RJRSEAR."POST-QUERY" forms-data-block-item-trigger : BANNER7_FORMS.SLARMAT.SLRRMAT.SLRRMAT_PIDM."POST-CHANGE" forms-module-procedure : BANNER7_FORMS.SHICMID.G$_VALID_ID forms-module-trigger : BANNER7_FORMS.TSATAXI.GET_SSN forms-pl/sql-library-procedure : BANNER7_FORMS_10G.GOQRPLS.G$_SEL_SPRIDEN_ID_NAME forms-pl/sql-library-procedure : BANNER7_FORMS_10G.GOQRPLS.G$_VALID_ALL_ID forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS_10G.AGAPMEM.THIRDPP_IDS_RG forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-record-group : BANNER7_FORMS_10G.AGAGMEM.THIRDPP_IDS_RG forms-module-record-group : BANNER7_FORMS_10G.AGATPAY.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS_10G.APACHLD.APRCHLD.APRCHLD_OTHR_PIDM."POST-CHANGE" forms-module-record-group : BANNER7_FORMS_10G.APACOMB.APRXREF_RG forms-module-record-group : BANNER7_FORMS_10G.APACOMB.XREF_ID_RG forms-module-record-group : BANNER7_FORMS_10G.AGAPIDS.THIRDPP_MEM_RG forms-module-procedure : BANNER7_FORMS_10G.APAIDEN.SEL_ID_INFO_CUSTOM forms-module-record-group : BANNER7_FORMS_10G.AGAGIDS.THIRDPP_MEM_RG forms-data-block-item-trigger : BANNER7_FORMS_10G.APACONS.APRCSPS.SPS_ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS_10G.GOASEVS.GORSEVD.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS_10G.GOAADDR.SELECT_SPRIDEN_2 forms-data-block-trigger : BANNER7_FORMS_10G.PCABENE.PCRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAASGN.PERNASG.ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS_10G.PDABENE.PDRBENE.RETRIEVE_SEX_AND_BIRTH_DATE forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAMR87.PDRMR87.ID."POST-CHANGE" forms-module-procedure : BANNER7_FORMS_10G.NOAEPAF.EDIT_ID forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAPERS.PDRPERS.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDICLST.KEY_BLOCK.BENE_ID."POST-CHANGE" forms-module-trigger : BANNER7_FORMS_10G.PEAFMLA.EDIT_ID forms-data-block-trigger : BANNER7_FORMS_10G.PEAFMLA.KEY_BLOCK.CHECK_KEYS forms-data-block-item-trigger : BANNER7_FORMS_10G.NHIEDST.KEY_BLOCK.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDADEMO.PERDEMO.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.PDAF496.PDRF496.ID."POST-CHANGE" forms-data-block-item-trigger : BANNER7_FORMS_10G.SLARMAT.SLRRMAT.SLRRMAT_PIDM."POST-CHANGE" |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SPBPERS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SPBPERS |
Link between GOVSRVR and SPBPERS| Link Type | Link | Project |
|---|---|---|
| Use (select) | Link Between GOVSRVR and SPBPERS | BANINST1 |
| Link type | Between | And |
|---|---|---|
| Use (select) | GOVSRVR | SPBPERS |
Link between GOVSRVR and SPRIDEN| Link Type | Link | Project |
|---|---|---|
| Use (select) | Link Between GOVSRVR and SPRIDEN | BANINST1 |
| Link type | Between | And |
|---|---|---|
| Use (select) | GOVSRVR | SPRIDEN |
Link between GOVSRVR and GOBSRVR| Link Type | Link | Project |
|---|---|---|
| Use (select) | Link Between GOVSRVR and GOBSRVR | BANINST1 |
| Link type | Between | And |
|---|---|---|
| Use (select) | GOVSRVR | GOBSRVR |
Link between SPRADDR and SPRIDEN| Objects list |
|---|
| schema-view : S4B70.BANINST1.AOVCOMP
forms-module-trigger : BANNER7_FORMS.FRA134B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA272B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRAGENB.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA269R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA272R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRAGENR.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA270B.DISPLAY_FIELDS schema-view : S4B70.BANINST1.SPVPERS schema-view : S4B70.BANINST1.SOVGEOR schema-view : S4B70.BANINST1.SPVADDS forms-module-trigger : BANNER7_FORMS_10G.FRA134B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA272B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRAGENB.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA269R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA272R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRAGENR.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA270B.DISPLAY_FIELDS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRADDR and SPRIDEN | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRADDR | SPRIDEN |
Link between SPRADDR and STVATYP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between SPRADDR and STVATYP (FK1_SPRADDR_INV_STVATYP_CODE) | SATURN |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| SPRADDR | SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP | (1,1)-(0,n) |
Link between GOBDIRO and GTVDIRO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBDIRO and GTVDIRO (FK1_GOBDIRO_INV_GTVDIRO_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBDIRO | GOBDIRO_DIRO_CODE | GTVDIRO_CODE | GTVDIRO | (1,1)-(0,1) |
Link between GORSRVR and GOBSRVR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSRVR and GOBSRVR (FK1_GORSRVR_INV_GOBSRVR_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSRVR | GORSRVR_PIDM | GOBSRVR_PIDM | GOBSRVR | (1,1)-(0,n) |
| GORSRVR | GORSRVR_NAME | GOBSRVR_NAME | GOBSRVR | (1,1)-(0,n) |
Link between GURSRVQ and GUBSRVY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GURSRVQ and GUBSRVY (FK1_GURSRVQ_INV_GUBSRVY_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GURSRVQ | GURSRVQ_NAME | GUBSRVY_NAME | GUBSRVY | (1,1)-(0,n) |
Link between GURSVRL and GUBSRVY| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GURSVRL and GUBSRVY (FK1_GURSVRL_INV_GUBSRVY_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GURSVRL | GURSVRL_NAME | GUBSRVY_NAME | GUBSRVY | (1,1)-(0,n) |
Link between GOREMAL and GTVEMAL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOREMAL and GTVEMAL (FK1_GOREMAL_INV_GTVEMAL_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOREMAL | GOREMAL_EMAL_CODE | GTVEMAL_CODE | GTVEMAL | (1,1)-(0,n) |
Link between GORDADD and GOBDIRO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORDADD and GOBDIRO (FK1_GORDADD_INV_GOBDIRO_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORDADD | GORDADD_DIRO_CODE | GOBDIRO_DIRO_CODE | GOBDIRO | (1,1)-(0,n) |
Link between GORDPRF and GOBDIRO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORDPRF and GOBDIRO (FK1_GORDPRF_INV_GOBDIRO_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORDPRF | GORDPRF_DIRO_CODE | GOBDIRO_DIRO_CODE | GOBDIRO | (1,1)-(0,n) |
Link between SPRIDEN and GOBSRVR| Objects list |
|---|
| schema-view : S4B70.BANINST1.GOVSRVR |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GOBSRVR | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GOBSRVR |