Model Employee Health and Safety
Object Name | Object Type | Layer Name |
---|---|---|
NBBPOSN | SQL Table | Default |
NBRBJOB | SQL Table | Default |
PEAPNHZ | SQL Table | Default |
PEBEMPL | SQL Table | Default |
PEBGREV | SQL Table | Default |
PEBHSIN | SQL Table | Main Objects |
PERGRPA | SQL Table | Default |
PERGRRA | SQL Table | Default |
PERHSCT | SQL Table | Default |
PERHSFC | SQL Table | Default |
PERHSID | SQL Table | Default |
PERHSIH | SQL Table | Default |
PERHSIM | SQL Table | Default |
PERHSIP | SQL Table | Default |
PERHSIT | SQL Table | Default |
PERHSRA | SQL Table | Default |
PTRHAZD | SQL Table | Default |
PTRHSIL | SQL Table | Default |
PTRHSME | SQL Table | Default |
PTRHZCM | SQL Table | Default |
PTRHZPR | SQL Table | Default |
PTRHZTP | SQL Table | Default |
PTVDISA | SQL Table | Default |
PTVGRPT | SQL Table | Default |
PTVGRSR | SQL Table | Default |
PTVGRTP | SQL Table | Default |
PTVHSCR | SQL Table | Default |
PTVHSLT | SQL Table | Default |
PTVHSMT | SQL Table | Default |
PTVHSPC | SQL Table | Default |
PTVHSTC | SQL Table | Default |
PTVHZSP | SQL Table | Default |
PTVHZTC | SQL Table | Default |
PTVISTA | SQL Table | Default |
PTVLITG | SQL Table | Default |
PTVMANU | SQL Table | Default |
PTVRSTA | SQL Table | Default |
SPRIDEN | SQL Table | Default |
STVNATN | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
NBBPOSN_POSN |   | VARCHAR2(6) | No | * | * |
NBBPOSN_STATUS |   | VARCHAR2(1) | No |   |   |
NBBPOSN_TITLE |   | VARCHAR2(30) | No |   |   |
NBBPOSN_PLOC_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_BEGIN_DATE |   | DATE | No |   |   |
NBBPOSN_END_DATE |   | DATE | Yes |   |   |
NBBPOSN_TYPE |   | VARCHAR2(1) | No |   |   |
NBBPOSN_PCLS_CODE |   | VARCHAR2(5) | No |   | * |
NBBPOSN_ECLS_CODE |   | VARCHAR2(2) | No |   | * |
NBBPOSN_POSN_REPORTS |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_AUTH_NUMBER |   | VARCHAR2(9) | Yes |   |   |
NBBPOSN_TABLE |   | VARCHAR2(2) | No |   |   |
NBBPOSN_GRADE |   | VARCHAR2(5) | No |   |   |
NBBPOSN_STEP |   | NUMBER(3,0) | Yes |   |   |
NBBPOSN_APPT_PCT |   | NUMBER(5,2) | No |   |   |
NBBPOSN_CIPC_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_ROLL_IND |   | VARCHAR2(1) | No |   |   |
NBBPOSN_COAS_CODE |   | VARCHAR2(1) | Yes |   |   |
NBBPOSN_ACTIVITY_DATE |   | DATE | No |   |   |
NBBPOSN_SGRP_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_PGRP_CODE |   | VARCHAR2(4) | Yes |   |   |
NBBPOSN_WKSH_CODE |   | VARCHAR2(4) | Yes |   | * |
NBBPOSN_PREMIUM_ROLL_IND |   | VARCHAR2(1) | No |   |   |
NBBPOSN_PFOC_CODE |   | VARCHAR2(3) | Yes |   |   |
NBBPOSN_PNOC_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_DOTT_CODE |   | VARCHAR2(11) | Yes |   |   |
NBBPOSN_CHANGE_DATE_TIME |   | DATE | No |   |   |
NBBPOSN_CALIF_TYPE |   | VARCHAR2(1) | Yes |   |   |
NBBPOSN_EXEMPT_IND |   | VARCHAR2(1) | No |   |   |
NBBPOSN_JBLN_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_BARG_CODE |   | VARCHAR2(2) | Yes |   |   |
NBBPOSN_PROBATION_UNITS |   | NUMBER(3,0) | Yes |   |   |
NBBPOSN_COMMENT |   | VARCHAR2(2000) | Yes |   |   |
NBBPOSN_ACCRUE_SENIORITY_IND |   | VARCHAR2(1) | No |   |   |
NBBPOSN_JOBP_CODE |   | VARCHAR2(5) | Yes |   |   |
NBBPOSN_BPRO_CODE |   | VARCHAR2(6) | Yes |   |   |
NBBPOSN_BUDGET_TYPE |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
NBBPOSN_WKSH_CODE | NTVWKSH_CODE | NTVWKSH |
NBBPOSN_PCLS_CODE | NTRPCLS_CODE | NTRPCLS |
NBBPOSN_POSN | NBRJOBS_POSN | NBRJOBS |
NBBPOSN_ECLS_CODE | PTREERN_ECLS_CODE | PTREERN |
Index Name | Index Type | Column Name |
---|---|---|
NBBPOSN_BPRO_INDEX |   | NBBPOSN_BPRO_CODE |
PK_NBBPOSN | Unique | NBBPOSN_POSN |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
NBRBJOB | SQL Table | S10B80.POSNCTL | Refer (no action) |
NBRFTOT | SQL Table | S10B80.POSNCTL | Refer (no action) |
NBRPLBD | SQL Table | S10B80.POSNCTL | Refer (no action) |
NBRPOSH | SQL Table | S10B80.POSNCTL | Join |
NBRPTOT | SQL Table | S10B80.POSNCTL | Refer (no action) |
NBRRTOT | SQL Table | S10B80.POSNCTL | Refer (no action) |
NTRJOBP | SQL Table | S10B80.POSNCTL | Join |
NTRSALB | SQL Table | S10B80.POSNCTL | Join |
PABAPPL | SQL Table | S10B80.PAYROLL | Join |
PABPFAC | SQL Table | S10B80.PAYROLL | Refer (no action) |
PABREQU | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPCER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPCON | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPDEG | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPDES | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPEND | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPEXM | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPMAJ | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPMIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PARPSKL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PEAPNHZ | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFASG | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFISO | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFJER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFJLD | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFJOB | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFNIO | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFNIS | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERJFAC | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERSNBL | SQL Table | S10B80.PAYROLL | Join |
PHREARN | SQL Table | S10B80.PAYROLL | Join |
PTRECLS | SQL Table | S10B80.PAYROLL | Join |
PTRINSE | SQL Table | S10B80.PAYROLL | Refer (no action) |
PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
PAVREQ1 | SQL View | S10B80.BANINST1 | Use (select) |
PBVSLB1 | SQL View | S10B80.BANINST1 | Use (select) |
PEVACP2 | SQL View | S10B80.BANINST1 | Use (select) |
PEVEPRO | SQL View | S10B80.BANINST1 | Use (select) |
PEVJOB1 | SQL View | S10B80.BANINST1 | Use (select) |
PEVJOBS | SQL View | S10B80.BANINST1 | Use (select) |
PEVPCSN | SQL View | S10B80.BANINST1 | Use (select) |
PEVREC1 | SQL View | S10B80.BANINST1 | Use (select) |
PEVVER2 | SQL View | S10B80.BANINST1 | Use (select) |
F_PRIM_SKILL_CODE | SQL Function | S10B80.BANINST1 | Use (select) |
NBBPOSN_RECTYPE | Oracle Package Type | S10B80.BANINST1.NBKRECS | Rely On |
NBBPOSN_C | Oracle Package Cursor | S10B80.BANINST1.PEKFASG | Rely On |
NBBPOSN_C | Oracle Package Cursor | S10B80.BANINST1.PEKFASG | Use (select) |
NBBPOSN_C | Oracle Package Cursor | S10B80.BANINST1.PEKFLAC | Use (select) |
NBBPOSN_C | Oracle Package Cursor | S10B80.BANINST1.NP_JOB_ASSIGNMENT | Rely On |
NBBPOSN_C | Oracle Package Cursor | S10B80.BANINST1.NP_JOB_ASSIGNMENT | Use (select) |
POSN_EXISTS | Oracle Package Procedure | S10B80.BANINST1.POKPVAL | Use (select) |
P_APPLY_DEFAULTS | Oracle Package Procedure | S10B80.BANINST1.NOKEDIT | Rely On |
P_CREATE_DEFAULT_WORK_SCHED | Oracle Package Procedure | S10B80.BANINST1.NP_JOB_ASSIGNMENT | Rely On |
P_EXTRACT_NBREPSA | Oracle Package Procedure | S10B80.BANINST1.NBKBUDG | Use (select) |
P_GET_PAY_DATES | Oracle Package Procedure | S10B80.BANINST1.PEKFASG | Rely On |
P_GET_PAY_DATES | Oracle Package Procedure | S10B80.BANINST1.PEKFASG | Use (select) |
P_GET_POSITION_DATA | Oracle Package Procedure | S10B80.BANINST1.NBKEARN | Use (select) |
P_PRINT_POSN_ITEMS | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Use (select) |
P_SALARY_VIEW_LOCKED | Oracle Package Procedure | S10B80.BANINST1.BWPKFCFT | Rely On |
LV_OVERLOAD_POSN_TITLE | Oracle Package Variable | S10B80.BANINST1.BWPKFCFT | Rely On |
NBBPOSN_ROW | Oracle Package Variable | S10B80.BANINST1.PEKFASG | Rely On |
NBBPOSN_ROW | Oracle Package Variable | S10B80.BANINST1.PEKFLAC | Rely On |
POSN_COAS | Oracle Package Variable | S10B80.BANINST1.BWPKEPDT | Rely On |
POSN_TITLE | Oracle Package Variable | S10B80.BANINST1.BWPKSPOS | Rely On |
SELECTED_POSN | Oracle Package Variable | S10B80.BANINST1.BWPKFCFT | Rely On |
F_POSITION_EXISTS | Oracle Package Function | S10B80.BANINST1.NB_JOB_LABOR_RULES | Rely On |
F_POSITION_EXISTS | Oracle Package Function | S10B80.BANINST1.NB_JOB_LABOR_RULES | Use (select) |
F_PRIM_SKILL_CODE | Oracle Package Function | S10B80.BANINST1.PEKDEGR | Use (select) |
GET_NBBPOSN | Oracle Package Cursor | S10B80.BANINST1.NOKEDIT | Use (select)Rely On |
GET_NBBPOSN | Oracle Package Cursor | S10B80.BANINST1.NBKBUDG | Use (select)Rely On |
GET_NULL_REVW_C | Oracle Package Cursor | S10B80.BANINST1.BWPCBREF | Use (select) |
P_ACCRUE_SENIORITY_HOURS | Oracle Package Procedure | S10B80.BANINST1.PEKSNBL | Use (select) |
P_BUILDPATRECR | Oracle Package Procedure | S10B80.BANINST1.PAKRECR | Use (select) |
P_BUILDPETWEMP | Oracle Package Procedure | S10B80.BANINST1.PEKWEMP | Use (select) |
P_CHECK_POSN_EXISTS | Oracle Package Procedure | S10B80.BANINST1.PEKFLAC | Rely On |
P_CREATE | Oracle Package Procedure | S10B80.BANINST1.NP_JOB_ASSIGNMENT | Rely On |
P_CREATE_CSV | Oracle Package Procedure | S10B80.BANINST1.BWPKTEST | Rely On |
P_CREATE_CSV | Oracle Package Procedure | S10B80.BANINST1.BWPKFLDT | Rely On |
P_CREATE_ROUTING_QUEUE | Oracle Package Procedure | S10B80.BANINST1.PEKTECM | Rely On |
P_CREATE_ROUTING_QUEUE | Oracle Package Procedure | S10B80.BANINST1.PEKTECM | Use (select)Rely On |
P_EDIT_ECLS | Oracle Package Procedure | S10B80.BANINST1.NBKD2SB | Rely On |
P_EDIT_ECLS | Oracle Package Procedure | S10B80.BANINST1.NBKD2SB | Use (select) |
P_EDIT_IPEDS_REPORTABLE | Oracle Package Procedure | S10B80.BANINST1.NOKP3LB | Use (select) |
P_EDIT_POSN | Oracle Package Procedure | S10B80.BANINST1.NBKD2SB | Use (select) |
P_EDIT_POSN_COAS | Oracle Package Procedure | S10B80.BANINST1.NBKD2SB | Use (select) |
P_GET_PAF_POSN_INFO | Oracle Package Procedure | S10B80.BANINST1.POKWLIB | Rely On |
P_GET_PAF_POSN_INFO | Oracle Package Procedure | S10B80.BANINST1.POKWLIB | Use (select) |
P_GET_POSITION_DATA | Oracle Package Procedure | S10B80.BANINST1.NBKJLBD | Use (select) |
P_NBBPOSN_AUR | Oracle Package Procedure | S10B80.BANINST1.EOKPRTS | Rely On |
P_NEXT_APPROVER | Oracle Package Procedure | S10B80.BANINST1.NOKMISC | Use (select) |
P_NOBTRANPAFCHANGE | Oracle Package Procedure | S10B80.BANINST1.NOKWEVN | Rely On |
P_PABAPPL_AIR | Oracle Package Procedure | S10B80.BANINST1.EOKPRTS | Use (select) |
P_PRINTEMPLOYEE | Oracle Package Procedure | S10B80.BANINST1.BWPKSMEX | Rely On |
P_PRINTPOSITION | Oracle Package Procedure | S10B80.BANINST1.BWPKSMEX | Rely On |
P_PRINT_ASSIGNMENT | Oracle Package Procedure | S10B80.BANINST1.BWPKFLDT | Rely On |
P_PRINT_JOBS_SELECTION | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Rely On |
P_PRINT_POSN_SELECTION | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Rely On |
P_SALARY_VIEW | Oracle Package Procedure | S10B80.BANINST1.BWPKFCFT | Rely On |
P_TEST_CHECKBOX | Oracle Package Procedure | S10B80.BANINST1.BWPKTEST | Rely On |
P_UPDATE | Oracle Package Procedure | S10B80.BANINST1.NP_JOB_ASSIGNMENT | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.NB_JOB_DETAIL_RULES | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.NB_JOB_DETAIL_RULES | Use (select)Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.NB_JOB_BASE_RULES | Rely On |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.NB_JOB_BASE_RULES | Use (select)Rely On |
P_VALIDATE_BEGIN_DATE_VS_POSN | Oracle Package Procedure | S10B80.BANINST1.NBKBJOB | Rely On |
P_VALIDATE_CONTRACT_BEGIN_DATE | Oracle Package Procedure | S10B80.BANINST1.NBKBJOB | Rely On |
P_VALIDATE_CONTRACT_END_DATE | Oracle Package Procedure | S10B80.BANINST1.NBKBJOB | Rely On |
P_VALIDATE_EFF_DATE_VS_POSN | Oracle Package Procedure | S10B80.BANINST1.NBKJOBS | Rely On |
P_VALIDATE_JOB | Oracle Package Procedure | S10B80.BANINST1.BWPKEPCR | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_JOB_EARNINGS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_JOBDISTR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_JOB_ENC_HISTORY | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_JOBDETAIL | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_ISOLCOMP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_NIOLCOMP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_JOBEARNS | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_NB_JOB_LABOR | Use (Insert,select) |
F_ACCRUE_SENIORITY_IND | Oracle Package Function | S10B80.BANINST1.PEKSNBL | Use (select) |
F_CHECK_POSN_IS_VALID_ACTIVE | Oracle Package Function | S10B80.BANINST1.SIKAFLA | Rely On |
F_GET_POSN_ECLS | Oracle Package Function | S10B80.BANINST1.NOKPLIB | Use (select) |
F_NBBPOSN_REC | Oracle Package Function | S10B80.BANINST1.NBKRECS | Rely On |
F_ORDER_BY_PCLS | Oracle Package Function | S10B80.BANINST1.PEKSNBL | Rely On |
F_POSN_BEGIN_DATE | Oracle Package Function | S10B80.BANINST1.NBKD2SB | Use (select) |
F_POSN_EXISTS | Oracle Package Function | S10B80.BANINST1.NBKD2SB | Use (select) |
NBBPOSN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
NBBPOSN_BPRO_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
PK_NBBPOSN | SQL Index | S10B80.POSNCTL | Rely On |
NBRJOBS | SQL Table | S10B80.POSNCTL | Join |
NTRPCLS | SQL Table | S10B80.POSNCTL | Refer (no action) |
NTVWKSH | SQL Table | S10B80.POSNCTL | Refer (no action) |
PTREERN | SQL Table | S10B80.PAYROLL | Join |
ET_NBBPOSN_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
NT_NBBPOSN_DELETE_HISTORY | SQL Trigger | S10B80.POSNCTL | Fire (delete,after,each row) |
NT_NBBPOSN_INSERT_HISTORY | SQL Trigger | S10B80.POSNCTL | Fire (Insert,after,each row) |
NT_NBBPOSN_UPDATE_HISTORY | SQL Trigger | S10B80.POSNCTL | Fire (update,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:30:45:000 | 04/02/2008 13:49:04:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
NBRBJOB_PIDM |   | NUMBER(8,0) | No | * | * |
NBRBJOB_POSN |   | VARCHAR2(6) | No | * | * |
NBRBJOB_SUFF |   | VARCHAR2(2) | No | * | * |
NBRBJOB_BEGIN_DATE |   | DATE | No |   |   |
NBRBJOB_END_DATE |   | DATE | Yes |   |   |
NBRBJOB_DEFER_BAL |   | NUMBER(11,2) | No |   |   |
NBRBJOB_CONTRACT_TYPE |   | VARCHAR2(1) | No |   |   |
NBRBJOB_SALARY_ENCUMBRANCE |   | NUMBER(11,2) | No |   |   |
NBRBJOB_CONTRACT_BEGIN_DATE |   | DATE | Yes |   |   |
NBRBJOB_CONTRACT_END_DATE |   | DATE | Yes |   |   |
NBRBJOB_TOTAL_CONTRACT_HRS |   | NUMBER(6,2) | Yes |   |   |
NBRBJOB_TOTAL_ENCUMBRANCE_HRS |   | NUMBER(6,2) | Yes |   |   |
NBRBJOB_STEP_INCR_MON |   | VARCHAR2(2) | Yes |   |   |
NBRBJOB_STEP_INCR_DAY |   | VARCHAR2(2) | Yes |   |   |
NBRBJOB_COAS_CODE |   | VARCHAR2(1) | Yes |   |   |
NBRBJOB_ACTIVITY_DATE |   | DATE | No |   |   |
NBRBJOB_ACCRUE_LEAVE_IND |   | VARCHAR2(1) | No |   |   |
NBRBJOB_CIVIL_SERVICE_IND |   | VARCHAR2(1) | No |   |   |
NBRBJOB_ENCUMBRANCE_CHANGE_IND |   | VARCHAR2(1) | No |   |   |
NBRBJOB_FRINGE_ENCUMBRANCE |   | NUMBER(11,2) | Yes |   |   |
NBRBJOB_IPEDS_REPT_IND |   | VARCHAR2(1) | No |   |   |
NBRBJOB_FACL_STATSCAN_REPT_IND |   | VARCHAR2(1) | No |   |   |
NBRBJOB_PROBATION_BEGIN_DATE |   | DATE | Yes |   |   |
NBRBJOB_PROBATION_END_DATE |   | DATE | Yes |   |   |
NBRBJOB_PROBATION_UNITS |   | NUMBER(3,0) | Yes |   |   |
NBRBJOB_ELIGIBLE_DATE |   | DATE | Yes |   |   |
NBRBJOB_USER_ID |   | VARCHAR2(30) | Yes |   |   |
NBRBJOB_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
NBRBJOB_FUTURE_SALARY_ENC |   | NUMBER(17,2) | Yes |   |   |
NBRBJOB_FUTURE_FRINGE_ENC |   | NUMBER(17,2) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
NBRBJOB_POSN | NBBPOSN_POSN | NBBPOSN |
NBRBJOB_PIDM | PEBEMPL_PIDM | PEBEMPL |
NBRBJOB_PIDM | PERJLEV_PIDM | PERJLEV |
NBRBJOB_POSN | PERJLEV_POSN | PERJLEV |
NBRBJOB_SUFF | PERJLEV_SUFF | PERJLEV |
NBRBJOB_POSN | NBREPSA_POSN | NBREPSA |
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 |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
NBRBJOB_KEY2_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
NBRBJOB_KEY_INDEX | SQL Index | S10B80.POSNCTL | Rely On |
PK_NBRBJOB | SQL Index | S10B80.POSNCTL | Rely On |
NBBPOSN | SQL Table | S10B80.POSNCTL | Refer (no action) |
NBREPSA | SQL Table | S10B80.POSNCTL | Join |
PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
PERJLEV | SQL Table | S10B80.PAYROLL | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:29:22:000 | 04/02/2008 13:49:02:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PEAPNHZ_POSN |   | VARCHAR2(6) | No | * | * |
PEAPNHZ_HAZD_CODE |   | VARCHAR2(4) | No | * | * |
PEAPNHZ_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PEAPNHZ_POSN | NBBPOSN_POSN | NBBPOSN |
PEAPNHZ_HAZD_CODE | PTRHAZD_CODE | PTRHAZD |
Index Name | Index Type | Column Name |
---|---|---|
PK_PEAPNHZ | Unique | PEAPNHZ_POSN |
PK_PEAPNHZ | Unique | PEAPNHZ_HAZD_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PEAPNHZ | SQL Index | S10B80.PAYROLL | Rely On |
NBBPOSN | SQL Table | S10B80.POSNCTL | Refer (no action) |
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:32:42:000 | 04/02/2008 13:49:06:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PEBEMPL_PIDM |   | NUMBER(8,0) | No | * | * |
PEBEMPL_EMPL_STATUS |   | VARCHAR2(1) | No |   |   |
PEBEMPL_COAS_CODE_HOME |   | VARCHAR2(1) | Yes |   |   |
PEBEMPL_ORGN_CODE_HOME |   | VARCHAR2(6) | No |   | * |
PEBEMPL_COAS_CODE_DIST |   | VARCHAR2(1) | Yes |   |   |
PEBEMPL_ORGN_CODE_DIST |   | VARCHAR2(6) | No |   | * |
PEBEMPL_ECLS_CODE |   | VARCHAR2(2) | No |   | * |
PEBEMPL_LCAT_CODE |   | VARCHAR2(2) | No |   | * |
PEBEMPL_BCAT_CODE |   | VARCHAR2(2) | No |   | * |
PEBEMPL_FIRST_HIRE_DATE |   | DATE | No |   |   |
PEBEMPL_CURRENT_HIRE_DATE |   | DATE | No |   |   |
PEBEMPL_ADJ_SERVICE_DATE |   | DATE | No |   |   |
PEBEMPL_SENIORITY_DATE |   | DATE | No |   |   |
PEBEMPL_LREA_CODE |   | VARCHAR2(2) | Yes |   |   |
PEBEMPL_LOA_BEG_DATE |   | DATE | Yes |   |   |
PEBEMPL_LOA_END_DATE |   | DATE | Yes |   |   |
PEBEMPL_TREA_CODE |   | VARCHAR2(2) | Yes |   | * |
PEBEMPL_TERM_DATE |   | DATE | Yes |   |   |
PEBEMPL_I9_FORM_IND |   | VARCHAR2(1) | Yes |   |   |
PEBEMPL_I9_DATE |   | DATE | Yes |   |   |
PEBEMPL_I9_EXPIRE_DATE |   | DATE | Yes |   |   |
PEBEMPL_ACTIVITY_DATE |   | DATE | No |   |   |
PEBEMPL_WKPR_CODE |   | VARCHAR2(4) | Yes |   | * |
PEBEMPL_FLSA_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_STGR_CODE |   | VARCHAR2(2) | Yes |   | * |
PEBEMPL_DAYS_IN_CANADA |   | NUMBER(3,0) | Yes |   |   |
PEBEMPL_1042_RECIPIENT_CD |   | VARCHAR2(2) | Yes |   |   |
PEBEMPL_INTERNAL_FT_PT_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_DICD_CODE |   | VARCHAR2(3) | Yes |   |   |
PEBEMPL_EGRP_CODE |   | VARCHAR2(4) | Yes |   |   |
PEBEMPL_IPEDS_SOFT_MONEY_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_FIRST_WORK_DATE |   | DATE | Yes |   |   |
PEBEMPL_LAST_WORK_DATE |   | DATE | Yes |   |   |
PEBEMPL_CALIF_PENSION_IND |   | VARCHAR2(1) | Yes |   |   |
PEBEMPL_NRSI_CODE |   | VARCHAR2(4) | Yes |   | * |
PEBEMPL_SSN_LAST_NAME |   | VARCHAR2(20) | Yes |   |   |
PEBEMPL_SSN_FIRST_NAME |   | VARCHAR2(15) | Yes |   |   |
PEBEMPL_SSN_MI |   | VARCHAR2(15) | Yes |   |   |
PEBEMPL_SSN_SUFFIX |   | VARCHAR2(4) | Yes |   |   |
PEBEMPL_JBLN_CODE |   | VARCHAR2(6) | Yes |   | * |
PEBEMPL_COLL_CODE |   | VARCHAR2(2) | Yes |   | * |
PEBEMPL_CAMP_CODE |   | VARCHAR2(3) | Yes |   | * |
PEBEMPL_USER_ID |   | VARCHAR2(30) | Yes |   |   |
PEBEMPL_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
PEBEMPL_EW2_CONSENT_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_EW2_CONSENT_DATE |   | DATE | Yes |   |   |
PEBEMPL_EW2_CONSENT_USER_ID |   | VARCHAR2(30) | Yes |   |   |
PEBEMPL_IPEDS_PRIMARY_FUNCTION |   | VARCHAR2(3) | No |   |   |
PEBEMPL_IPEDS_MED_DENTAL_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_ETAX_CONSENT_IND |   | VARCHAR2(1) | No |   |   |
PEBEMPL_ETAX_CONSENT_DATE |   | DATE | Yes |   |   |
PEBEMPL_ETAX_CONSENT_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PEBEMPL_BCAT_CODE | PTRBCAT_CODE | PTRBCAT |
PEBEMPL_ECLS_CODE | PTRECLS_CODE | PTRECLS |
PEBEMPL_JBLN_CODE | PTRJBLN_CODE | PTRJBLN |
PEBEMPL_TREA_CODE | PTRTREA_CODE | PTRTREA |
PEBEMPL_LCAT_CODE | PTVLCAT_CODE | PTVLCAT |
PEBEMPL_NRSI_CODE | PTVNRSI_CODE | PTVNRSI |
PEBEMPL_ORGN_CODE_HOME | PTVORGN_CODE | PTVORGN |
PEBEMPL_ORGN_CODE_DIST | PTVORGN_CODE | PTVORGN |
PEBEMPL_STGR_CODE | PTVSTGR_CODE | PTVSTGR |
PEBEMPL_WKPR_CODE | PTRWKPR_CODE | PTRWKPR |
PEBEMPL_COLL_CODE | STVCOLL_CODE | STVCOLL |
PEBEMPL_CAMP_CODE | STVCAMP_CODE | STVCAMP |
PEBEMPL_PIDM | POTPARM_PIDM | POTPARM |
PEBEMPL_PIDM | PERJLEV_PIDM | PERJLEV |
Index Name | Index Type | Column Name |
---|---|---|
PEBEMPL_HOME_INDEX |   | PEBEMPL_ORGN_CODE_HOME |
PEBEMPL_HOME_INDEX |   | PEBEMPL_COAS_CODE_HOME |
PEBEMPL_HOME_INDEX |   | PEBEMPL_PIDM |
PEBEMPL_KEY2_INDEX | Unique | PEBEMPL_LCAT_CODE |
PEBEMPL_KEY2_INDEX | Unique | PEBEMPL_PIDM |
PEBEMPL_KEY3_INDEX |   | PEBEMPL_ECLS_CODE |
PK_PEBEMPL | Unique | PEBEMPL_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PEBEMPL_HOME_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PEBEMPL_KEY2_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PEBEMPL_KEY3_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PK_PEBEMPL | SQL Index | S10B80.PAYROLL | Rely On |
PERJLEV | SQL Table | S10B80.PAYROLL | Join |
POTPARM | SQL Table | S10B80.PAYROLL | Join |
PTRBCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRECLS | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRTREA | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRWKPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVLCAT | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVNRSI | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVORGN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVSTGR | SQL Table | S10B80.PAYROLL | Refer (no action) |
STVCAMP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCOLL | SQL Table | S10B80.SATURN | Refer (no action) |
ET_PEBEMPL_ADR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (delete,after,each row) |
ET_PEBEMPL_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
ET_PEBEMPL_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
PT_PEBEMPL_AR_LDI | SQL Trigger | S10B80.PAYROLL | Fire (Insert,update,delete,after,each row) |
PT_PEBEMPL_AS_LDI | SQL Trigger | S10B80.PAYROLL | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:36:46:000 | 04/02/2008 13:49:11:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PEBGREV_NO |   | NUMBER(8,0) | No | * |   |
PEBGREV_DESC |   | VARCHAR2(60) | No |   |   |
PEBGREV_GRTP_CODE |   | VARCHAR2(4) | No |   | * |
PEBGREV_ISTA_CODE |   | VARCHAR2(1) | No |   | * |
PEBGREV_ISTA_DATE |   | DATE | No |   |   |
PEBGREV_FILED_DATE |   | DATE | No |   |   |
PEBGREV_RESOLVED_DATE |   | DATE | Yes |   |   |
PEBGREV_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PEBGREV_GRTP_CODE | PTVGRTP_CODE | PTVGRTP |
PEBGREV_ISTA_CODE | PTVISTA_CODE | PTVISTA |
Index Name | Index Type | Column Name |
---|---|---|
PK_PEBGREV | Unique | PEBGREV_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERGRPA | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERGRRA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PEBGREV | SQL Index | S10B80.PAYROLL | Rely On |
PTVGRTP | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVISTA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:00:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PEBHSIN_NO |   | NUMBER(8,0) | No | * |   |
PEBHSIN_DESC |   | VARCHAR2(50) | No |   |   |
PEBHSIN_INCIDENT_DATE |   | DATE | No |   |   |
PEBHSIN_HSIL_CODE |   | VARCHAR2(6) | Yes |   | * |
PEBHSIN_ISTA_CODE |   | VARCHAR2(1) | No |   | * |
PEBHSIN_ISTA_DATE |   | DATE | No |   |   |
PEBHSIN_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PEBHSIN_ISTA_CODE | PTVISTA_CODE | PTVISTA |
PEBHSIN_HSIL_CODE | PTRHSIL_CODE | PTRHSIL |
Index Name | Index Type | Column Name |
---|---|---|
PK_PEBHSIN | Unique | PEBHSIN_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSCT | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSIH | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSIM | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSIP | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSIT | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSRA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PEBHSIN | SQL Index | S10B80.PAYROLL | Rely On |
PTRHSIL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVISTA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:35:42:000 | 04/02/2008 13:49:10:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERGRPA_GREV_NO |   | NUMBER(8,0) | No |   | * |
PERGRPA_PIDM |   | NUMBER(8,0) | No |   | * |
PERGRPA_GRPT_CODE |   | VARCHAR2(4) | No |   | * |
PERGRPA_POSN |   | VARCHAR2(6) | Yes |   | * |
PERGRPA_SUFF |   | VARCHAR2(2) | Yes |   | * |
PERGRPA_GRIEVANT_IND |   | VARCHAR2(1) | Yes |   |   |
PERGRPA_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERGRPA_PIDM | NBRBJOB_PIDM | NBRBJOB |
PERGRPA_POSN | NBRBJOB_POSN | NBRBJOB |
PERGRPA_SUFF | NBRBJOB_SUFF | NBRBJOB |
PERGRPA_GRPT_CODE | PTVGRPT_CODE | PTVGRPT |
PERGRPA_PIDM | PEBEMPL_PIDM | PEBEMPL |
PERGRPA_GREV_NO | PEBGREV_NO | PEBGREV |
Index Name | Index Type | Column Name |
---|---|---|
PERGRPA_KEY_INDEX |   | PERGRPA_GREV_NO |
PERGRPA_KEY_INDEX |   | PERGRPA_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERGRPA_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
NBRBJOB | SQL Table | S10B80.POSNCTL | Refer (no action) |
PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PEBGREV | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVGRPT | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:36:15:000 | 04/02/2008 13:49:10:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERGRRA_GREV_NO |   | NUMBER(8,0) | No |   | * |
PERGRRA_GRSR_CODE |   | VARCHAR2(4) | No |   | * |
PERGRRA_GRSR_DATE |   | DATE | No |   |   |
PERGRRA_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERGRRA_GRSR_CODE | PTVGRSR_CODE | PTVGRSR |
PERGRRA_GREV_NO | PEBGREV_NO | PEBGREV |
Index Name | Index Type | Column Name |
---|---|---|
PERGRRA_KEY_INDEX |   | PERGRRA_GREV_NO |
PERGRRA_KEY_INDEX |   | PERGRRA_GRSR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERGRRA_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PEBGREV | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVGRSR | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:36:24:000 | 04/02/2008 13:49:10:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSCT_HSIN_NO |   | NUMBER(8,0) | No | * | * |
PERHSCT_PIDM |   | NUMBER(8,0) | No | * |   |
PERHSCT_HSCR_CODE |   | VARCHAR2(4) | No | * | * |
PERHSCT_COST |   | NUMBER(12,2) | No |   |   |
PERHSCT_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSCT_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSCT_HSCR_CODE | PTVHSCR_CODE | PTVHSCR |
Index Name | Index Type | Column Name |
---|---|---|
PK_PERHSCT | Unique | PERHSCT_HSIN_NO |
PK_PERHSCT | Unique | PERHSCT_PIDM |
PK_PERHSCT | Unique | PERHSCT_HSCR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PERHSCT | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVHSCR | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:22:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSFC_HSIN_NO |   | NUMBER(8,0) | No |   |   |
PERHSFC_TEXT |   | LONG | Yes |   |   |
PERHSFC_ACTIVITY_DATE |   | DATE | No |   |   |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:26:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSID_HSIN_NO |   | NUMBER(8,0) | No |   |   |
PERHSID_TEXT |   | LONG | Yes |   |   |
PERHSID_ACTIVITY_DATE |   | DATE | No |   |   |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:38:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSIH_HSIN_NO |   | NUMBER(8,0) | No | * | * |
PERHSIH_HAZD_CODE |   | VARCHAR2(4) | No | * | * |
PERHSIH_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSIH_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSIH_HAZD_CODE | PTRHAZD_CODE | PTRHAZD |
Index Name | Index Type | Column Name |
---|---|---|
PK_PERHSIH | Unique | PERHSIH_HSIN_NO |
PK_PERHSIH | Unique | PERHSIH_HAZD_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PERHSIH | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:40:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSIM_HSIN_NO |   | NUMBER(8,0) | No | * | * |
PERHSIM_PIDM |   | NUMBER(8,0) | No | * |   |
PERHSIM_HSME_CODE |   | VARCHAR2(4) | No | * | * |
PERHSIM_BEGIN_DATE |   | DATE | No | * |   |
PERHSIM_END_DATE |   | DATE | Yes |   |   |
PERHSIM_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
PERHSIM_HOURS_LOST |   | NUMBER(5,1) | Yes |   |   |
PERHSIM_HOURS_WORK_RESTRICTED |   | NUMBER(5,1) | Yes |   |   |
PERHSIM_ACTIVITY_DATE |   | DATE | No |   |   |
PERHSIM_CLASSIFICATION_TYPE |   | VARCHAR2(1) | No |   |   |
PERHSIM_INJURY_ILLNESS_TYPE |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSIM_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSIM_HSME_CODE | PTRHSME_CODE | PTRHSME |
Index Name | Index Type | Column Name |
---|---|---|
PK_PERHSIM | Unique | PERHSIM_HSIN_NO |
PK_PERHSIM | Unique | PERHSIM_PIDM |
PK_PERHSIM | Unique | PERHSIM_HSME_CODE |
PK_PERHSIM | Unique | PERHSIM_BEGIN_DATE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PERHSIM | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHSME | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:41:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSIP_HSIN_NO |   | NUMBER(8,0) | No | * | * |
PERHSIP_PIDM |   | NUMBER(8,0) | No | * |   |
PERHSIP_HSPC_CODE |   | VARCHAR2(4) | No | * | * |
PERHSIP_POSN |   | VARCHAR2(6) | Yes |   |   |
PERHSIP_SUFF |   | VARCHAR2(2) | Yes |   |   |
PERHSIP_DISA_CODE |   | VARCHAR2(6) | Yes |   | * |
PERHSIP_WORK_COMP_IND |   | VARCHAR2(1) | Yes |   |   |
PERHSIP_OSHA_IND |   | VARCHAR2(1) | Yes |   |   |
PERHSIP_LITG_CODE |   | VARCHAR2(1) | Yes |   | * |
PERHSIP_LITG_DATE |   | DATE | Yes |   |   |
PERHSIP_DEAD_IND |   | VARCHAR2(1) | Yes |   |   |
PERHSIP_COMMENT |   | LONG | Yes |   |   |
PERHSIP_ACTIVITY_DATE |   | DATE | No |   |   |
PERHSIP_OSHA_RPT_DISPLAY_TYPE |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSIP_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSIP_DISA_CODE | PTVDISA_CODE | PTVDISA |
PERHSIP_HSPC_CODE | PTVHSPC_CODE | PTVHSPC |
PERHSIP_LITG_CODE | PTVLITG_CODE | PTVLITG |
Index Name | Index Type | Column Name |
---|---|---|
PK_PERHSIP | Unique | PERHSIP_HSIN_NO |
PK_PERHSIP | Unique | PERHSIP_PIDM |
PK_PERHSIP | Unique | PERHSIP_HSPC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PERHSIP | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVDISA | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVHSPC | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVLITG | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:42:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSIT_HSIN_NO |   | NUMBER(8,0) | No | * | * |
PERHSIT_HSTC_CODE |   | VARCHAR2(6) | No | * | * |
PERHSIT_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSIT_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSIT_HSTC_CODE | PTVHSTC_CODE | PTVHSTC |
Index Name | Index Type | Column Name |
---|---|---|
PK_PERHSIT | Unique | PERHSIT_HSIN_NO |
PK_PERHSIT | Unique | PERHSIT_HSTC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PERHSIT | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVHSTC | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:45:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PERHSRA_HSIN_NO |   | NUMBER(8,0) | No |   | * |
PERHSRA_TEXT |   | VARCHAR2(50) | No |   |   |
PERHSRA_SEQ_NO |   | NUMBER(4,0) | No |   |   |
PERHSRA_RSTA_CODE |   | VARCHAR2(1) | No |   | * |
PERHSRA_RSTA_DATE |   | DATE | No |   |   |
PERHSRA_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PERHSRA_HSIN_NO | PEBHSIN_NO | PEBHSIN |
PERHSRA_RSTA_CODE | PTVRSTA_CODE | PTVRSTA |
Index Name | Index Type | Column Name |
---|---|---|
PERHSRA_KEY_INDEX |   | PERHSRA_HSIN_NO |
PERHSRA_KEY_INDEX |   | PERHSRA_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSRA_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVRSTA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:32:02:000 | 04/02/2008 13:49:05:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHAZD_CODE |   | VARCHAR2(4) | No | * |   |
PTRHAZD_DESC |   | VARCHAR2(30) | No |   |   |
PTRHAZD_CAS_NUMBER |   | NUMBER(8,0) | Yes |   |   |
PTRHAZD_MANU_CODE |   | VARCHAR2(4) | Yes |   | * |
PTRHAZD_MSDS_NUMBER |   | NUMBER(8,0) | Yes |   |   |
PTRHAZD_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHAZD_MANU_CODE | PTVMANU_CODE | PTVMANU |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTRHAZD | Unique | PTRHAZD_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PEAPNHZ | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERHSIH | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHZCM | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHZPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHZTP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTRHAZD | SQL Index | S10B80.PAYROLL | Rely On |
PTVMANU | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:35:33:000 | 04/02/2008 13:49:09:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHSIL_CODE |   | VARCHAR2(6) | No | * |   |
PTRHSIL_DESC |   | VARCHAR2(30) | No |   |   |
PTRHSIL_HSLT_CODE |   | VARCHAR2(4) | No |   | * |
PTRHSIL_ADDRESS_LINE1 |   | VARCHAR2(60) | Yes |   |   |
PTRHSIL_ADDRESS_LINE2 |   | VARCHAR2(60) | Yes |   |   |
PTRHSIL_CITY |   | VARCHAR2(50) | Yes |   |   |
PTRHSIL_STAT_CODE |   | VARCHAR2(3) | Yes |   |   |
PTRHSIL_ZIPC_CODE |   | VARCHAR2(30) | Yes |   |   |
PTRHSIL_NATN_CODE |   | VARCHAR2(5) | Yes |   | * |
PTRHSIL_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHSIL_NATN_CODE | STVNATN_CODE | STVNATN |
PTRHSIL_HSLT_CODE | PTVHSLT_CODE | PTVHSLT |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTRHSIL | Unique | PTRHSIL_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTRHSIL | SQL Index | S10B80.PAYROLL | Rely On |
PTVHSLT | SQL Table | S10B80.PAYROLL | Refer (no action) |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:38:36:000 | 04/02/2008 13:49:13:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHSME_CODE |   | VARCHAR2(4) | No | * |   |
PTRHSME_DESC |   | VARCHAR2(30) | No |   |   |
PTRHSME_HSMT_CODE |   | VARCHAR2(1) | No |   | * |
PTRHSME_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHSME_HSMT_CODE | PTVHSMT_CODE | PTVHSMT |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTRHSME | Unique | PTRHSME_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSIM | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTRHSME | SQL Index | S10B80.PAYROLL | Rely On |
PTVHSMT | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:38:43:000 | 04/02/2008 13:49:13:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHZCM_HAZD_CODE |   | VARCHAR2(4) | No |   | * |
PTRHZCM_TEXT |   | LONG | Yes |   |   |
PTRHZCM_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHZCM_HAZD_CODE | PTRHAZD_CODE | PTRHAZD |
Index Name | Index Type | Column Name |
---|---|---|
PTRHZCM_KEY_INDEX |   | PTRHZCM_HAZD_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHZCM_KEY_INDEX | SQL Index | S10B80.PAYROLL | Rely On |
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:37:53:000 | 04/02/2008 13:49:12:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHZPR_HAZD_CODE |   | VARCHAR2(4) | No | * | * |
PTRHZPR_HZSP_CODE |   | VARCHAR2(4) | No | * | * |
PTRHZPR_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHZPR_HAZD_CODE | PTRHAZD_CODE | PTRHAZD |
PTRHZPR_HZSP_CODE | PTVHZSP_CODE | PTVHZSP |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTRHZPR | Unique | PTRHZPR_HAZD_CODE |
PK_PTRHZPR | Unique | PTRHZPR_HZSP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTRHZPR | SQL Index | S10B80.PAYROLL | Rely On |
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVHZSP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:38:17:000 | 04/02/2008 13:49:12:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTRHZTP_HAZD_CODE |   | VARCHAR2(4) | No | * | * |
PTRHZTP_HZTC_CODE |   | VARCHAR2(4) | No | * | * |
PTRHZTP_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
PTRHZTP_HAZD_CODE | PTRHAZD_CODE | PTRHAZD |
PTRHZTP_HZTC_CODE | PTVHZTC_CODE | PTVHZTC |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTRHZTP | Unique | PTRHZTP_HAZD_CODE |
PK_PTRHZTP | Unique | PTRHZTP_HZTC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTRHZTP | SQL Index | S10B80.PAYROLL | Rely On |
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTVHZTC | SQL Table | S10B80.PAYROLL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:38:20:000 | 04/02/2008 13:49:13:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVDISA_CODE |   | VARCHAR2(6) | No | * |   |
PTVDISA_DESC |   | VARCHAR2(30) | No |   |   |
PTVDISA_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVDISA | Unique | PTVDISA_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSIP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVDISA | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:32:26:000 | 04/02/2008 13:49:06:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVGRPT_CODE |   | VARCHAR2(4) | No | * |   |
PTVGRPT_DESC |   | VARCHAR2(30) | No |   |   |
PTVGRPT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVGRPT | Unique | PTVGRPT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERGRPA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVGRPT | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:35:10:000 | 04/02/2008 13:49:09:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVGRSR_CODE |   | VARCHAR2(4) | No | * |   |
PTVGRSR_DESC |   | VARCHAR2(30) | No |   |   |
PTVGRSR_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVGRSR | Unique | PTVGRSR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERGRRA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVGRSR | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:35:16:000 | 04/02/2008 13:49:09:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVGRTP_CODE |   | VARCHAR2(4) | No | * |   |
PTVGRTP_DESC |   | VARCHAR2(30) | No |   |   |
PTVGRTP_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVGRTP | Unique | PTVGRTP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PEBGREV | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVGRTP | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:35:25:000 | 04/02/2008 13:49:09:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHSCR_CODE |   | VARCHAR2(4) | No | * |   |
PTVHSCR_DESC |   | VARCHAR2(30) | No |   |   |
PTVHSCR_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHSCR | Unique | PTVHSCR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSCT | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHSCR | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:39:40:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHSLT_CODE |   | VARCHAR2(4) | No | * |   |
PTVHSLT_DESC |   | VARCHAR2(30) | No |   |   |
PTVHSLT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHSLT | Unique | PTVHSLT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHSIL | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHSLT | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:01:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHSMT_CODE |   | VARCHAR2(1) | No | * |   |
PTVHSMT_DESC |   | VARCHAR2(30) | No |   |   |
PTVHSMT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHSMT | Unique | PTVHSMT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHSME | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHSMT | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:04:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHSPC_CODE |   | VARCHAR2(4) | No | * |   |
PTVHSPC_DESC |   | VARCHAR2(30) | No |   |   |
PTVHSPC_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHSPC | Unique | PTVHSPC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSIP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHSPC | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:10:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHSTC_CODE |   | VARCHAR2(6) | No | * |   |
PTVHSTC_DESC |   | VARCHAR2(30) | No |   |   |
PTVHSTC_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHSTC | Unique | PTVHSTC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSIT | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHSTC | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:14:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHZSP_CODE |   | VARCHAR2(4) | No | * |   |
PTVHZSP_DESC |   | VARCHAR2(30) | No |   |   |
PTVHZSP_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHZSP | Unique | PTVHZSP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHZPR | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHZSP | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:39:32:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVHZTC_CODE |   | VARCHAR2(4) | No | * |   |
PTVHZTC_DESC |   | VARCHAR2(30) | No |   |   |
PTVHZTC_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVHZTC | Unique | PTVHZTC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHZTP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVHZTC | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:39:39:000 | 04/02/2008 13:49:14:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVISTA_CODE |   | VARCHAR2(1) | No | * |   |
PTVISTA_DESC |   | VARCHAR2(30) | No |   |   |
PTVISTA_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVISTA | Unique | PTVISTA_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PEBGREV | SQL Table | S10B80.PAYROLL | Refer (no action) |
PEBHSIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVISTA | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:34:38:000 | 04/02/2008 13:49:08:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVLITG_CODE |   | VARCHAR2(1) | No | * |   |
PTVLITG_DESC |   | VARCHAR2(30) | No |   |   |
PTVLITG_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVLITG | Unique | PTVLITG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSIP | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVLITG | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:33:07:000 | 04/02/2008 13:49:07:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVMANU_CODE |   | VARCHAR2(4) | No | * |   |
PTVMANU_DESC |   | VARCHAR2(30) | No |   |   |
PTVMANU_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVMANU | Unique | PTVMANU_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PTRHAZD | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVMANU | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:36:02:000 | 04/02/2008 13:49:10:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
PTVRSTA_CODE |   | VARCHAR2(1) | No | * |   |
PTVRSTA_DESC |   | VARCHAR2(30) | No |   |   |
PTVRSTA_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_PTVRSTA | Unique | PTVRSTA_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PERHSRA | SQL Table | S10B80.PAYROLL | Refer (no action) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_PTVRSTA | SQL Index | S10B80.PAYROLL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:39:00:000 | 04/02/2008 13:49:13:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
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 |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVNATN_CODE |   | VARCHAR2(5) | No | * |   |
STVNATN_NATION |   | VARCHAR2(30) | No |   |   |
STVNATN_CAPITAL |   | VARCHAR2(20) | Yes |   |   |
STVNATN_AREA |   | NUMBER(22,0) | Yes |   |   |
STVNATN_POPULATION |   | NUMBER(22,0) | Yes |   |   |
STVNATN_ACTIVITY_DATE |   | DATE | No |   |   |
STVNATN_EDI_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_LMS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_POSTAL_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_TELE_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_STATSCAN_CDE |   | VARCHAR2(5) | Yes |   |   |
STVNATN_SCOD_CODE_ISO |   | VARCHAR2(3) | Yes |   |   |
STVNATN_SSA_REPORTING_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_SEVIS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVNATN | Unique | STVNATN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
STVNATN | Oracle Synonym | S10B80.FAISMGR | Rely On |
AORCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBWIDN | SQL Table | S10B80.ALUMNI | Refer (no action) |
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVCURR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVZIPC | SQL Table | S10B80.GENERAL | Refer (no action) |
GUBINST | SQL Table | S10B80.GENERAL | Refer (no action) |
GURAPAY | SQL Table | S10B80.GENERAL | Refer (no action) |
PPREXPE | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHSIL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
RJBPLBD | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPBLNDR | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLAPP | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLARF | SQL Table | S10B80.FAISMGR | Refer (no action) |
SABSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
SFRENRL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBDIPL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGAPP | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRAN | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRTC | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SMTPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SOBSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Refer (no action) |
SPRADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SPREMRG | SQL Table | S10B80.SATURN | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SRTHSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SRTINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTPCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
STVEMPL | SQL Table | S10B80.SATURN | Refer (no action) |
AF_VENDOR_VOLUME | SQL View | S10B80.BANINST1 | Use (select) |
APVADRS | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
POVDATA | SQL View | S10B80.BANINST1 | Use (select) |
PPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVADDR | SQL View | S10B80.BANINST1 | Use (select) |
RPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVFDRS | SQL View | S10B80.BANINST1 | Use (select) |
SAVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SGVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDF | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDI | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
SRVADRS | SQL View | S10B80.BANINST1 | Use (select) |
STVNATV | SQL View | S10B80.BANINST1 | Use (select) |
F_COMMON_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
ADDRESS_REC_TYPE | Oracle Package Type | S10B80.BANINST1.ICSPKCOM | Rely On |
NATN_CUR | Oracle Package Cursor | S10B80.BANINST1.BWSKALOG | Use (select) |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOADR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKJPST | Rely On |
GETSTVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWAKALOG | Use (select)Rely On |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select)Rely On |
STVNATN_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKRQST | Use (select) |
P_GENOPTIONSNATN | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_LOOKUPSBGICODE | Oracle Package Procedure | S10B80.BANINST1.BWSKWPRO | Use (select) |
CUR_OF_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
CUR_PR_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
GV_NATION_CODE1 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE2 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE3 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE4 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATN_DESC | Oracle Package Variable | S10B80.BANINST1.BWSKRQST | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOEMR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKALOG | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOPRF | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.STKNATN | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKLIST | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.GOKLIBS | Use (select)Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Use (select)Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CC_PAYMENT_STATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_COLLECT_CREDIT_CARD_INFO | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CREDIT_CARD_PAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWLKOSAD | Rely On |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_DISPSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISPSTATUSSARADAP | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISP_CONFIRM | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_DIPLOMA_ADDR | Oracle Package Procedure | S10B80.BANINST1.BWSKGRAD | Use (select) |
P_DISP_STATUS_OF_ORDER | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Use (select) |
P_GET_SOBSBGI_INFO | Oracle Package Procedure | S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP | Use (select) |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Use (select) |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Rely On |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Use (select) |
P_LOOKUP_SBGI_CODE | Oracle Package Procedure | S10B80.BANINST1.BWSKALOG | Use (select) |
P_MAKE_A_DONATION | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_PROCADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOGAD | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Use (select) |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Rely On |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Use (select) |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VALADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_VALIDATION_DISPLAY | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_VIEWDCSR | Oracle Package Procedure | S10B80.BANINST1.BWFKVDCR | Rely On |
P_VIEWINV | Oracle Package Procedure | S10B80.BANINST1.BWFKVINV | Rely On |
P_VIEWPUR | Oracle Package Procedure | S10B80.BANINST1.BWFKVPUR | Rely On |
P_VIEWREQ | Oracle Package Procedure | S10B80.BANINST1.BWFKVREQ | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EXPERIENCE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DRIVER_LICENSE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BIO | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_CERTIFICATION | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EFDTEST | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_ENTITY_ADDRESS | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_TB_MISC_HEADER | Use (Insert) |
F_CALC_NATION | Oracle Package Function | S10B80.BANINST1.ICSPKCOM | Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_DOMESTIC_ADDR | Oracle Package Function | S10B80.BANINST1.SHKPXML | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Use (select) |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Use (select) |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Rely On |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Use (select) |
F_OPEN_STVNATN_RC | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
F_SORXREF_CHK | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
F_SORXREF_VAL | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
STVNATN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVNATN | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 10:35:08:000 | 04/02/2008 21:17:58:000 |
Objects list |
---|
schema-view : S10B80.BANINST1.PEVJOB1
schema-view : S10B80.BANINST1.PEVEPRO scope-procedure : S10B80.BANINST1.NOKMISC.P_NEXT_APPROVER |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and NBRBJOB | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | NBRBJOB |
Objects list |
---|
schema-view : S10B80.BANINST1.PAVAPPL
schema-view : S10B80.BANINST1.PEVPRF1 schema-view : S10B80.BANINST1.PEVVER2 schema-view : S10B80.BANINST1.PHVTIME schema-view : S10B80.BANINST1.PEVEMPL schema-function : S10B80.BANINST1.F_ORDER_BY_LAST scope-cursor : S10B80.BANINST1.PP_W2_2006.EMPL_C scope-cursor : S10B80.BANINST1.PP_W2_2007.EMPL_C scope-procedure : S10B80.BANINST1.PP_W2.P_CREATE_W2 scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_EMPLOYEE_ID scope-function : S10B80.BANINST1.BWPKEBST.F_GETPIDMFROMID |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and PEBEMPL | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | PEBEMPL |
Objects list |
---|
schema-view : S10B80.BANINST1.PEVPRF1
schema-view : S10B80.BANINST1.PHVTIME schema-view : S10B80.BANINST1.PEVRTWK scope-cursor : S10B80.BANINST1.PEKTEEX.JOBS_CURSOR |
Link Type | Link | Project |
---|---|---|
Join | Link Between NBRBJOB and PEBEMPL | POSNCTL |
Link type | Between | And |
---|---|---|
Join | NBRBJOB | PEBEMPL |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between NBRBJOB and NBBPOSN (FK1_NBRBJOB_INV_NBBPOSN_KEY) | POSNCTL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
NBRBJOB | NBRBJOB_POSN | NBBPOSN_POSN | NBBPOSN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEAPNHZ and NBBPOSN (FK1_PEAPNHZ_INV_NBBPOSN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEAPNHZ | PEAPNHZ_POSN | NBBPOSN_POSN | NBBPOSN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEAPNHZ and PTRHAZD (FK1_PEAPNHZ_INV_PTRHAZD_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEAPNHZ | PEAPNHZ_HAZD_CODE | PTRHAZD_CODE | PTRHAZD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSRA and PEBHSIN (FK1_PERHSRA_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSRA | PERHSRA_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEBHSIN and PTVISTA (FK1_PEBHSIN_INV_PTVISTA_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEBHSIN | PEBHSIN_ISTA_CODE | PTVISTA_CODE | PTVISTA | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHAZD and PTVMANU (FK1_PTRHAZD_INV_PTVMANU_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHAZD | PTRHAZD_MANU_CODE | PTVMANU_CODE | PTVMANU | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRPA and NBRBJOB (FK1_PERGRPA_INV_NBRBJOB_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRPA | PERGRPA_PIDM | NBRBJOB_PIDM | NBRBJOB | (0,1)-(0,n) |
PERGRPA | PERGRPA_POSN | NBRBJOB_POSN | NBRBJOB | (0,1)-(0,n) |
PERGRPA | PERGRPA_SUFF | NBRBJOB_SUFF | NBRBJOB | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRPA and PTVGRPT (FK1_PERGRPA_INV_PTVGRPT_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRPA | PERGRPA_GRPT_CODE | PTVGRPT_CODE | PTVGRPT | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRRA and PTVGRSR (FK1_PERGRRA_INV_PTVGRSR_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRRA | PERGRRA_GRSR_CODE | PTVGRSR_CODE | PTVGRSR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRPA and PEBEMPL (FK1_PERGRPA_INV_PEBEMPL_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRPA | PERGRPA_PIDM | PEBEMPL_PIDM | PEBEMPL | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHZCM and PTRHAZD (FK1_PTRHZCM_INV_PTRHAZD_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHZCM | PTRHZCM_HAZD_CODE | PTRHAZD_CODE | PTRHAZD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHZPR and PTRHAZD (FK1_PTRHZPR_INV_PTRHAZD_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHZPR | PTRHZPR_HAZD_CODE | PTRHAZD_CODE | PTRHAZD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHZTP and PTRHAZD (FK1_PTRHZTP_INV_PTRHAZD_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHZTP | PTRHZTP_HAZD_CODE | PTRHAZD_CODE | PTRHAZD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEBHSIN and PTRHSIL (FK1_PEBHSIN_INV_PTRHSIL_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEBHSIN | PEBHSIN_HSIL_CODE | PTRHSIL_CODE | PTRHSIL | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHSIL and STVNATN (FK1_PTRHSIL_INV_STVNATN_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHSIL | PTRHSIL_NATN_CODE | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSRA and PTVRSTA (FK1_PERHSRA_INV_PTVRSTA_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSRA | PERHSRA_RSTA_CODE | PTVRSTA_CODE | PTVRSTA | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHZPR and PTVHZSP (FK1_PTRHZPR_INV_PTVHZSP_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHZPR | PTRHZPR_HZSP_CODE | PTVHZSP_CODE | PTVHZSP | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHZTP and PTVHZTC (FK1_PTRHZTP_INV_PTVHZTC_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHZTP | PTRHZTP_HZTC_CODE | PTVHZTC_CODE | PTVHZTC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRPA and PEBGREV (FK1_PERGRPA_INV_PEBGREV_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRPA | PERGRPA_GREV_NO | PEBGREV_NO | PEBGREV | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERGRRA and PEBGREV (FK1_PERGRRA_INV_PEBGREV_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERGRRA | PERGRRA_GREV_NO | PEBGREV_NO | PEBGREV | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEBGREV and PTVGRTP (FK1_PEBGREV_INV_PTVGRTP_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEBGREV | PEBGREV_GRTP_CODE | PTVGRTP_CODE | PTVGRTP | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PEBGREV and PTVISTA (FK1_PEBGREV_INV_PTVISTA_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PEBGREV | PEBGREV_ISTA_CODE | PTVISTA_CODE | PTVISTA | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHSIL and PTVHSLT (FK1_PTRHSIL_INV_PTVHSLT_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHSIL | PTRHSIL_HSLT_CODE | PTVHSLT_CODE | PTVHSLT | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PTRHSME and PTVHSMT (FK1_PTRHSME_INV_PTVHSMT_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PTRHSME | PTRHSME_HSMT_CODE | PTVHSMT_CODE | PTVHSMT | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSCT and PEBHSIN (FK1_PERHSCT_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSCT | PERHSCT_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSCT and PTVHSCR (FK1_PERHSCT_INV_PTVHSCR_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSCT | PERHSCT_HSCR_CODE | PTVHSCR_CODE | PTVHSCR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIH and PEBHSIN (FK1_PERHSIH_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIH | PERHSIH_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIH and PTRHAZD (FK1_PERHSIH_INV_PTRHAZD_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIH | PERHSIH_HAZD_CODE | PTRHAZD_CODE | PTRHAZD | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIM and PEBHSIN (FK1_PERHSIM_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIM | PERHSIM_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIM and PTRHSME (FK1_PERHSIM_INV_PTRHSME_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIM | PERHSIM_HSME_CODE | PTRHSME_CODE | PTRHSME | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIP and PEBHSIN (FK1_PERHSIP_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIP | PERHSIP_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIP and PTVDISA (FK1_PERHSIP_INV_PTVDISA_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIP | PERHSIP_DISA_CODE | PTVDISA_CODE | PTVDISA | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIP and PTVHSPC (FK1_PERHSIP_INV_PTVHSPC_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIP | PERHSIP_HSPC_CODE | PTVHSPC_CODE | PTVHSPC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIP and PTVLITG (FK1_PERHSIP_INV_PTVLITG_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIP | PERHSIP_LITG_CODE | PTVLITG_CODE | PTVLITG | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIT and PEBHSIN (FK1_PERHSIT_INV_PEBHSIN_KEY) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIT | PERHSIT_HSIN_NO | PEBHSIN_NO | PEBHSIN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between PERHSIT and PTVHSTC (FK1_PERHSIT_INV_PTVHSTC_CODE) | PAYROLL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
PERHSIT | PERHSIT_HSTC_CODE | PTVHSTC_CODE | PTVHSTC | (1,1)-(0,n) |