HRS_APP_LOGIN

#	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(92)	VARCHAR2(92) NOT NULL	User Password
4	HRS_OPRPSWDSALT	Character(88)	VARCHAR2(88) NOT NULL	Operator Password for SALT
5	HRS_OPRSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Login Status 10=Active 20=Inactive 30=Duplicate
6	HRS_LOGINCOUNT	Number(15,0)	DECIMAL(15) NOT NULL	Login Count
7	HRS_ACCTLOCK	Number(1,0)	SMALLINT NOT NULL	To lock out PeopleSoft User Account Default Value: 0
8	HRS_FAILEDLOGINS	Number(3,0)	SMALLINT NOT NULL	Failed Login Attempts Default Value: 0
9	HRS_PERM_ACCTLOCK	Number(1,0)	SMALLINT NOT NULL	To lock out PeopleSoft User Account Default Value: 0
10	HRS_SECRET_ATTEMPT	Number(4,0)	SMALLINT NOT NULL	Maximum Login Attempts to answer secret question Default Value: 0
11	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.
12	HRS_LASTPSWDRESET	DateTime(26)	TIMESTAMP	Specifies the date and time of the last password reset Default Value: %DATETIME