SOCS_AGRMNT_LNG (SQL Table)	Index Back
ESP SS Labor Agreement Table Spain - Social Security Labor Agreement Language Table.

SOCS_AGRMNT_LNG

(SQL Table)

ESP SS Labor Agreement Table

Spain - Social Security Labor Agreement Language Table.

Related Language Record for SOCS_AGRMNT_ESP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOCS_LBR_AGRMT_ESP Character(14) VARCHAR2(14) NOT NULL Social Security Labor Agreement. Special codification following Social Security tables. This info is needed for AFI File.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOCS_LBR_AGRMT_ESP	Character(14)	VARCHAR2(14) NOT NULL	Social Security Labor Agreement. Special codification following Social Security tables. This info is needed for AFI File.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	DESCRLONG	Long Character	CLOB	Long Description