GP_NRP_PYES1_VW

(SQL View)
Index Back

Payee Section 1 - View

This record is a child to Payee Section, setting an Effective Date with each Payee Pin Number - Packaging View

SELECT EMPLID , EMPL_RCD , PIN_NUM + 50000000 , EFFDT , EFF_STATUS FROM PS_GP_PYE_SECTION1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Default Value: A