GVT_SVCDEP_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | GVT_STATUS_ACCT | Character(3) | VARCHAR2(3) NOT NULL |
Status Account
1=Open 2=Cancelled 3=Closed Default Value: 1 |
| 5 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 6 | GVT_SRV_AGENCY | Character(4) | VARCHAR2(4) NOT NULL |
Military Service Agency Translate Values
A=Air Force C=Coast Guard E=Reservist M=Marine Corps N=Navy P=Public Health Service R=Army |
| 7 | FROM_DATE | Date(10) | DATE | From Date |
| 8 | THRU_DATE | Date(10) | DATE | Thru Date |
| 9 | GVT_DESCR8 | Character(8) | VARCHAR2(8) NOT NULL | Total Days in Service |
| 10 | GVT_MILDEP_IAD | Date(10) | DATE | Military Service Interest Accural Date |
| 11 | AMT_OF_EARNS | Number(10,2) | DECIMAL(9,2) NOT NULL | Amount of Earnings |
| 12 | WITHHOLD_PCT | Number(8,2) | DECIMAL(7,2) NOT NULL | Withholding Percentage |
| 13 | GVT_AMT_BAL | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Amount Balance |
| 14 | DEDUCT_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Amount |
| 15 | GVT_MILDEP_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Deduct Deposit
Y/N Table Edit Default Value: N |
| 16 | GVT_RETIRE_PLAN_BB | Character(2) | VARCHAR2(2) NOT NULL |
Used to determine CERS or FERS for Federal Benefits
CS=CERS FS=FERS RS=FERS RAE XS=FERS FRAE |
| 17 | DESCRLONG | Long Character | CLOB | Long Description |