HR_MSS_CT_POSN(SQL Table) |
Index Back |
---|---|
GSS Position DataRecord stores the position data information used by Guided Self Service position clone transaction. This record has a 1 to 1 relationship with HR_MSS_CT_DAT |
# | 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
Default Value: NEW 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 | DESCRLONG | Long Character | CLOB | Long Description |
40 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL |
Position Pool ID
Prompt Table: POOL_TBL |
41 | ENCUMBER_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Indicator
I=Encumber Immediately N=No Encumbrance R=Encumber on Requisition Default Value: I |
42 | 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 |
43 | ENCUMB_SAL_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Encumber Salary Amount |
44 | CLASS_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Classified/Unclassified Ind
B=All C=Classified T=Temporary U=Unclassified Default Value: C |
45 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
46 | ADDS_TO_FTE_ACTUAL | Character(1) | VARCHAR2(1) NOT NULL |
Adds to FTE Actual Count
Y/N Table Edit Default Value: N |