Model Recruiting Tables
| Object Name | Object Type | Layer Name |
|---|---|---|
| SRBPRED | TABLE | Default |
| SRBRECR | TABLE | Default |
| SRBWPDS | TABLE | Default |
| SRBWPRO | TABLE | Default |
| SRRCHRT | TABLE | Default |
| SRRLEND | TABLE | Default |
| SRRRATT | TABLE | Default |
| SRRRCMT | TABLE | Default |
| SRRRSRC | TABLE | Default |
| SRRVIST | TABLE | Default |
| SRRWACK | TABLE | Default |
| SRTADDR | TABLE | Default |
| SRTEMAL | TABLE | Default |
| SRTHSCH | TABLE | Default |
| SRTIDEN | TABLE | Default |
| SRTINTL | TABLE | Default |
| SRTINTS | TABLE | Default |
| SRTLEND | TABLE | Default |
| SRTMATL | TABLE | Default |
| SRTPCOL | TABLE | Default |
| SRTPERS | TABLE | Default |
| SRTPREL | TABLE | Default |
| SRTRECR | TABLE | Default |
| SRTTELE | TABLE | Default |
| SRTTEST | TABLE | Default |
| SRTTPFD | TABLE | Default |

Table SRBPRED
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SRBPRED_PREL_CODE | SRBPRED_PREL_CODE | VARCHAR2(10) | No | * | |
| SRBPRED_LEVL_CODE | SRBPRED_LEVL_CODE | VARCHAR2(2) | No | * | |
| SRBPRED_ACTIVITY_DATE | SRBPRED_ACTIVITY_DATE | DATE | No | ||
| SRBPRED_TAPE_ID | SRBPRED_TAPE_ID | VARCHAR2(6) | Yes | ||
| SRBPRED_TERM_CODE | SRBPRED_TERM_CODE | VARCHAR2(6) | Yes | * | |
| SRBPRED_RECR_CODE | SRBPRED_RECR_CODE | VARCHAR2(3) | Yes | * | |
| SRBPRED_RTYP_CODE | SRBPRED_RTYP_CODE | VARCHAR2(2) | Yes | * | |
| SRBPRED_STYP_CODE | SRBPRED_STYP_CODE | VARCHAR2(1) | Yes | * | |
| SRBPRED_EGOL_CODE | SRBPRED_EGOL_CODE | VARCHAR2(2) | Yes | * | |
| SRBPRED_VTYP_CODE | SRBPRED_VTYP_CODE | VARCHAR2(2) | Yes | ||
| SRBPRED_TSRC_CODE | SRBPRED_TSRC_CODE | VARCHAR2(4) | Yes | * | |
| SRBPRED_SBGI_CODE | SRBPRED_SBGI_CODE | VARCHAR2(6) | Yes | * | |
| SRBPRED_CTYP_CODE | SRBPRED_CTYP_CODE | VARCHAR2(3) | Yes | * | |
| SRBPRED_TERM_CODE_CTLG | SRBPRED_TERM_CODE_CTLG | VARCHAR2(6) | Yes | ||
| SRBPRED_PROGRAM | SRBPRED_PROGRAM | VARCHAR2(12) | Yes | * | |
| SRBPRED_DEGC_CODE | SRBPRED_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SRBPRED_CAMP_CODE | SRBPRED_CAMP_CODE | VARCHAR2(3) | Yes | * | |
| SRBPRED_COLL_CODE | SRBPRED_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SRBPRED_MAJR_CODE | SRBPRED_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SRBPRED_DEPT_CODE | SRBPRED_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SRBPRED_RSTA_CODE | SRBPRED_RSTA_CODE | VARCHAR2(2) | Yes | * | |
| SRBPRED_ADMT_CODE | SRBPRED_ADMT_CODE | VARCHAR2(2) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SRBPRED_PROGRAM | SMRPRLE_PROGRAM | SMRPRLE |
| SRBPRED_RSTA_CODE | STVRSTA_CODE | STVRSTA |
| SRBPRED_CAMP_CODE | STVCAMP_CODE | STVCAMP |
| SRBPRED_LEVL_CODE | STVLEVL_CODE | STVLEVL |
| SRBPRED_TERM_CODE | STVTERM_CODE | STVTERM |
| SRBPRED_COLL_CODE | STVCOLL_CODE | STVCOLL |
| SRBPRED_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| SRBPRED_ADMT_CODE | STVADMT_CODE | STVADMT |
| SRBPRED_RTYP_CODE | STVRTYP_CODE | STVRTYP |
| SRBPRED_STYP_CODE | STVSTYP_CODE | STVSTYP |
| SRBPRED_EGOL_CODE | STVEGOL_CODE | STVEGOL |
| SRBPRED_CTYP_CODE | STVCTYP_CODE | STVCTYP |
| SRBPRED_DEGC_CODE | STVDEGC_CODE | STVDEGC |
| SRBPRED_DEPT_CODE | STVDEPT_CODE | STVDEPT |
| SRBPRED_TSRC_CODE | STVTSRC_CODE | STVTSRC |
| SRBPRED_RECR_CODE | STVRECR_CODE | STVRECR |
| SRBPRED_SBGI_CODE | STVSBGI_CODE | STVSBGI |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SRBPRED | Unique | SRBPRED_PREL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| initialize_srbpred_variables | C/C++ Function | [F:\BANNER\C\SRTLOAD.PC] | Use(select ) |
| SRBPRED | SYNONYM | S4B70.PUBLIC | Rely on () |
| WHEN-BUTTON-PRESSED | Forms Trigger | BANNER7_FORMS.SRAPRED.BUTTON_CONTROL_BLOCK.CLEAR_DEFAULTS_BTN | Use(delete ) |
| WHEN-BUTTON-PRESSED | Forms Trigger | BANNER7_FORMS_10G.SRAPRED.BUTTON_CONTROL_BLOCK.CLEAR_DEFAULTS_BTN | Use(delete ) |
| SRBPRED_CUR | Package cursor | S4B70.BANINST1.BWSKWPRV | Use(select ) |
| P_INSERT_INTL | Package procedure | S4B70.BANINST1.SRKPREL | Use(select ) |
| P_INSERT_SRBRECR | Package procedure | S4B70.BANINST1.SRKPREL | Use(select ) |
| SRBPRED | Forms DataBlock | BANNER7_FORMS.SRAPRED | Rely on () Use(insert,update,delete,select ) |
| SRBPRED | Forms DataBlock | BANNER7_FORMS_10G.SRAPRED | Rely on () Use(insert,update,delete,select ) |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_SRBPRED | INDEX | S4B70.SATURN | Rely on () |
| SMRPRLE | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVADMT | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVCAMP | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVCOLL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVCTYP | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVDEGC | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVDEPT | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVEGOL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVLEVL | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVMAJR | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVRECR | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVRSTA | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVRTYP | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVSBGI | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVSTYP | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVTERM | TABLE | S4B70.SATURN | Refer( No Action ) |
| STVTSRC | TABLE | S4B70.SATURN | Refer( No Action ) |
Table SRBRECR
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SRBRECR_PIDM | SRBRECR_PIDM | NUMBER(8,0) | No | * | * |
| SRBRECR_TERM_CODE | SRBRECR_TERM_CODE | VARCHAR2(6) | No | * | * |
| SRBRECR_ADMIN_SEQNO | SRBRECR_ADMIN_SEQNO | NUMBER(2,0) | No | * | |
| SRBRECR_DEPT_CODE | SRBRECR_DEPT_CODE | VARCHAR2(4) | Yes | * | |
| SRBRECR_LEVL_CODE | SRBRECR_LEVL_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_DEGC_CODE | SRBRECR_DEGC_CODE | VARCHAR2(6) | Yes | * | |
| SRBRECR_MAJR_CODE | SRBRECR_MAJR_CODE | VARCHAR2(4) | Yes | * | |
| SRBRECR_RECR_CODE | SRBRECR_RECR_CODE | VARCHAR2(3) | Yes | * | |
| SRBRECR_RSTA_CODE | SRBRECR_RSTA_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_ACTIVITY_DATE | SRBRECR_ACTIVITY_DATE | DATE | No | ||
| SRBRECR_SELECT_IND | SRBRECR_SELECT_IND | VARCHAR2(1) | Yes | ||
| SRBRECR_ADD_DATE | SRBRECR_ADD_DATE | DATE | No | ||
| SRBRECR_ADMT_CODE | SRBRECR_ADMT_CODE | VARCHAR2(2) | Yes | ||
| SRBRECR_CAMP_CODE | SRBRECR_CAMP_CODE | VARCHAR2(3) | Yes | ||
| SRBRECR_COLL_CODE | SRBRECR_COLL_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_MAJR_CODE2 | SRBRECR_MAJR_CODE2 | VARCHAR2(4) | Yes | * | |
| SRBRECR_EDLV_CODE | SRBRECR_EDLV_CODE | VARCHAR2(3) | Yes | * | |
| SRBRECR_EGOL_CODE | SRBRECR_EGOL_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_FULL_PART_IND | SRBRECR_FULL_PART_IND | VARCHAR2(1) | Yes | ||
| SRBRECR_SBGI_CODE | SRBRECR_SBGI_CODE | VARCHAR2(6) | Yes | * | |
| SRBRECR_WRSN_CODE | SRBRECR_WRSN_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_RTYP_CODE | SRBRECR_RTYP_CODE | VARCHAR2(2) | Yes | * | |
| SRBRECR_RESD_CODE | SRBRECR_RESD_CODE | VARCHAR2(1) | Yes | * | |
| SRBRECR_SESS_CODE | SRBRECR_SESS_CODE | VARCHAR2(1) | Yes | * | |
| SRBRECR_SITE_CODE | SRBRECR_SITE_CODE | VARCHAR2(3) | Yes | * | |
| SRBRECR_STYP_CODE | SRBRECR_STYP_CODE | VARCHAR2(1) | Yes | * | |
| SRBRECR_PROGRAM_1 | SRBRECR_PROGRAM_1 | VARCHAR2(12) | Yes | * | |
| SRBRECR_TERM_CODE_CTLG_1 | SRBRECR_TERM_CODE_CTLG_1 | VARCHAR2(6) | Yes | * | |
| SRBRECR_DEPT_CODE_2 | SRBRECR_DEPT_CODE_2 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_111 | SRBRECR_MAJR_CODE_CONC_111 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_112 | SRBRECR_MAJR_CODE_CONC_112 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_113 | SRBRECR_MAJR_CODE_CONC_113 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_121 | SRBRECR_MAJR_CODE_CONC_121 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_122 | SRBRECR_MAJR_CODE_CONC_122 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_CONC_123 | SRBRECR_MAJR_CODE_CONC_123 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_MINR_1 | SRBRECR_MAJR_CODE_MINR_1 | VARCHAR2(4) | Yes | * | |
| SRBRECR_MAJR_CODE_MINR_1_2 | SRBRECR_MAJR_CODE_MINR_1_2 | VARCHAR2(4) | Yes | * | |
| SRBRECR_CURR_RULE_1 | SRBRECR_CURR_RULE_1 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CMJR_RULE_1_1 | SRBRECR_CMJR_RULE_1_1 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_11_1 | SRBRECR_CCON_RULE_11_1 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_11_2 | SRBRECR_CCON_RULE_11_2 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_11_3 | SRBRECR_CCON_RULE_11_3 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CMJR_RULE_1_2 | SRBRECR_CMJR_RULE_1_2 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_12_1 | SRBRECR_CCON_RULE_12_1 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_12_2 | SRBRECR_CCON_RULE_12_2 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CCON_RULE_12_3 | SRBRECR_CCON_RULE_12_3 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CMNR_RULE_1_1 | SRBRECR_CMNR_RULE_1_1 | NUMBER(8,0) | Yes | * | |
| SRBRECR_CMNR_RULE_1_2 | SRBRECR_CMNR_RULE_1_2 | NUMBER(8,0) | Yes | * | |
| SRBRECR_DATA_ORIGIN | SRBRECR_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SRBRECR_USER_ID | SRBRECR_USER_ID | VARCHAR2(30) | Yes |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SRBRECR | Unique | SRBRECR_PIDM |
| PK_SRBRECR | Unique | SRBRECR_TERM_CODE |
| PK_SRBRECR | Unique | SRBRECR_ADMIN_SEQNO |
| SRBRECR_KEY_INDEX2 | SRBRECR_RECR_CODE | |
| SRBRECR_KEY_INDEX2 | SRBRECR_TERM_CODE |