GPAU_PYENT1_DT

(SQL Table)
Index Back

Pay Entity by Country

Used for prompting on Pay Entity where country is present and available for filtering down to PEs associated with that country

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

Default Value: AUS

Prompt Table: COUNTRY_TBL

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
3 EFFDT Date(10) DATE Effective Date

Default Value: %date