|
|
|
|||
|
|
|
Object Report on Table(s) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Database:FACDB |
|
|
Date:May 17, 2005 12:46:26 PM |
|
|
|
Table Of Contents
|
|
|
|
|
|
FACULTY.FIS_APPT
Triggers – none
General
|
Name: |
FIS_APPT |
|
Schema: |
FACULTY |
|
Tablespace: |
FACDATA1 |
|
Organized Using Index (IOT) |
No |
|
Object Table |
No |
Columns
|
Name |
Datatype |
Size
|
Nulls? |
Data
Element Description |
User Update; Process |
Source Desc
|
|
EMPLID |
VARCHAR2 |
11 |
No |
PeopleSoft Employee Id |
System; Daily Update WORK_PSJOB.EMPLID |
PS_PERSONAL_DATA.EMPLID |
|
POSITION_NUMBER |
VARCHAR2 |
8 |
No |
PeopleSoft Position Number |
WORK_PSJOB.POSITION_NUMBER |
PS_JOB.POSITION_NBR |
|
APPT_JOBCLASS |
VARCHAR2 |
6 |
No |
PeopleSoft Jobclass code |
WORK_PSJOB.JOBCODE |
PS_JOB.JOBCODE |
|
APPT_JOBCLASS_DESC |
VARCHAR2 |
50 |
Yes |
PeopleSoft Jobclass description |
WORK_PSJOB.JOBCODE_DESC |
PS_JOBCODE_TBL.DESCR |
|
RESP_DEPT_ID |
VARCHAR2 |
10 |
No |
PeopleSoft department code |
WORK_PSJOB.DEPT_ID |
PS_JOB.DEPTID |
|
DEPT_DESC |
VARCHAR2 |
30 |
Yes |
PeopleSoft department description |
WORK_PSJOB.DEPT_DESC |
PS_DEPT_TBL.DESCR |
|
EMPL_REC |
NUMBER |
0 |
No |
PeopleSoft Employee Record |
WORK_PSJOB.EMPL_RCD |
PS_JOB.EMPL_RCD |
|
EFFECTIVE_DATE |
DATE |
7 |
Yes |
PeopleSoft Effective Date |
WORK_PSJOB.EFFDT |
PS_JOB.EFFDT |
|
APPT_STATUS |
CHAR |
1 |
Yes |
PeopleSoft Empl_Status |
WORK_PSJOB.EMPL_STATUS |
PS_JOB.EMPL_STATUS |
|
APPT_STATUS_DATE |
DATE |
7 |
Yes |
PeopleSoft Action Date |
WORK_PSJOB.ACTION_DT |
PS_JOB.ACTION_DT |
|
OFFICER_YESNO |
CHAR |
1 |
Yes |
PeopleSoft Officer Yes or No |
WORK_PSJOB.OFFICER_CD |
PS_JOB.OFFICER_CD |
|
TEMPORARY_YESNO |
CHAR |
1 |
Yes |
PeopleSoft Temporary Yes No |
WORK_PSJOB.REG_TEMP |
PS_JOB.REG_TEMP |
|
FTE_AMT |
NUMBER |
5,2 |
Yes |
PeopleSoft FTE Amount |
WORK_PSJOB.FTE |
PS_JOB.FTE |
|
FULL_TIME_PCT |
NUMBER |
7,2 |
Yes |
PeopleSoft Full time Percent |
WORK_PSJOB.PERCENT_OF_TIME_CU |
PS_JOB.PERCENT_OF_TME_CU |
|
APPT_SALARY |
NUMBER |
18,6 |
Yes |
PeopleSoft Comp Rate |
WORK_PSJOB.COMPRATE |
PS_JOB.COMPRATE |
|
APPT_SALARY_PERIOD |
VARCHAR2 |
5 |
Yes |
PeopleSoft Comp Rate Frequency |
WORK_PSJOB.COMP_FREQUENCY |
PS_JOB.COMP_FREQUENCY |
|
APPT_ANNUAL_RATE |
NUMBER |
15,3 |
Yes |
PeopleSoft Annual Rate |
WORK_PSJOB.ANNUAL_RT |
PS_JOB.ANNUAL_RT |
|
APPT_END_DATE |
DATE |
7 |
Yes |
PeopleSoft Appoint End Date |
WORK_PSJOB.APPOINT_END_DT |
PS_EMPLOYMENT.APPOINT_END_DT |
|
UPDATE_DATE |
DATE |
7 |
Yes |
Date of Update |
SYSDATE |
System Date |
Constraints
|
Name |
Type |
Disable? |
Referenced Schema |
Referenced Table |
Cascade On Delete |
Check Condition |
Deferrable? |
No Validate? |
Initially Deferred? |
RELY (Do Not Enforce)? |
Storage
Extents
|
Initial Size: |
64 K Bytes |
|
Next Size: |
128 K Bytes |
|
Increase Size by: |
0 |
|
Minimum Number: |
1 |
|
Maximum Number: |
4096 |
Space Usage
|
% Free: |
10 |
|
% Used: |
40 |
Number of Transactions
|
Initial: |
1 |
|
Maximum: |
255 |
Free Lists
|
Free Lists: |
1 |
|
Groups: |
1 |
Buffer Pool
|
Buffer Pool |
DEFAULT |
Options
Parallel
|
Parallel |
No |
|
Logging |
Yes |
|
Cache |
No |
|
Monitoring |
No |
Object Definition
CREATE TABLE
"FACULTY"."FIS_APPT"("EMPLID" VARCHAR2(11),
"POSITION_NUMBER" VARCHAR2(8), "APPT_JOBCLASS" VARCHAR2(6),
"APPT_JOBCLASS_DESC" VARCHAR2(50), "RESP_DEPT_ID"
VARCHAR2(10),
"DEPT_DESC" VARCHAR2(30), "EMPL_REC" NUMBER,
"EFFECTIVE_DATE"
DATE, "APPT_STATUS" CHAR(1), "APPT_STATUS_DATE" DATE,
"OFFICER_YESNO" CHAR(1), "TEMPORARY_YESNO" CHAR(1),
"FTE_AMT"
NUMBER(5, 2), "FULL_TIME_PCT" NUMBER(7, 2), "APPT_SALARY"
NUMBER(
18, 6), "APPT_SALARY_PERIOD" VARCHAR2(5),
"APPT_ANNUAL_RATE"
NUMBER(15, 3), "APPT_END_DATE" DATE, "UPDATE_DATE" DATE)
TABLESPACE "FACDATA1" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
255
STORAGE ( INITIAL 64K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
