SPB_PRV_ELG_HIS

(SQL Table)
Index Back

Provider Eligibility History

Service Provider Eligibility History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: Y

2 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
6 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
7 COMMENTS Long Character CLOB Comment