HRS_APP_LOG_HST

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

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

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

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

8 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
4	HRS_OPRNAME	Character(70)	VARCHAR2(70) NOT NULL	User Name
5	HRS_OPRPSWD	Character(32)	VARCHAR2(32) NOT NULL	User Password
6	HRS_OPRSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Login Status 10=Active 20=Inactive 30=Duplicate
7	HRS_LOGINCOUNT	Number(15,0)	DECIMAL(15) NOT NULL	Login Count
8	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.