SSR_WRK_EXP_MAP

(SQL Table)
Index Back

Map Work Exp. to Liability

Map work experience to Liability Status.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_WORK_EXP_IND Character(1) VARCHAR2(1) NOT NULL Work experience indicator
0=Not Wholly Work Experience
1=Wholly Work Exp with Charge
2=Wholly Work Exp - Exempt
2 SSR_HECS_XMPT_STAT Character(3) VARCHAR2(3) NOT NULL HECS Exempt Status

Prompt Table: SSR_HECS_EX_VW1

3 SSR_HECS_MAP_TO Character(3) VARCHAR2(3) NOT NULL Maps pre 2005 Liability Status to new values.

Prompt Table: SSR_HECS_EX_VW1