HRS_CR_JOB_AET

(SQL Table)
 Index Back

Create Job from Position

Create Job Opening from Position App Engine state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
4 BUDGETED_POSN Character(1) VARCHAR2(1) NOT NULL Budgeted Position

Y/N Table Edit

Default Value: Y

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
7 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
8 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
9 CONFIDENTIAL_POSN Character(1) VARCHAR2(1) NOT NULL Confidential Position
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
16 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
17 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

18 ERP_TMPL Character(12) VARCHAR2(12) NOT NULL ERP Template
19 FED Character(1) VARCHAR2(1) NOT NULL Federal Functionality
20 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
21 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1

Default Value: T

22 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status field
A=Administrative
C=Computer Employee
E=Executive
H=Highly Compensated Employees
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
V=Nonexempt Alt Overtime
X=No FLSA Required
23 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
24 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
25 HRS_ALLOW_DUP Character(1) VARCHAR2(1) NOT NULL Alow Duplicates
26 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
27 GVT_POSN_SENS_CD Character(1) VARCHAR2(1) NOT NULL Sensitivity Code
1=Non Sensitive
2=Non-Critical, Sensitive
3=Critical Sensitive
4=Special Sensitive
28 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
29 HRS_JOBPROFILE_SRC Character(1) VARCHAR2(1) NOT NULL Determines if the job profile is used and where the it comes from
C=Job Code
F=Job Family
N=Not Used
P=Position
S=Salary Grade
30 HRS_JO_SCR_SUMM_ID Number(15,0) DECIMAL(15) NOT NULL JO Screening Summary ID
31 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID
32 HRS_REQ_DFLT_TMPL Number(15,0) DECIMAL(15) NOT NULL Default job opening requisition template
33 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
34 HRS_REQ_APRV Character(1) VARCHAR2(1) NOT NULL Job Opening: Requisitions Approval Flag
35 HRS_SCR_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Screening template ID
36 HRS_SCREENING_ID Number(15,0) DECIMAL(15) NOT NULL Screening ID
37 HRS_STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Applicant Status
38 HRS_TMPL_SEGMENT Character(2) VARCHAR2(2) NOT NULL Segmenting type for recruiting template
10=Business Unit
20=Company
30=Department
40=Job Profile
50=Job Family
60=Job Code
70=Salary Grade
39 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
40 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
41 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
42 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
43 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
44 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count
45 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID
46 OPENINGS_CNT Number(3,0) SMALLINT NOT NULL Tracks number of openings
47 OPENINGS_TARGET Number(3,0) SMALLINT NOT NULL Tracks number of target openings
48 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
49 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
50 POSITION_MGMT Character(1) VARCHAR2(1) NOT NULL Position Management Option
F=Full Position Management
N=No Position Management
P=Partial Position Management
51 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen
52 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
53 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
54 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
55 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
56 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating
57 SETID Character(5) VARCHAR2(5) NOT NULL SetID
58 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
59 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
60 STATUS_DT Date(10) DATE Status Date
61 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
62 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

Prompt Table: STDHRS_FREQ_VW

63 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
64 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents
65 GRADE_FROM Character(3) VARCHAR2(3) NOT NULL From Grade
66 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade
67 STEP_FROM Number(2,0) SMALLINT NOT NULL Step
68 STEP_TO Number(2,0) SMALLINT NOT NULL Step
69 DESCRLONG Long Character CLOB Long Description