SCC_BRINCD_NLDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
E=External
I=Internal
Default Value: I
Prompt Table: EXT_ORG_TBL
SCC_BRIN_CD_VW(SQL View) |
Index Back |
|---|---|
BRINcode view NLD |
| SELECT A.SCC_BRINCD_NLD , A.EFFDT , A.EFF_STATUS , A.DESCR100 , A.TELEPHN_PERM_AADSA , A.SCC_CIC_CD_NLD , A.SCC_BRINTP_NLD , A.EXT_ORG_ID FROM PS_SCC_BRINCD_NLD A WHERE A.SCC_BRINTP_NLD='I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL | BRINcode |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | TELEPHN_PERM_AADSA | Character(20) | VARCHAR2(20) NOT NULL | AADSAS Telephone |
| 6 | SCC_CIC_CD_NLD | Character(5) | VARCHAR2(5) NOT NULL | School Identification Code |
| 7 | SCC_BRINTP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Brin Type
E=External I=Internal Default Value: I |
| 8 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |