UPG_PRWKEXP_TAO(SQL Table) |
Index Back |
|---|---|
Temp table for Upgrade. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 3 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | EMPLOYER | Character(30) | VARCHAR2(30) NOT NULL | Employer |
| 5 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 8 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 9 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 10 | END_DT | Date(10) | DATE | end date |
| 11 | ENDING_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Ending Job Title |
| 12 | ENDING_RATE | Number(19,3) | DECIMAL(18,3) NOT NULL | Ending Pay Rate |
| 13 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 15 | US_SOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Standard Occupational Classif |
| 16 | CAN_NOC_CD | Character(10) | VARCHAR2(10) NOT NULL | National Occupational Classif |
| 17 | REL_WRK_EXPER | Character(1) | VARCHAR2(1) NOT NULL |
Relevant Work Experience
Y/N Table Edit |
| 18 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: %SAL_GRD_PRMPT1 |
| 19 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 20 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 21 | GVT_PAY_PLAN | Character(2) | VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table: GVT_PAY_PLAN |
| 22 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL |
Occupational Series
Prompt Table: GVT_OCCUPATION |
| 23 | GVT_TYPE_OF_APPT | Character(2) | VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm) 15=Career-Conditional (Comp Perm) 20=Nonpermanent (Comp NonPerm) 30=Schedule A (Except Svc Perm) 32=Schedule B (Except Svc Perm) 34=Schedule C (Except Svc Perm) 36=Executive (Except Svc Perm) 38=Other (Except Svc Perm) 40=Schedule A (Except NonPerm) 42=Schedule B (Except NonPerm) 44=Schedule C (Except NonPerm) 46=Executive (Except NonPerm) 48=Other (Except NonPerm) 50=Career (Senior Exec Perm) 55=Noncareer (Senior Exec Perm) 60=Limited Term (Senior Exec NPrm 65=Limited Emergency (SES NPerm) |
| 24 | GVT_HOURS_PER_WEEK | Number(4,1) | DECIMAL(3,1) NOT NULL | Hours Per Week |
| 25 | GVT_POSN_OCCUPIED | Character(1) | VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive 2=Excepted 3=SES General 4=SES Career Reserved |
| 26 | GVT_TENURE | Character(1) | VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None 1=Permanent 2=Conditional 3=Indefinite |
| 27 | GVT_TYPE_OF_EXP | Character(1) | VARCHAR2(1) NOT NULL |
Experience Type
F=Federal Civilian Sector O=Other P=Private Sector |
| 28 | DESCRLONG | Long Character | CLOB | Long Description |