HR_MSSCT_POS_VW

(SQL View)
 Index Back

GSS Position Data View

View of the GSS Position Clone data

SELECT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , A.POSITION_NBR , A.NEW_POS_NBR , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.ACTION_REASON , A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE , A.POSN_STATUS , A.STATUS_DT , A.MAX_HEAD_COUNT , A.UPDATE_INCUMBENTS , A.REPORTS_TO , A.LOCATION , A.COMPANY , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.UNION_CD , A.SHIFT , A.REG_TEMP , A.FULL_PART_TIME , A.MON_HRS , A.TUES_HRS , A.WED_HRS , A.THURS_HRS , A.FRI_HRS , A.SAT_HRS , A.SUN_HRS , A.REG_REGION , A.SAL_ADMIN_PLAN , A.GRADE , A.STEP , A.SUPV_LVL_ID , B.ORIGINATORID , B.HR_MSS_CT_NAME , A.DESCRLONG , A.POSITION_POOL_ID , A.ENCUMBER_INDC , A.ENCUMB_SAL_OPTN , A.ENCUMB_SAL_AMT , A.CLASS_INDC , A.FTE , A.ADDS_TO_FTE_ACTUAL , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM %Table(HR_MSS_CT_POSN) A , %Table(HR_MSS_CT_DAT) B WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND A.ACTION_DT_SS=B.ACTION_DT_SS AND A.EFFSEQ=B.EFFSEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ACTION_DT_SS Date(10) DATE NOT NULL Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Default Value: 00000000

6 NEW_POS_NBR Character(8) VARCHAR2(8) NOT NULL New Position

Default Value: 00000000

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
10 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

Prompt Table: BUSUNIT_HR_VW

12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

13 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: HR_GSS_JOBCD_VW

14 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen

Default Value: A

15 STATUS_DT Date(10) DATE Status Date
16 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

Default Value: 1

17 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents

Y/N Table Edit

Default Value: Y

18 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

Prompt Table: POSITION_DATA

19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: DEPT_TBL.COMPANY

Prompt Table: COMPANY_TBL

21 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
22 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

Prompt Table: STDHRS_FREQ_VW

23 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

Prompt Table: UNION_TBL

24 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating

Default Value: N

25 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

Default Value: JOBCODE_TBL.REG_TEMP

26 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

Default Value: F

27 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
28 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
29 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
30 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
31 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
32 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
33 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday
34 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Default Value: OPR_DEF_TBL_HR.REG_REGION

Prompt Table: REG_STANDARD_VW

35 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

Prompt Table: SAL_PLAN_TBL

36 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: SAL_GRADE_TBL

37 STEP Number(2,0) SMALLINT NOT NULL Step

Prompt Table: SAL_STEP_VW

38 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

Prompt Table: SUPVSR_LVL_TBL

39 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
40 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name
41 DESCRLONG Long Character CLOB Long Description
42 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

Prompt Table: POOL_TBL

43 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Pre-Encumbrance Indicator
I=Encumber Immediately
N=No Encumbrance
R=Encumber on Requisition

Default Value: I

44 ENCUMB_SAL_OPTN Character(3) VARCHAR2(3) NOT NULL Encumber Salary Option
COM=Sum of Default Components
MAX=Salary Grade Maximum
MID=Salary Grade Midpoint
MIN=Salary Grade Minimum
STP=Salary Step
USR=User Specified Amount

Default Value: STP

45 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
46 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified Indicator
B=All
C=Classified
T=Temporary
U=Unclassified

Default Value: C

47 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
48 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

Y/N Table Edit

Default Value: N

49 DESCR_HCM1 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
50 DESCR_HCM2 Character(30) VARCHAR2(30) NOT NULL This field is used display description
51 DESCR_HCM3 Character(30) VARCHAR2(30) NOT NULL This field is used display description
52 DESCR_HCM4 Character(30) VARCHAR2(30) NOT NULL This field is used display description
53 DESCR_HCM5 Character(30) VARCHAR2(30) NOT NULL This field is used display description
54 DESCR_HCM6 Character(30) VARCHAR2(30) NOT NULL This field is used display description
55 DESCR_HCM7 Character(30) VARCHAR2(30) NOT NULL This field is used display description
56 DESCR_HCM8 Character(30) VARCHAR2(30) NOT NULL This field is used display description
57 DESCR_HCM1A Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
58 DESCR_HCM2A Character(30) VARCHAR2(30) NOT NULL This field is used display description
59 DESCR_HCM3A Character(30) VARCHAR2(30) NOT NULL This field is used display description
60 DESCR_HCM4A Character(30) VARCHAR2(30) NOT NULL This field is used display description
61 DESCR_HCM5A Character(30) VARCHAR2(30) NOT NULL This field is used display description
62 DESCR_HCM6A Character(30) VARCHAR2(30) NOT NULL This field is used display description
63 DESCR_HCM7A Character(30) VARCHAR2(30) NOT NULL This field is used display description
64 DESCR_HCM8A Character(30) VARCHAR2(30) NOT NULL This field is used display description
65 COMMENTS Long Character CLOB Comment