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 ,GP_PAYEE_SELECT_ID ,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 GP_PAYEE_SELECT_ID Character(12) VARCHAR2(12) NOT NULL Payee selection ID
5 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group

Prompt Table: GP_ELIG_GRP

6 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

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

Prompt Table: SCH_DEFN_TBL

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

Prompt Table: HOLIDAY_TBL

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

Prompt Table: CUR_RT_TYPE_TBL

10 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

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

Prompt Table: GP_PIN_PO0_VW

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

Default Value: M

Prompt Table: FREQUENCY_TBL

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

Default Value: D

Prompt Table: FREQUENCY_TBL

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

Default Value: NR

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

Default Value: NR

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

Default Value: NR

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

Default Value: NR

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

Default Value: NR

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

Prompt Table: GP_PIN_RR0_VW

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

Prompt Table: GP_PIN_RR0_VW

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

Prompt Table: GP_PIN_RR0_VW

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

Prompt Table: GP_PIN_RR0_VW

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

Prompt Table: GP_PIN_RR0_VW

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

Default Value: NP

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