PAYGROUP_VW

(SQL View)
Index Back

Paygroups View


SELECT COMPANY ,PAYGROUP ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,PAY_FREQUENCY FROM PS_PAYGROUP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: OPR_DEF_TBL_HR.COMPANY

Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
7 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly

Prompt Table: STD_FREQ_TBL_VW