HRS_APP_LOGIN

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 HRS_OPRNAME Character(70) VARCHAR2(70) NOT NULL User Name

3 HRS_OPRPSWD Character(32) VARCHAR2(32) NOT NULL User Password

4 HRS_OPRSTATUS Character(2) VARCHAR2(2) NOT NULL Login Status
10=Active
20=Inactive
30=Duplicate

5 HRS_LOGINCOUNT Number(15,0) DECIMAL(15) NOT NULL Login Count

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	HRS_OPRNAME	Character(70)	VARCHAR2(70) NOT NULL	User Name
3	HRS_OPRPSWD	Character(32)	VARCHAR2(32) NOT NULL	User Password
4	HRS_OPRSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Login Status 10=Active 20=Inactive 30=Duplicate
5	HRS_LOGINCOUNT	Number(15,0)	DECIMAL(15) NOT NULL	Login Count
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.