[Home] [Help]
[Dependency Information]
| Object Name: | PJI_REP_RA5 |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| PERSON_NAME | VARCHAR2 | (240) | |
| PERSON_ID | NUMBER |
|
|
| JOB_LEVEL | VARCHAR2 | (20) | |
| CAPACITY | NUMBER |
|
|
| CAPACITY_A | NUMBER |
|
|
| CONFIRMED | NUMBER |
|
|
| PROVISIONAL | NUMBER |
|
|
| UNASSIGNED | NUMBER |
|
|
| AVAILABLE | NUMBER |
|
|
| AVAILABLE_HOURS | NUMBER |
|
|
| AVAILABLE_DAYS | NUMBER |
|
|
| TOT_WTD_A | NUMBER |
|
|
| CONF_WTD_S | NUMBER |
|
|
| REDUCE_CAP_A | NUMBER |
|
|
| REDUCE_CAP_S | NUMBER |
|
|
| AVAILABLE_SINCE | VARCHAR2 | (60) | |
| CURR_LAST_PROJ | VARCHAR2 | (240) | |
| NEXT_PROJ | VARCHAR2 | (240) | |
| NEXT_ASGMT_DATE | VARCHAR2 | (60) | |
| ACT_UTIL_PER | NUMBER |
|
|
| SCH_UTIL_PER | NUMBER |
|
SYS
STANDARD
- show dependent code
APPS
PJI_PMV_AVL
- show dependent code
PJI_REP_RA5_TBL
|
|
|
|