SCC_AFL_STATUSACT=Active
ERR=Created In Error
INA=Inactive
SCC_AFL_STS_DESCRA=Active
I=Inactive
Y/N Table Edit
N=No
Y=Yes
SCC_AFL_STS_DES(SQL Table) |
Index Back |
|---|---|
Afl Status Descr Setup TableAffiliation Status Description Setup Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_AFL_STATUS |
Character(3) | VARCHAR2(3) NOT NULL |
Affiliation Status
ACT=Active ERR=Created In Error INA=Inactive |
| 2 | SCC_AFL_STS_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Affiliation Status Description |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | SCC_AFL_STS_DESSHR | Character(10) | VARCHAR2(10) NOT NULL | Affiliation Status Descr Short |
| 5 | SCC_AFL_DFL_STSRSN | Character(1) | VARCHAR2(1) NOT NULL |
Affiliation Default Status Reason
Y/N Table Edit |
| 6 | SCC_AFL_PARENT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Default Parent Status description
N=No Y=Yes |