GP_NRP_PYGDL_VW

(SQL View)
 Index Back

Pay Group Definition - View

Pay Group Definition EFFDT level - Packaging View

SELECT GP_PAYGROUP ,EFFDT ,EFF_STATUS ,ELIG_GRP ,SCHEDULE_ID ,ALT_WRK_SCHED_ID ,HOLIDAY_SCHEDULE ,CUR_RT_TYPE ,ASOF_DT_EXCHNG_RT ,PIN_PRO_NUM + 50000000 ,FREQ_ID_MONTHLY ,FREQ_ID_DAILY ,RND_OPTN_BASE_PG ,RND_OPTN_RATE_PG ,RND_OPTN_UNIT_PG ,RND_OPTN_PCT_PG ,RND_OPTN_RSLV_PG ,PIN_RND_BASE_NUM + 50000000 ,PIN_RND_RATE_NUM + 50000000 ,PIN_RND_UNIT_NUM + 50000000 ,PIN_RND_PCT_NUM + 50000000 ,PIN_RND_RSLV_NUM + 50000000 ,PRORATION_OPTN_PG ,SCHEDULE_GRP ,SETID ,ROTATION_ID ,ALT_SCHEDULE_GRP ,SETID_SCHED ,ROTATION_ID_ALT FROM PS_GP_PYGRP_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

2 EFFDT Date(10) DATE NOT NULL Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group

Prompt Table: GP_ELIG_GRP

5 SCHEDULE_ID Character(16) VARCHAR2(16) NOT NULL The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).

Prompt Table: SCH_DEFN_TBL

6 ALT_WRK_SCHED_ID Character(16) VARCHAR2(16) NOT NULL TR Alternate Schedule ID

Prompt Table: SCH_DEFN_TBL

7 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

Prompt Table: HOLIDAY_TBL

8 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: CUR_RT_TYPE_TBL

9 ASOF_DT_EXCHNG_RT Character(1) VARCHAR2(1) NOT NULL As of Date for Exchange Rate
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date

Default Value: E

10 PIN_PRO_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_PO0_VW

11 FREQ_ID_MONTHLY Character(5) VARCHAR2(5) NOT NULL Monthly Frequency

Default Value: M

Prompt Table: FREQUENCY_TBL

12 FREQ_ID_DAILY Character(5) VARCHAR2(5) NOT NULL Daily Frequency

Default Value: D

Prompt Table: FREQUENCY_TBL

13 RND_OPTN_BASE_PG Character(2) VARCHAR2(2) NOT NULL rounding option base
NR=No Rounding
SP=Use Specified Rounding

Default Value: NR

14 RND_OPTN_RATE_PG Character(2) VARCHAR2(2) NOT NULL rounding option rate
NR=No Rounding
SP=Use Specified Rounding

Default Value: NR

15 RND_OPTN_UNIT_PG Character(2) VARCHAR2(2) NOT NULL rounding option unit
NR=No Rounding
SP=Use Specified Rounding

Default Value: NR

16 RND_OPTN_PCT_PG Character(2) VARCHAR2(2) NOT NULL rounding option percent
NR=No Rounding
SP=Use Specified Rounding

Default Value: NR

17 RND_OPTN_RSLV_PG Character(2) VARCHAR2(2) NOT NULL rounding option resolved
NR=No Rounding
SP=Use Specified Rounding

Default Value: NR

18 PIN_RND_BASE_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

19 PIN_RND_RATE_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

20 PIN_RND_UNIT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

21 PIN_RND_PCT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

22 PIN_RND_RSLV_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

23 PRORATION_OPTN_PG Character(2) VARCHAR2(2) NOT NULL Proration Option
NP=No Proration
SP=Use Specific Proration

Default Value: NP

24 SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Scheduling Organizational Group Code
25 SETID Character(5) VARCHAR2(5) NOT NULL SetID
26 ROTATION_ID Character(10) VARCHAR2(10) NOT NULL Rotation ID
27 ALT_SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Alternate Schedule Group code
28 SETID_SCHED Character(5) VARCHAR2(5) NOT NULL SetID for Schedule ID
29 ROTATION_ID_ALT Character(10) VARCHAR2(10) NOT NULL Rotation ID of relating to the Alternate Schedule