SAE_GRP_POPBIND

(SQL View)
Index Back

SAIP Group Pop Select Bind Rec

SAIP Group Population Selection Bind Record

SELECT EMPLID ,' ' ,' ' FROM PS_HCR_PERSON_I

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SAE_MEMBER_ROLE Character(30) VARCHAR2(30) NOT NULL SAIP Member Role
3 SAE_GRP_MEM_STATUS Character(1) VARCHAR2(1) NOT NULL Group Member Status
A=Active
I=Inactive