HRS_DIS_ESP_HST

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time
6	END_EFFDT	Date(10)	DATE	End Effdt
7	DISABLE_TYPE_ESP	Character(3)	VARCHAR2(3) NOT NULL	Disability Type F=Physical Disability N=Non Disability P=Psychological Disability S=Sensorial Disability
8	HANDICAP_PCNT_ESP	Number(3,0)	SMALLINT NOT NULL	Handicap Percent
9	DISAB_EVAL_DT_ESP	Date(10)	DATE	Disability Evaluation Dt
10	DISAB_CARD_NO_ESP	Character(10)	VARCHAR2(10) NOT NULL	Disalbility Card No.
11	CARD_ISSUE_DT_ESP	Date(10)	DATE	Card Issue Date
12	CARD_EXP_DT_ESP	Date(10)	DATE	Card Expiration Date
13	DIS_STATUS_OFF_ESP	Character(4)	VARCHAR2(4) NOT NULL	Disability Status Office FST=Social Security Office HFST=Main Social Security Office LAA=Regional Employment Office LRA=District Admin of a Land REGP=Chief Officer - District Admin VA=Land War Pension Office ZST=Document for support of miners
14	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
15	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
16	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
17	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
18	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
19	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id